Click here to Skip to main content
11,640,125 members (68,856 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET Visual-Studio , +
I have created a web form with the login control. Now I want to validate the UserName & the Password with the data on a table in a SQL database (username & password as the fields of the table). I am new to ASP.Net & I need your help thanks.

I am using VS 2010 .net Framework 4.0 in win 7 professional 64 bit! SQl server 2008 R2 Developer
Posted 5-May-13 6:35am
ThePhantomUpvoter at 5-May-13 14:24pm
Okay so connect to your database, write a query and execute it.
Chiranthaka Sampath at 5-May-13 20:45pm
Ok then what method of that login control to use?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

You can have a look at How to implement forms authentication and Managing users with roles. There are functionalities available in Asp.NET for user authentication.

Possible method using database:

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["leave"].ConnectionString;
string uname = TextBox1.Text;
string ps = Textbox2.Text;
SqlCommand cmd = new SqlCommand("Select uname, pswd from emp_details where uname =@uname and pswd =@ps", conn);
cmd.Parameters.Add(new SqlParameter("@uname", "id here"));
cmd.Parameters.Add(new SqlParameter("@ps", "password here"));
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
       /*Perform operations for authenticated users*/
-Additional note:

Its advisable to store password in encrypted format in database(Not as plain text). You can make use of algorithm. For example, have a look at Simple String Encryption and Decryption
Chiranthaka Sampath at 6-May-13 3:21am
Ok I have visited that and then I want to validate that login control's username and the password from a table that in a SQL database. Then how am I going to do that? Please help me!
Rohan Leuva at 6-May-13 3:29am
Refer to updated answer. You can accept that answer if it helps you.
Chiranthaka Sampath at 6-May-13 4:01am
In here you have develop the code using some sort of new textboxes and buttons but in my case I want to use the Login control of the tools of the VS 2010 and I need the help to add the database to this Login control. Remember that this as ASP.Net form ASP.Net uses the Login control!
Rohan Leuva at 6-May-13 4:43am
Refer to this link Login Controls

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Suvendu Shekhar Giri 225
1 F-ES Sitecore 170
2 CPallini 167
3 Sergey Alexandrovich Kryukov 144
4 himanshu agarwal 142
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558

Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 6 May 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100