// get user ID based on user name public int GetUID(string userName) { int uID = -1; try { // get UID using query tabUserAdapter.SelectUserByUserName(tabUserDataTable, userName); foreach (DataRow Row in tabUserDataTable.Rows) { uID = (int)Row["UID"]; } } catch (Exception e) { Console.WriteLine(e.Message); } return(uID); }