// get all user records public List <UserDTO> GetAllUser() { // list for storing user objects List <UserDTO> userList = new List <UserDTO>(); try { // get all rows in the table using query tabUserTableAdapter.Fill(tabUserDataTable); // convert rows into objects foreach (DataRow userRow in tabUserDataTable.Rows) { UserDTO user = new UserDTO { UID = (int)userRow[0], UserName = (string)userRow[1], Password = (string)userRow[2], UserLevel = (int)userRow[3], UserEmail = (string)userRow[4] }; userList.Add(user); } } catch (Exception e) { Console.WriteLine(e.Message); } return(userList); }
/// <summary> /// Get all data from TabUser /// </summary> /// <returns>Return the data to the dataset</returns> /// <exception cref="Exception"></exception> public DataSet1.TabUserDataTable GetUser() { try { _tableUserTableAdapter.Fill(_userDataSet.TabUser); return(_userDataSet.TabUser); } catch (Exception ex) { throw ex; } }