private void BindDataGridView() { UserLevelController userLevelController = new UserLevelController(); UserLevelCollections userLevelCollections = userLevelController.SelectList(); this.dgvUserLevel.AutoGenerateColumns = false; this.dgvUserLevel.DataSource = userLevelCollections; }
private void BindUserLevel() { UserLevelController userLevelController = new UserLevelController(); UserLevelCollections userLevelCollections = userLevelController.SelectList(); UserLevelInfo info = new UserLevelInfo(); info.UserLevel = " - Select One - "; info.UserLevelID = null; userLevelCollections.Insert(0, info); this.cboUserLevel.DisplayMember = "UserLevel"; this.cboUserLevel.ValueMember = "UserLevelID"; this.cboUserLevel.DataSource = userLevelCollections; this.cboUserLevel.SelectedIndex = 0; }
public UserLevelCollections SelectList() { UserLevelCollections collection = new UserLevelCollections(); IDataReader Reader = DataAccess.SelectList(); while (Reader.Read()) { UserLevelInfo userlevelinfo = new UserLevelInfo(); userlevelinfo.UserLevelID = Convert.ToString(Reader["UserLevelID"]); userlevelinfo.UserLevelCode = Convert.ToString(Reader["UserLevelCode"]); userlevelinfo.UserLevel = Convert.ToString(Reader["UserLevel"]); collection.Add(userlevelinfo); } Reader.Close(); return(collection); }