protected void dpBrand_SelectedIndexChanged(object sender, EventArgs e) { DS = BindCommanData.GetDispSalesman(Convert.ToDateTime(txtOrderDate.Text).ToString("dd-MM-yyyy"), Convert.ToInt32(dpRoute.SelectedItem.Value), Convert.ToInt32(dpBrand.SelectedItem.Value)); if (!Comman.Comman.IsDataSetEmpty(DS)) { dpSalesman.DataSource = DS; dpSalesman.DataBind(); dpSalesman.Items.Insert(0, new ListItem("Agent Sales Person", "0")); } }