protected void WarehouseDropDownList_SelectedIndexChanged(object sender, EventArgs e) { BatchDropDownList.SelectedIndex = -1; LocationDropDownList.SelectedIndex = -1; InventoryQuantityTextBox.Text = String.Empty; PhysicalQuantityTextBox.Text = String.Empty; ReconciledDateTextBox.Text = String.Empty; InventoryQuantityTextBox.Text = string.Empty; ListItem first = BatchDropDownList.Items[0]; LocationDropDownList.Items.Clear(); LocationDropDownList.Items.Add(first); LocationDropDownList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Panel3.Visible = false; Panel2.Visible = false; Panel1.Visible = true; string CS = ConfigurationManager.ConnectionStrings["EnrollInJob"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { /**creating SqlCommand for Category DropDown list to sotre category name from database */ SqlCommand cmd1 = new SqlCommand(); cmd1.CommandText = "Select CategoryId, CategoryName from JobCategory"; cmd1.Connection = con; con.Open();//open connection for all SqlDataReader rdr1 = cmd1.ExecuteReader(); CategoryDropDown.DataTextField = "CategoryName"; CategoryDropDown.DataValueField = "CategoryId"; CategoryDropDown.DataSource = rdr1; CategoryDropDown.DataBind(); ListItem l1 = new ListItem("Select Category", "-1"); CategoryDropDown.Items.Insert(0, l1); rdr1.Close();//close rdr1 SqlDataReader to write another new Query /*******************************************************/ /** creating SqlCommand for Location dropdown to store city name from database */ SqlCommand cmd2 = new SqlCommand(); cmd2.CommandText = "Select PinCode,CityName from cities"; cmd2.Connection = con; SqlDataReader rdr2 = cmd2.ExecuteReader(); LocationDropDownList.DataTextField = "CityName"; LocationDropDownList.DataValueField = "PinCode"; LocationDropDownList.DataSource = rdr2; LocationDropDownList.DataBind(); ListItem selectLocation = new ListItem("Select Location", "-1"); LocationDropDownList.Items.Insert(0, selectLocation); rdr2.Close(); /***************************************************************/ } } }