Hi Vforvijay
yeh create checkuser funtion and now check in function same user in entered in ur data base
or not .
public Boolean checkBranch()
{
string constr1;
constr1 = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
con = new SqlConnection(constr1);
con.Open();
string sql = "select * from usermaster where user='" + Txtusername.Text + "' and [Pwd]='"+ Txtpassword.Text +'" + ddlsession.SelectedItem.Text + "'";
cmd = new SqlCommand(sql, con);
rd = cmd.ExecuteReader();
if (rd.Read())
{
return true;
}
else
{
return false;
}
Best Regard's
Prabhakar
Vforvijay, if this helps please login to Mark As Answer. | Alert Moderator