give suitable code for all login controls



give suitable code for all login controls..

Answer / 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

More C Sharp Interview Questions

what does static void Main(string[] args) in C# mean????????

5 Answers   ssinformatics,


What is interface inheritance in c#?

0 Answers  


What is default class in c#?

0 Answers  


C# is case sensitive, what is mean by case sensitive

3 Answers  


When compiler adds a default constructor to a class?

4 Answers   TCS,


What are the different types of assemblies available and their purpose?

0 Answers  


What is HashTable, what is the use of it, when do we use (purpose).

2 Answers  


what are pointer types in c#

0 Answers   Cognizant,


Define MSIL, and how does it works? Why our developers need an appreciation of it if at all?

0 Answers   Siebel,


Can multiple catch blocks be executed?

1 Answers  


what is a destructor?

0 Answers   Amazon,


Is var a data type?

0 Answers  


Categories