////DAL public DataTable LoadUserName() { DataTable dTable = null; try { con.Open(); String selectStr = "select uCode,uID,uPassword from tUsers"; SqlDataAdapter da = new SqlDataAdapter(selectStr, con); dTable = new DataTable(); da.Fill(dTable); con.Close(); } catch (Exception e) { String Str = e.Message; } return dTable; } ///BAL public bool authenticate(string username, string password) { LoginDAL dal = new LoginDAL(); DataTable dTable = dal.LoadUserName(); bool found = false; foreach (DataRow dRow in dTable.Rows) ///Getting error on this line { if ((username == dRow["uID"].ToString()) && password == dRow["uPassword"].ToString()) { userID =Convert.ToInt32(dRow["uCode"].ToString()); found = true; } } if (!found) { return false; } return found; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)