public void LoadUserList() { DataTable dt = BusinessHelper.ListAllUsers(); foreach (DataRow dr in dt.Rows) { string userName = dr["username"].ToString(); string email = dr["email"].ToString(); string pw = dr["password"].ToString(); string nonce = Convert.ToDateTime(dr["nonce"]).ToString("yyyy-MM-dd HH:mm:ss"); //string.Format(@"yyyy-MM-dd HH:mm:ss", dr["nonce"].ToString()); DataTable dtRole = BusinessHelper.AssignedRoles(userName); string[] roles = dtRole.AsEnumerable().Select(r => r.Field <string>("Role")).ToArray(); _users.Add(new InternalUserData(userName, email, nonce, pw, roles)); } }