scriptking1
New Member
I am logging in using a username and password and this is my code in DAL\[code\]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; } }\[/code\]but i want to return an integer here how can i do it?EDIT::\[code\] Create procedure login(@username varchar (50),@password varchar (50))asbeginselect UserName,password from tblLogin where UserName=@username and password=@passwordend\[/code\]