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); } }