User1113074264 posted
Hi,
I'm having problem with my userlogin control.it is connected to database .i don't know what is the error.i want to display the name of user after he has logged in.the login display changed into logout.how to include these into my login control ?
protected void Login1_Authenticate1(object sender, AuthenticateEventArgs e)
{
string userName = Login1.UserName;
string password = Login1.Password;
bool result = UserLogin(userName, password);
if ((result))
{
e.Authenticated = true;
}
else
{
e.Authenticated = false;
}
}
private bool UserLogin(string userName, string password)
{
// read the coonection string from web.config
string conString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;
using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(conString))
{
//' declare the command that will be used to execute the select statement
SqlCommand com = new SqlCommand("SELECT CustomerId FROM Customer WHERE CustomerId = @CustomerId AND Password = @Password", con);
// set the username and password parameters
com.Parameters.Add("@CustomerId", SqlDbType.VarChar).Value = userName;
com.Parameters.Add("@Password", SqlDbType.VarChar).Value = password;
con.Open();
//' execute the select statment
string result = Convert.ToString(com.ExecuteScalar());
//' check the result
if (string.IsNullOrEmpty(result))
{
//invalid user/password , return flase
return false;
}
else
{
// valid login
return true;
}
}
}
