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