Posted on: 12/22/2013 4:20:32 PM | Views : 666

//code in DAL
public List<SignUp> getLogin() { List<SignUp> loginAccount = new List<SignUp>();
string username, password; string queryStr = null;
if (_username != "" && _password != "") queryStr = "SELECT * FROM SignUp WHERE Username = '%" + _username + "%' AND Password = '" + _password + "'";
SqlConnection conn = new SqlConnection(_connStr); SqlCommand cmd = new SqlCommand(queryStr, conn);
conn.Open(); SqlDataReader dr = cmd.ExecuteReader();  
while (dr.Read()) { username = dr["Username"].ToString(); password = dr["Password"].ToString();
loginAccount.Add(new SignUp(username,password)); }
conn.Close(); dr.Close(); dr.Dispose();
return loginAccount; }
//code in BLL
public List<SignUp> loginAc ...

Go to the complete details ...