give suitable code for all login controls
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 |
Can multiple catch blocks be executed?
Which class does the remote object has to inherit?
Which of these string definitions will prevent escaping on backslashes in c#?
What are the two kinds of properties in c#.
What is int32 in c#?
How is lazy loading achieved?
how to print invert pyramid in c#
How to reverse each word in a string using c#?
How to handle exceptions that are raised in a component?
What is toint32 c#?
Which is algorithm is used to Manage the Memory in .net ??
Is a structure a class?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)