{"id":4575,"date":"2023-02-20T12:16:33","date_gmt":"2023-02-20T12:16:33","guid":{"rendered":"https:\/\/isophal.com\/?p=4575"},"modified":"2023-02-20T12:16:35","modified_gmt":"2023-02-20T12:16:35","slug":"ado-net-web-form-example","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2023\/02\/20\/4575.html\/","title":{"rendered":"ADO.NET Web Form Example"},"content":{"rendered":"\n

We can create a web form that has ADO.NET connectivity. A simple web form that has form controls can be submitted to the server. ADO.NET allows us to store the submitted values to store into SQL Server database.<\/p>\n\n\n\n

Here, we are creating a web form application that connects to the SQL Server database.<\/p>\n\n\n\n

This web form contains the following source code.<\/p>\n\n\n\n

WebForm<\/h3>\n\n\n\n

\/\/ WebFormAdoNet.aspx<\/strong><\/p>\n\n\n\n

    \n
  1. <<\/strong>%@ Page Language=”C#” AutoEventWireup=”true” CodeBehind=”WebFormAdoNet.aspx.cs”   <\/li>\n\n\n\n
  2. Inherits=”ado.netWebFormExample.WebFormAdoNet” %><\/strong>  <\/li>\n\n\n\n
  3. <!DOCTYPE html><\/strong>  <\/li>\n\n\n\n
  4. <<\/strong>html<\/strong> xmlns=”http:\/\/www.w3.org\/1999\/xhtml”><\/strong>  <\/li>\n\n\n\n
  5. <<\/strong>head<\/strong> runat=”server”><\/strong>  <\/li>\n\n\n\n
  6.     <<\/strong>title<\/strong>><\/strong><\/<\/strong>title<\/strong>><\/strong>  <\/li>\n\n\n\n
  7.     <<\/strong>style<\/strong> type=”text\/css”><\/strong>  <\/li>\n\n\n\n
  8.         .auto-style1 {  <\/li>\n\n\n\n
  9.             width: 100%;  <\/li>\n\n\n\n
  10.         }  <\/li>\n\n\n\n
  11.         .auto-style2 {  <\/li>\n\n\n\n
  12.             width: 100px;  <\/li>\n\n\n\n
  13.         }  <\/li>\n\n\n\n
  14.         .auto-style3 {  <\/li>\n\n\n\n
  15.             width: 95px;  <\/li>\n\n\n\n
  16.         }  <\/li>\n\n\n\n
  17.     <\/<\/strong>style<\/strong>><\/strong>  <\/li>\n\n\n\n
  18. <\/<\/strong>head<\/strong>><\/strong>  <\/li>\n\n\n\n
  19. <<\/strong>body<\/strong>><\/strong>  <\/li>\n\n\n\n
  20.     <<\/strong>form<\/strong> id=”form1″ runat=”server”><\/strong>  <\/li>\n\n\n\n
  21.         <<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
  22.             <<\/strong>table<\/strong> class=”auto-style1″><\/strong>  <\/li>\n\n\n\n
  23.                 <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  24.                     <<\/strong>td<\/strong> class=”auto-style2″><\/strong>  <\/li>\n\n\n\n
  25.                        <<\/strong>asp:Label<\/strong> runat=”server” Text=”User Name” ID=”usernamelabelId”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  26.                     <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  27.                        <<\/strong>asp:TextBox<\/strong> ID=”UsernameId” runat=”server”><\/strong><\/<\/strong>asp:TextBox<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  28.                 <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  29.                 <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  30.                     <<\/strong>td<\/strong> class=”auto-style2″><\/strong>  <\/li>\n\n\n\n
  31.                         <<\/strong>asp:Label<\/strong> runat=”server” Text=”Email ID”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  32.                     <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  33.                         <<\/strong>asp:TextBox<\/strong> ID=”EmailId” runat=”server”><\/strong><\/<\/strong>asp:TextBox<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  34.                 <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  35.                 <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  36.                     <<\/strong>td<\/strong> class=”auto-style2″><\/strong>  <\/li>\n\n\n\n
  37.                         <<\/strong>asp:Label<\/strong> runat=”server” Text=”Contact”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  38.                     <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  39.                         <<\/strong>asp:TextBox<\/strong> ID=”ContactId” runat=”server”><\/strong><\/<\/strong>asp:TextBox<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  40.                 <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  41.                 <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  42.                     <<\/strong>td<\/strong> class=”auto-style2″><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  43.                     <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  44.                         <<\/strong>asp:Button<\/strong> ID=”ButtonId” runat=”server” Text=”Submit” OnClick=”ButtonId_Click” \/><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  45.                 <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  46.             <\/<\/strong>table<\/strong>><\/strong>  <\/li>\n\n\n\n
  47.         <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
  48.     <<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
  49.         <<\/strong>asp:Label<\/strong> ID=”Label1″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong>  <\/li>\n\n\n\n
  50.     <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
  51.     <\/<\/strong>form<\/strong>><\/strong>  <\/li>\n\n\n\n
  52.     <<\/strong>table<\/strong> class=”auto-style1″><\/strong>  <\/li>\n\n\n\n
  53.         <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  54.             <<\/strong>td<\/strong> class=”auto-style3″><\/strong>  <\/li>\n\n\n\n
  55.                 <<\/strong>asp:Label<\/strong> ID=”Label2″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  56.             <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  57.                 <<\/strong>asp:Label<\/strong> ID=”Label5″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  58.         <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  59.         <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  60.             <<\/strong>td<\/strong> class=”auto-style3″><\/strong>  <\/li>\n\n\n\n
  61.                 <<\/strong>asp:Label<\/strong> ID=”Label3″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  62.             <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  63.                 <<\/strong>asp:Label<\/strong> ID=”Label6″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  64.         <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  65.         <<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  66.             <<\/strong>td<\/strong> class=”auto-style3″><\/strong>  <\/li>\n\n\n\n
  67.                 <<\/strong>asp:Label<\/strong> ID=”Label4″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  68.             <<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  69.                 <<\/strong>asp:Label<\/strong> ID=”Label7″ runat=”server”><\/strong><\/<\/strong>asp:Label<\/strong>><\/strong><\/<\/strong>td<\/strong>><\/strong>  <\/li>\n\n\n\n
  70.         <\/<\/strong>tr<\/strong>><\/strong>  <\/li>\n\n\n\n
  71.     <\/<\/strong>table<\/strong>><\/strong>  <\/li>\n\n\n\n
  72.     <\/<\/strong>body<\/strong>><\/strong>  <\/li>\n\n\n\n
  73. <\/<\/strong>html<\/strong>><\/strong>  <\/li>\n<\/ol>\n\n\n\n

    CodeBehind<\/h3>\n\n\n\n

    \/\/ WebFormAdoNet.aspx.cs<\/strong><\/p>\n\n\n\n

      \n
    1. using<\/strong> System;  <\/li>\n\n\n\n
    2. using<\/strong> System.Data.SqlClient;  <\/li>\n\n\n\n
    3. namespace<\/strong> ado.netWebFormExample  <\/li>\n\n\n\n
    4. {  <\/li>\n\n\n\n
    5.     public<\/strong> partial class<\/strong> WebFormAdoNet : System.Web.UI.Page  <\/li>\n\n\n\n
    6.     {  <\/li>\n\n\n\n
    7.         protected<\/strong> void<\/strong> Page_Load(object<\/strong> sender, EventArgs e)  <\/li>\n\n\n\n
    8.         {  <\/li>\n\n\n\n
    9.         }  <\/li>\n\n\n\n
    10.         protected<\/strong> void<\/strong> ButtonId_Click(object<\/strong> sender, EventArgs e)  <\/li>\n\n\n\n
    11.         {  <\/li>\n\n\n\n
    12.             SqlConnection con = null<\/strong>;  <\/li>\n\n\n\n
    13.             try<\/strong>  <\/li>\n\n\n\n
    14.             {  <\/li>\n\n\n\n
    15.                 \/\/ Creating Connection  <\/li>\n\n\n\n
    16.                 con = new<\/strong> SqlConnection(“data source=.; database=student; integrated security=SSPI”);  <\/li>\n\n\n\n
    17.                 \/\/ Writing insert query  <\/li>\n\n\n\n
    18.                 string<\/strong> query = “insert into student(name,email,contact)values(‘”+UsernameId.Text+ “‘,  <\/li>\n\n\n\n
    19.                 ‘” + EmailId.Text + “‘,'” + ContactId.Text + “‘)”;  <\/li>\n\n\n\n
    20.                 SqlCommand sc = new<\/strong> SqlCommand(query,con);  <\/li>\n\n\n\n
    21.                 \/\/ Opening connection  <\/li>\n\n\n\n
    22.                 con.Open();  <\/li>\n\n\n\n
    23.                 \/\/ Executing query  <\/li>\n\n\n\n
    24.                 int<\/strong> status = sc.ExecuteNonQuery();  <\/li>\n\n\n\n
    25.                 Label1.Text = “Your record has been saved with the following details!”;  <\/li>\n\n\n\n
    26.                 \/\/ ———————– Retrieving Data —————— \/\/  <\/li>\n\n\n\n
    27.                 SqlCommand cm = new<\/strong> SqlCommand(“select top 1 * from student”, con);  <\/li>\n\n\n\n
    28.                 \/\/ Executing the SQL query  <\/li>\n\n\n\n
    29.                 SqlDataReader sdr = cm.ExecuteReader();  <\/li>\n\n\n\n
    30.                 sdr.Read();  <\/li>\n\n\n\n
    31.                     Label2.Text = “User Name”; Label5.Text = sdr[“name”].ToString();  <\/li>\n\n\n\n
    32.                     Label3.Text = “Email ID”;  Label6.Text = sdr[“email”].ToString();  <\/li>\n\n\n\n
    33.                     Label4.Text = “Contact”;   Label7.Text = sdr[“contact”].ToString();                  <\/li>\n\n\n\n
    34.             }  <\/li>\n\n\n\n
    35.             catch<\/strong> (Exception ex)  <\/li>\n\n\n\n
    36.             {  <\/li>\n\n\n\n
    37.                 Console.WriteLine(“OOPs, something went wrong.” + ex);  <\/li>\n\n\n\n
    38.             }  <\/li>\n\n\n\n
    39.             \/\/ Closing the connection  <\/li>\n\n\n\n
    40.             finally<\/strong>  <\/li>\n\n\n\n
    41.             {  <\/li>\n\n\n\n
    42.                 con.Close();  <\/li>\n\n\n\n
    43.             }            <\/li>\n\n\n\n
    44.         }  <\/li>\n\n\n\n
    45.     }  <\/li>\n\n\n\n
    46. }  <\/li>\n<\/ol>\n\n\n\n

      Output:<\/p>\n\n\n\n

      It produces the following output to the browser.<\/p>\n\n\n\n

      \"ADO<\/figure>\n\n\n\n

      Fill the form and submit data.<\/p>\n\n\n\n

      \"ADO<\/figure>\n\n\n\n

      After submitting, it store and retrieve the data from the SQL Server database.<\/p>\n\n\n\n

      \"ADO<\/figure>\n","protected":false},"excerpt":{"rendered":"

      We can create a web form that…<\/p>\n","protected":false},"author":1,"featured_media":4576,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189,140],"tags":[578,191,572],"class_list":["post-4575","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net","category-programming","tag-ado-net","tag-asp-net","tag-web-form"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=4575"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4575\/revisions"}],"predecessor-version":[{"id":4577,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4575\/revisions\/4577"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/4576"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=4575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=4575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=4575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}