Purvi's Blog

How to create a login page in Aspnet with sqlserve

In this article i would like to explain the procedure of creating login page using asp.net and c# with sqlserver .Three main tasks we need to do here.That is Database creation, Login Form Designing and implementing corresponding functionality.So lets start the procedure



First we have to create a database for storing the login information

Open the Sqlserver Management studio

Create a new database and change the database name as db_Login information

Create a New table in that database(db_Logininformation) and change the table name as tab_userinformation

Now, create the following fields

view plainprint?

1. UserID   int         PrimaryKey  
2.   
3. username varchar(50)  
4.   
5. Password varchar(50)  

Next, Enter the some usernames and password directly in the database for checking purpose and save the table

Next ,We need to create a login Screen 

First ,open the Microsoft visual studio 2008

Next,select the Aspnet web application and change the name as Login Page

Next,Open the design page of Login Page That is, Login.aspx Page. Then drag and drop two labels,two textboxes and one button

Next,Open the code page of the Login.aspx.cs

Now,add the three Lines

Sqlconnection con;

Sqlcommand com;

SqlDataReader dr;

Write the following code in the Button event 

view plainprint?

1. protected void Button1_Click(object sender, EventArgs e)  
2.     {        
3.         con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ToString());  
4.         con.Open();  
5.         com = new SqlCommand("select Password from userinformation where Username='" + txt_uname.Text + "'", con);  
6.         dr = com.ExecuteReader();  
7.         if (!dr.Read())  
8.         {  
9.             Response.write("Invalid User");  
10.         }  
11.         else  
12.         {  
13.             if (dr[0].ToString() == txt_pwd.Text)  
14.             {  
15.                 Response.Redirect("~/mainPage.aspx");  
16.             }  
17.             else  
18.             {  
19.                Response.write("Wrong Password");  
20.                txt_pwd.Focus();  
21.             }  
22.         }  
23.   
24.     }  

Finally,Execute the page....That's it...Happy coding

Check it  How to create a Log out Page

Read more: http://www.developerscode.com/2011/02/how-to-create-login-page-in-aspnet-with.html#ixzz2OrGn1xvi