private void BindDataGridView() { TimeScheduleController timeController = new TimeScheduleController(); TimeCollections timeCollections = timeController.SelectList(); this.dgvTimeSchedule.AutoGenerateColumns = false; this.dgvTimeSchedule.DataSource = timeCollections; }
private void BindTime() { TimeScheduleController timeController = new TimeScheduleController(); TimeCollections timeCollections = timeController.SelectList(); TimeScheduleInfo info = new TimeScheduleInfo(); info.Time = " - Select One - "; info.TimeID = null; timeCollections.Insert(0, info); this.cboTime.DisplayMember = "Time"; this.cboTime.ValueMember = "TimeID"; this.cboTime.DataSource = timeCollections; this.cboTime.SelectedIndex = 0; }
public TimeCollections SelectList() { TimeCollections collection = new TimeCollections(); IDataReader Reader = DataAccess.SelectList(); while (Reader.Read()) { TimeScheduleInfo timeinfo = new TimeScheduleInfo(); timeinfo.TimeID = Convert.ToString(Reader["TimeID"]); timeinfo.Time = Convert.ToString(Reader["Time"]); timeinfo.Description = Convert.ToString(Reader["Description"]); collection.Add(timeinfo); } Reader.Close(); return(collection); }