Hai friends now i am going to explain about Login page by checking availability in database or not.If the user enter the username and password it check in the database if it is valid it redirect to ("HomePage.aspx") otherwise it dispaly the message as "Invalid User Name or Password".
Step 1: Login Page which is give below:
To implement this one first design table like this:
Step :2 Writing Stored Procedure For Login Control
The COUNT() function returns the number of rows
that matches a specified criteria
Stored Procedure for Login Form:-
create procedure splogin
@spemailid varchar(30),@sppassword varchar(30)
as
Begin
Select COUNT(*)from student1 where
email=@spemailid and
password=@sppassword
End
Step 3: Designing Login Page using asp.net and html controls
<div align="center">
<fieldset style="width: 350px">
<legend>Login Page </legend>
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
<br />
<br />
<table>
<tr>
<td><b>Enter User Name</b>
</td>
<td>:
</td>
<td>
<asp:TextBox ID="TextBox1" runat="server" BackColor="#FF5050"></asp:TextBox></td>
<td></td>
</tr>
<tr>
<td><b>Enter password</b>
</td>
<td>:
</td>
<td>
<asp:TextBox ID="TextBox2" runat="server" TextMode="Password"
BackColor="#FF5050"></asp:TextBox></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td>
<br />
</td>
</tr>
<tr>
<td></td>
<td>
<br />
</td>
<td>
<asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click1"/>
<asp:Button ID="Button2" runat="server" Text="Cancel" />
</td>
</tr>
</table>
<h3>Check Username and Password
availability in database</h3>
</fieldset>
</div>
Step :4 Code For Login Page.aspx.cs page
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand("splogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@spemailid", TextBox1.Text);
cmd.Parameters.AddWithValue("@sppassword", TextBox2.Text);
con.Open();
int usercount = (Int32)cmd.ExecuteScalar();// for taking single value
if (usercount == 1) // comparing users from table
{
Response.Redirect("HomePage.aspx"); //for sucsseful login
}
else
{
con.Close();
Label1.Text = "Invalid User Name or
Password"; //for invalid login
}
}
