Answer Posted / surojit
protected void Login1_Authenticate(object sender,
AuthenticateEventArgs e)
{ string u_id=Login1.UserName;
string pwd=Login1.Password;
SqlConnection con = new
SqlConnection("uid=sa;pwd=nivt;server=.;database=jobportal");
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select *
from rec_registration where rec_username='" + u_id + "'", con);
DataSet ds = new DataSet();
da.Fill(ds);
if (Login1.UserName ==
ds.Tables[0].Rows[0][0].ToString() && Login1.Password ==
ds.Tables[0].Rows[0][1].ToString())
{
Session["rec_uid"] = u_id;
Session["rec_uname"] =
ds.Tables[0].Rows[0][3].ToString();
Session["rec_type"] =
ds.Tables[0].Rows[0][5].ToString();
Response.Redirect("rec_home.aspx");
}
else
{
Label2.Text = "Invalid Username/Password:";
}
}
catch(Exception ex)
{
Label3.Text = ex.Message.ToString();
Label2.Text = "Invalid Username";
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Enlist all the components of an ado.net framework?
Is std :: string null terminated?
what are the contents of an assembly ?
Explain how do I get deterministic finalization in c#?
What is the difference between icomparer and icomparable in c#?
What is the difference between system.text.stringbuilder and system.string?
What is the difference between a method and a property?
Explain async and await?
List some of the common data providers for ado.net framework?
What is distribute by in hive?
Assembly Code. in Rejester AL. How do Contast Replece( or Change): Bit D3 With Bit D4 and Bit D2 With Bit D5 and Bit D1 With Bit D6 and Bit D0 With Bit D7 I am Not Know Very Well Write English.
How can we make a thread sleep for infinite period ?
What is a multicast delegate in c#?
Why do we need properties in c#?
What does console mean c#?