protected void ddlRoute_SelectedIndexChanged(object sender, EventArgs e) { ListBoxAllotment.Items.Clear(); if (ddlRoute.SelectedValue != "0") { ds = con.FN_ExecuteQuerySingle("select * from Mst_Drivers"); ListLeft.DataSource = ds; ListLeft.DataValueField = "DriverID"; ListLeft.DataTextField = "DriverName"; ListLeft.DataBind(); ListLeft.Items.Add(new ListItem("", "")); DataSet ds1 = new DataSet(); ds1 = con.FN_ExecuteQuerySingle("select * from Mst_Vehicles"); ListRight.DataSource = ds1; ListRight.DataValueField = "vehicle_num"; ListRight.DataTextField = "vehicle_type"; ListRight.DataBind(); ListRight.Items.Add(new ListItem("", "")); divlistbox.Visible = true; dvgrvDetails.Visible = true; } else { dvgrvDetails.Visible = false; } }
public void edit_schedule() { DateTime today = DateTime.Today; DataSet edit_s = new DataSet(); edit_s = con.FN_ExecuteQuerySingle("select BinId , BinName,Sequence from Mst_schedule_collecttion where Date='" + today + "'"); ListRight.DataSource = edit_s; ListRight.DataTextField = "BinName"; ListRight.DataValueField = "BinId"; ListRight.DataBind(); ListLeft.Items.Clear(); btn_update.Visible = true; sbt_plan.Visible = false; btn_edit_schedule.Visible = false; btnRight.Visible = false; Remove.Visible = true; }