Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static SqlDataReader login(SchoolBAL bal)
- {
- SqlConnection con = DBConnection.OpenConnection();
- try
- {
- int i;
- SqlCommand cmd1 = new SqlCommand("login", con);
- cmd1.CommandType = CommandType.StoredProcedure;
- cmd1.Parameters.AddWithValue("@username", bal.UserName);
- cmd1.Parameters.AddWithValue("@password", bal.Password);
- SqlDataReader dr = cmd1.ExecuteReader();
- return dr;
- }catch (Exception)
- {
- throw;
- }
- }
- Create procedure login
- (@username varchar (50),@password varchar (50))
- as
- begin
- select UserName,password from tblLogin where UserName=@username and password=@password
- end
- public static bool login(SchoolBAL bal)
- {
- bool isFound=false;
- using(SqlConnection con = DBConnection.OpenConnection())
- {
- using(SqlCommand cmd1 = new SqlCommand("login", con))
- {
- cmd1.CommandType = CommandType.StoredProcedure;
- cmd1.Parameters.AddWithValue("@username", bal.UserName);
- cmd1.Parameters.AddWithValue("@password", bal.Password);
- con.Open();
- SqlDataReader dr = cmd1.ExecuteReader();
- if(dr.Read())
- isFound=true;
- dr.Close();
- con.Close();
- }
- }
- return isFound;
- }
- public static int login(SchoolBAL bal)
- {
- SqlConnection con = DBConnection.OpenConnection();
- try
- {
- int i;
- SqlCommand cmd1 = new SqlCommand("login", con);
- cmd1.CommandType = CommandType.StoredProcedure;
- cmd1.Parameters.AddWithValue("@username", bal.UserName);
- cmd1.Parameters.AddWithValue("@password", bal.Password);
- i = cmd1.ExecuteScalar();
- return i;
- }
- catch (Exception)
- {
- throw;
- }
- }
Add Comment
Please, Sign In to add comment