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);
}
