ADO.Net Web Form Example

ADO Net Web Form Example with introduction, data providers, sql server connectivity, connection, command, datareader, dataset, dataadapter, datatables, web form examples, mvc examples etc.

<< Back to ADO

next → ← prev

ADO.NET Web Form Example

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.

Here, we are creating a web form application that connects to the SQL Server database.

This web form contains the following source code.

WebForm

// WebFormAdoNet.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebFormAdoNet.aspx.cs" 
Inherits="ado.netWebFormExample.WebFormAdoNet" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            width: 100%;
        }
        .auto-style2 {
            width: 100px;
        }
        .auto-style3 {
            width: 95px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table class="auto-style1">
                <tr>
                    <td class="auto-style2">
                       <asp:Label runat="server" Text="User Name" ID="usernamelabelId"></asp:Label></td>
                    <td>
                       <asp:TextBox ID="UsernameId" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td class="auto-style2">
                        <asp:Label runat="server" Text="Email ID"></asp:Label></td>
                    <td>
                        <asp:TextBox ID="EmailId" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td class="auto-style2">
                        <asp:Label runat="server" Text="Contact"></asp:Label></td>
                    <td>
                        <asp:TextBox ID="ContactId" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td class="auto-style2"></td>
                    <td>
                        <asp:Button ID="ButtonId" runat="server" Text="Submit" OnClick="ButtonId_Click" /></td>
                </tr>
            </table>
        </div>
    <div>
        <asp:Label ID="Label1" runat="server"></asp:Label>
    </div>
    </form>
    <table class="auto-style1">
        <tr>
            <td class="auto-style3">
                <asp:Label ID="Label2" runat="server"></asp:Label></td>
            <td>
                <asp:Label ID="Label5" runat="server"></asp:Label></td>
        </tr>
        <tr>
            <td class="auto-style3">
                <asp:Label ID="Label3" runat="server"></asp:Label></td>
            <td>
                <asp:Label ID="Label6" runat="server"></asp:Label></td>
        </tr>
        <tr>
            <td class="auto-style3">
                <asp:Label ID="Label4" runat="server"></asp:Label></td>
            <td>
                <asp:Label ID="Label7" runat="server"></asp:Label></td>
        </tr>
    </table>
    </body>
</html>

CodeBehind

// WebFormAdoNet.aspx.cs

using System;
using System.Data.SqlClient;
namespace ado.netWebFormExample
{
    public partial class WebFormAdoNet : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void ButtonId_Click(object sender, EventArgs e)
        {
            SqlConnection con = null;
            try
            {
                // Creating Connection
                con = new SqlConnection("data source=.; database=student; integrated security=SSPI");
                // Writing insert query
                string query = "insert into student(name,email,contact)values('"+UsernameId.Text+ "',
                '" + EmailId.Text + "','" + ContactId.Text + "')";
                SqlCommand sc = new SqlCommand(query,con);
                // Opening connection
                con.Open();
                // Executing query
                int status = sc.ExecuteNonQuery();
                Label1.Text = "Your record has been saved with the following details!";
                // ----------------------- Retrieving Data ------------------ //
                SqlCommand cm = new SqlCommand("select top 1 * from student", con);
                // Executing the SQL query
                SqlDataReader sdr = cm.ExecuteReader();
                sdr.Read();
                    Label2.Text = "User Name"; Label5.Text = sdr["name"].ToString();
                    Label3.Text = "Email ID";  Label6.Text = sdr["email"].ToString();
                    Label4.Text = "Contact";   Label7.Text = sdr["contact"].ToString();                
            }
            catch (Exception ex)
            {
                Console.WriteLine("OOPs, something went wrong." + ex);
            }
            // Closing the connection
            finally
            {
                con.Close();
            }          
        }
    }
}

Output:

It produces the following output to the browser.

Fill the form and submit data.

After submitting, it store and retrieve the data from the SQL Server database.

Next TopicADO.NET MVC Example

← prev next →

.Net

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Java

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

TheDeveloperBlog.com