my ist dropdown code
DataSet dd = new DataSet();
var sel = DropDownList2.SelectedValue.ToString();
string anad = "select suppliername from suplier order by suppliername";
dd = gdv.GETDS(anad);
foreach (DataRow dr in dd.Tables[0].Rows)
{
int a = 0;
ListItem li1 = new ListItem();
li1.Text = dr["suppliername"].ToString();
li1.Value = Convert.ToString(a + 1);
DropDownList2.Items.Add(li1.ToString());
}
my second dropdown code
DataSet ddse = new DataSet();
var sel = DropDownList2.SelectedValue.ToString();
string and = "select sectionname from suplier where suppliername='" + DropDownList2.SelectedItem.ToString() + "'";
ddse = gdv.GETDS(and);
foreach (DataRow dr in ddse.Tables[0].Rows)
{
int a = 0;
ListItem li1 = new ListItem();
li1.Text = dr["sectionname"].ToString();
li1.Value = Convert.ToString(a + 1);
DropDownList3.Items.Add(li1.ToString());
}
i use where condition in dropdown 2. but again i choose the dropdown2 it shows the previous data also. but i use where condition in dropdown2.