private void BindRoute()
{
RouteController routeController = new RouteController();
RouteCollections routeCollections = routeController.SelectList();
RouteInfo info = new RouteInfo();
info.RouteName = " - Select One - ";
info.RouteID = null;
routeCollections.Insert(0, info);
this.cboRoute.DisplayMember = "RouteName";
this.cboRoute.ValueMember = "RouteID";
this.cboRoute.DataSource = routeCollections;
this.cboRoute.SelectedIndex = 0;
}
public RouteCollections SelectList()
{
RouteCollections collection = new RouteCollections();
IDataReader Reader = DataAccess.SelectList();
while (Reader.Read())
{
RouteInfo routeinfo = new RouteInfo();
routeinfo.RouteID = Convert.ToString(Reader["RouteID"]);
routeinfo.RouteCode = Convert.ToString(Reader["RouteCode"]);
routeinfo.RouteName = Convert.ToString(Reader["RouteName"]);
routeinfo.FromLocationID = Convert.ToString(Reader["FromLocationID"]);
routeinfo.FromLocationName = Convert.ToString(Reader["LocationName"]);
routeinfo.ToLocationID = Convert.ToString(Reader["ToLocationID"]);
routeinfo.ToLocationName = Convert.ToString(Reader["LocationName"]);
collection.Add(routeinfo);
}
Reader.Close();
return(collection);
}
