Dear Deepshika
Can you kindly post what you have tried so far to solve the mentioned problem.
<HTML>
<HEAD>
<title>Login</title>
<meta name="GENERATOR " Content="Micros oft Visual Studio .NET 7.1">
<meta name="CODE_LANG UAGE" Content="C#">
<meta name="vs_defaul tClientScript" content="JavaSc ript">
<meta name="vs_target Schema" content="http://schemas.microso ft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING= "GridLayout ">
<form id="Form1" method="post" runat="server">
<table id="mainTable" border="0" style="Z-INDEX: 103; LEFT: 544px; WIDTH: 264px; POSITION: absolute; TOP: 96px; HEIGHT: 296px">
<TBODY>
<tr>
<td>
<table class="t_border " id="loginTable " cellspacing="15 " cellpadding="0" >
<tr>
<td align="center" colspan="2"><b> USER LOGIN</b></td>
</tr>
<tr>
<td><b>Login: </b>
</td>
<td><asp:textbo x id="txtUserName " runat="server" width="128px" BackColor="Ligh tGray" Font-Bold="True"></asp:textbox><as p:requiredfield validator id="rvUserValid ator" runat="server" controltovalida te="txtUserName " errormessage="Y ou Must Enter a EmployeeId!"
display="None"> *</asp:requiredfie ldvalidator></td>
</tr>
<tr>
<td style="HEIGHT: 23px"><b>Passwo rd: </b>
</td>
<td style="HEIGHT: 23px"><asp:text box id="txtPassword " runat="server" width="128px" textmode="Passw ord" BackColor="Ligh tGray"
Font-Bold="True"></asp:textbox><as p:requiredfield validator id="rvPasswordV alidator" runat="server" controltovalida te="txtPassword " errormessage="E mpty Passwords not accepted"
display="None"> *</asp:requiredfie ldvalidator></td>
</tr>
<tr>
<td align="center" colspan="2"><as p:button id="cmdSubmit" runat="server" text="Submit" borderstyle="So lid" Font-Bold="True"></asp:button></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table id="messageDisp lay">
<tr>
<td><asp:valida tionsummary id="Validations ummary1" runat="server" width="248px" displaymode="Bu lletList" Height="40px"></asp:validations ummary></td>
</tr>
</table>
</td>
</tr>
</TBODY>
</table>
</form>
<asp:label id="lblMessage2 " runat="server" width="264px" font-bold="True" font-italic="True"
font-size="Medium" forecolor="#C00 000" style="Z-INDEX: 101; LEFT: 544px; POSITION: absolute; TOP: 432px"></asp:label>
<asp:label id="lblMessage " runat="server" width="264px" font-bold="True" font-italic="True"
font-size="Medium" forecolor="#C00 000" style="Z-INDEX: 102; LEFT: 544px; POSITION: absolute; TOP: 400px"></asp:label></TR></TBODY></TABLE>
</body>
</HTML>
private void cmdSubmit_Click (object sender, System.EventArg s e)
{
if (Page.IsValid)
{
if (DBConnection(t xtUserName.Text .Trim(), txtPassword.Tex t.Trim()))
{
FormsAuthentica tion.RedirectFr omLoginPage (txtUserName.Te xt, false);
Response.Redire ct ("Success.aspx" );
}
else
{
lblMessage.Text = "Invalid Login, please try again!";
}
}
}
private bool DBConnection(st ring txtUser, string txtPass)
{
SqlConnection myConn = new SqlConnection(C onfigurationSet tings.AppSettin gs["strConn"]);
SqlCommand myCmd = new SqlCommand("Val idateUser", myConn);
myCmd.CommandTy pe = CommandType.Sto redProcedure;
SqlParameter objParam1;
SqlParameter objParam2;
SqlParameter returnParam;
objParam1 = myCmd.Parameter s.Add ("@EmployeeNumb er", SqlDbType.VarCh ar);
objParam2 = myCmd.Parameter s.Add ("@EMPPassword" , SqlDbType.VarCh ar);
returnParam = myCmd.Parameter s.Add ("@Num_of_User" , SqlDbType.Int);
objParam1.Direc tion = ParameterDirect ion.Input;
objParam2.Direc tion = ParameterDirect ion.Input;
returnParam.Dir ection = ParameterDirect ion.ReturnValue ;
objParam1.Value = txtUser;
objParam2.Value = txtPass;
try
{
if (myConn.State.E quals(Connectio nState.Closed))
{
myConn.Open();
myCmd.ExecuteNo nQuery();
}
if ((int)returnPar am.Value < 1)
{
lblMessage.Text = "Invalid Login!";
return false;
}
else
{
myConn.Close();
return true;
}
}
catch (Exception ex)
{
lblMessage2.Tex t = ex + "Error Connecting to the database";
return false;
}
}
7
