private void BindDataGridView() { DriverController driverController = new DriverController(); DriverCollections driverCollections = driverController.SelectList(); dgvDriver.AutoGenerateColumns = false; dgvDriver.DataSource = driverCollections; }
private void BindDriver2ID() { DriverController driverController = new DriverController(); DriverCollections driverCollections = driverController.SelectList(); DriverInfo info = new DriverInfo(); info.DriverName = " - Select One - "; info.DriverID = null; driverCollections.Insert(0, info); this.cboDriver2.DisplayMember = "DriverName"; this.cboDriver2.ValueMember = "DriverID"; this.cboDriver2.DataSource = driverCollections; this.cboDriver2.SelectedIndex = 0; }
public DriverCollections SelectList() { DriverCollections collection = new DriverCollections(); IDataReader Reader = DataAccess.SelectList(); while (Reader.Read()) { DriverInfo driverinfo = new DriverInfo(); driverinfo.DriverID = Convert.ToString(Reader["DriverID"]); driverinfo.DriverCode = Convert.ToString(Reader["DriverCode"]); driverinfo.DriverName = Convert.ToString(Reader["DriverName"]); driverinfo.DriverLicence = Convert.ToString(Reader["DriverLicence"]); driverinfo.NRCNo = Convert.ToString(Reader["NRCNo"]); driverinfo.PhoneNo = Convert.ToString(Reader["PhoneNo"]); driverinfo.Address = Convert.ToString(Reader["Address"]); collection.Add(driverinfo); } Reader.Close(); return(collection); }