How To Create Login Page In ASP.NET Web Application Using C# And SQL Server

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            width: 100%;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <p>
            <table class="auto-style1">
                <tr>
                    <td colspan="6" style="text-align: center; vertical-align: top">
                        <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Size="XX-Large" Font-Underline="True" Text="Log In"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td></td>
                    <td style="text-align: center">
                        <asp:Label ID="Label2" runat="server" Font-Size="X-Large" Text="UserId:"></asp:Label>
                    </td>
                    <td style="text-align: center">
                        <asp:TextBox ID="TextBox1" runat="server" Font-Size="X-Large"></asp:TextBox>
                    </td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td></td>
                    <td style="text-align: center">
                        <asp:Label ID="Label3" runat="server" Font-Size="X-Large" Text="Password:"></asp:Label>
                    </td>
                    <td style="text-align: center">
                        <asp:TextBox ID="TextBox2" runat="server" Font-Size="X-Large" TextMode="Password"></asp:TextBox>
                    </td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td></td>
                    <td></td>
                    <td style="text-align: center">
                        <asp:Button ID="Button1" runat="server" BorderStyle="None" Font-Size="X-Large" OnClick="Button1_Click" Text="Log In" />
                    </td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td></td>
                    <td></td>
                    <td>
                        <asp:Label ID="Label4" runat="server" Font-Size="X-Large"></asp:Label>
                    </td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>
            </table>
        </p>
    </form>
</body>
</html>

Step 3. Let’s create a connection between the Web Application and SQL Server.

Double-click on the login button. Prior to doing this, open the web config file, and write add connection code as given below.

<connectionStrings>
  <add name="mycon" connectionString="server=KRISHNA\SQLEXPRESS;database=abcd;integrated security=true;" />
</connectionStrings>

Write the source code for the connection, and add a namespace for the SQL Server.

using System.Data.SqlClient; // This namespace is for SQL Server Client
using System.Configuration; // This namespace is for adding connection name in the web config file (config connection name)

Create a SQL connection object with the connection name and write the code given below.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ToString());

Adding a Button Click Event Handler

The Click attribute of the button element adds the click event handler. The code given below adds the click event handler for a button.

<td style="text-align: center">
    <asp:Button ID="Button1" runat="server" BorderStyle="None" Font-Size="X-Large" OnClick="Button1_Click" Text="Log In" />
</td>

The code for the click event handler looks as shown below.

protected void Button1_Click(object sender, EventArgs e)
{
    // Your event handler code here
}

Now, whatever code you write in the click event handler, will be executed at the click of a button.

private void DrawCircleButton_Click(object sender, RoutedEventArgs e)
{
    try
    {
        string uid = TextBox1.Text;
        string pass = TextBox2.Text;
        con.Open();
        string qry = "SELECT * FROM Ulogin WHERE UserId='" + uid + "' AND Password='" + pass + "'";
        SqlCommand cmd = new SqlCommand(qry, con);
        SqlDataReader sdr = cmd.ExecuteReader();
        if (sdr.Read())
        {
            Label4.Text = "Login Success......!!";
        }
        else
        {
            Label4.Text = "UserId & Password Is not correct. Try again..!!";
        }
        con.Close();
    }
    catch (Exception ex)
    {
        Response.Write(ex.Message);
    }
}

Output

Summary

In this article, I discussed how to create a login page in ASP.NET Web Application, using C# connectivity by SQL Server. We also saw how we create a database and a table. Afterward, we saw how to design the ASP.NET login view and its properties to insert the table. At the end of this article, we saw how to connect an ASP.NET Web Application to an SQL server. My next article will discuss how to validate the textbox, so stay tuned.