protected void Schedule_Source_SelectedIndexChanged(object sender, EventArgs e) { bus_dbEntities db = new bus_dbEntities(); int source = int.Parse(Schedule_Source.SelectedValue.ToString()); var dest = (from x in db.tbl_route join y in db.tbl_station on x.route_destination equals y.station_id where x.route_source == source select y).ToList(); Schedule_Destination.DataSource = dest; Schedule_Destination.DataTextField = "station_name"; Schedule_Destination.DataValueField = "station_id"; Schedule_Destination.DataBind(); int destination = int.Parse(Schedule_Destination.SelectedValue.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bus_dbEntities db = new bus_dbEntities(); var lgs = (from x in db.tbl_schedule join y in db.tbl_route on x.fk_route equals y.route_id join a in db.tbl_station on y.route_source equals a.station_id join b in db.tbl_station on y.route_destination equals b.station_id select new { ID = x.schedule_id, Source = a.station_name, Destination = b.station_name, Timning = x.schedule_time }).ToList(); var stations = (from x in db.tbl_station select x).ToList(); var bus = (from x in db.tbl_bus select x).ToList(); grid1.DataSource = lgs; grid1.DataBind(); Schedule_bus.DataSource = bus; Schedule_bus.DataTextField = "bus_name"; Schedule_bus.DataValueField = "bus_id"; Schedule_bus.DataBind(); Schedule_Source.DataSource = stations; Schedule_Source.DataTextField = "station_name"; Schedule_Source.DataValueField = "station_id"; Schedule_Source.DataBind(); Schedule_Source.SelectedIndex = 0; int source = int.Parse(Schedule_Source.SelectedValue.ToString()); var dest = (from x in db.tbl_route join y in db.tbl_station on x.route_destination equals y.station_id where x.route_source == source select y).ToList(); Schedule_Destination.DataSource = dest; Schedule_Destination.DataTextField = "station_name"; Schedule_Destination.DataValueField = "station_id"; Schedule_Destination.DataBind(); int destination = int.Parse(Schedule_Destination.SelectedValue.ToString()); var timming = (from x in db.tbl_time select x).ToList(); Schedule_timming.DataSource = timming; Schedule_timming.DataTextField = "time_value"; Schedule_timming.DataValueField = "time_id"; Schedule_timming.DataBind(); } }