private bool validatelogin(string user, string pass)
{
con.OpenConection();
con.ExecSqlQuery("SELECT * FROM users WHERE empno=@user COLLATE SQL_Latin1_General_CP1_CS_AS AND password=@pass COLLATE SQL_Latin1_General_CP1_CS_AS");
con.Cmd.Parameters.AddWithValue("@user", user);
con.Cmd.Parameters.AddWithValue("@pass", GetHashedText(pass));
con._dr = con.Cmd.ExecuteReader();
if (con._dr.Read())
{
con.CloseConnection();
return(true);
}
else
{
con.CloseConnection();
return(false);
}
}
private bool validatelogin(string user, string pass)
{
con.OpenConection();
con.ExecSqlQuery("Select * From users where empno=@user COLLATE SQL_Latin1_General_CP1_CS_AS and password=@pass COLLATE SQL_Latin1_General_CP1_CS_AS");
con.Cmd.Parameters.AddWithValue("@user", user);
con.Cmd.Parameters.AddWithValue("@pass", pass);
con._dr = con.Cmd.ExecuteReader();
if (con._dr.Read())
{
con.CloseConnection();
return(true);
}
else
{
con.CloseConnection();
return(false);
}
}
