- HubPages»
- Technology»
- Computers & Software»
- Computer Science & Programming
How to create Login Form in ASP.NET?
Lets assume that we have a Login Form as shown below:
In the above figure, two Labels, two TextBoxes and one Button is used. First, we need to set the following control's properties:
Controls
| Properties
|
|---|---|
Label1
| ID: User
|
Text: User Name
| |
Label2
| ID: Pass
|
Text: Password
| |
TextBox1
| ID: UserName
|
TextMode: SingleLine
| |
TextBox2
| ID: Password
|
TextMode: Password
| |
Button1
| ID: Submit
|
Text: Submit
|
Validators to be used:
- RequiredFieldValidator
- ValidationSummary
Field Name
| Validator
| Properties
|
|---|---|---|
User Name
| RequiredFieldValidator
| ID: UName_Validator
|
ControlToValidate: UserName
| ||
Display: None
| ||
ErrorMessage: User Name can't be blank
| ||
Password
| RequiredFieldValidator
| ID: Pass_Validator
|
ControlToValidate: Password
| ||
Display: None
| ||
ErrorMessage: Password can't be blank
| ||
ValidationSummary
| ID: Summary
| |
ShowMessageBox: True
| ||
ShowSummary: False
|
After setting above properties, click on the Submit button and add the following code in the codebehind (.cs or .vb) file:
C#
using System.Data;
using System.Data.SqlClient;
namespace Student
{
public partial class LoginForm : System.Web.UI.Page
{
protected void Submit_Click(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection("server=myDB; uid=sa;
pwd=password; database=master");
connection.Open();
String User = UserName.Text;
String Pass = Password.Text;
SqlCommand command = new SqlCommand("select count(*) from Login_Form
where UserName = '"+User+"' and Password = '"+Pass+"'",connection);
SqlDataReader dataReader = command.ExecuteReader();
while(dataReader.Read())
{
if(dataReader.GetValue(0).ToString() == "1")
{
Response.Redirect("Welcome.aspx");
}
else
{
Response.Write("<script>
alert('Invalid User Name/Password)");
</script>");
}
}
}
}
}VB
Imports System.Data
Imports System.Data.SqlClient
Partial Public Class LoginForm
Inherits System.Web.UI.Page
Protected Sub Submit_Click(ByVal sender As Object,ByVal e As
EventArgs)Handles Submit.Click
Dim connection As SqlConnection = New SqlConnection("server=myDB;
uid=sa; pwd=password;database=master")
connection.Open()
Dim User As String = UserName.Text
Dim Pass As String = Password.Text
Dim command As SqlCommand = New SqlCommand("select count(*) from
Login_Form where UserName='" +User+"' and Password= '"+ Pass+"'",
connection)
Dim dataReader As SqlDataReader = command.Execute.Reader()
While(dataReader.Read())
If(dataReader.GetValue(0).ToString() = "1") Then
Response.Redirect("Welcome.aspx")
Else
Response.Write("<script>
alert('Invalid User Name/Password');
</script>")
End If
End While
End Sub
End ClassIf User Name and Password both matches with the User Name and Password that are stored in the database, then 'Welcome.aspx' page would be opened. If User Name and Password both or any one of them does not match, then it would show an error message.
