Connecting ASP.Net Login Control With SQl Server 2008 R2 Developer

Question

0.00/5 (No votes)

See more:

, +

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

Chiranthaka Sampath

Add a Solution

Comments

[no name] 5-May-13 14:24pm

Okay so connect to your database, write a query and execute it.

Chiranthaka Sampath 5-May-13 20:45pm

Ok then what method of that login control to use?

3 solutions

Solution 2

try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SampleConnectionString"].ToString());
con.Open();
SqlCommand com = new SqlCommand("select password from Registration where username='" + Txtusername.Text + "'", con);
SqlDataReader dr = com.ExecuteReader();
if (!dr.Read())
{
labLogin.Text = ("Invalid User");
}
else
{
if (dr[0].ToString() == Txtpassword.Text)
{
Response.Redirect("Select.aspx");
}
else
{
labLogin.Text = ("Wrong Password");
Txtpassword.Focus();
}
}
}
catch (Exception ex)
{
labLogin.Text = "ex" + ex.Message;
}

Posted 7-Aug-15 19:36pm

Md. Shohag Mia

Solution 3

For Your Question comment
>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!
I guess is this ur requirement.

C#

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connection"].ConnectionString;
conn.Open();
string username = TextBox1.Text;
string password = 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", "username"));
cmd.Parameters.Add(new SqlParameter("@ps", "password"));
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
       dr.close();
       //Your Homepage or Ur need;
//Eg:// Response.Redirect("Home.aspx");
// As a beginner the above one is enough in future u have to show the user name in the further pages like  Hi Chiranthaka Sampath in the next pages u have to move with Session.
Session["username"] = txtusername.Text;
 Session["password"] = txtpassword.Text;
//My means of Session wherever u show the name u can get from the Session..

}
else
{
 dr.close();
msg.Showalert("Invalid username or password");
}
con.close();
}

Posted 7-Aug-15 20:23pm

Arasappan

Updated 7-Aug-15 20:30pm

v5

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Thanks7872 · Accepted Answer · 2013-05-05T17:48:00

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:

C#

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["leave"].ConnectionString;
conn.Open();
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