protected void ddlDivision_SelectedIndexChanged(object sender, EventArgs e)
{
ProductProvider productProvider = new ProductProvider();
DataSet ds = productProvider.GetDivisionwiseFinishedProduct(ddlDivision.SelectedItem.Value.Toint());
ddlFinishedProduct.DataSource = null;
ddlFinishedProduct.DataBind();
ddlFinishedProduct.DataSource = ds;
ddlFinishedProduct.DataBind();
ddlFinishedProduct.Items.Insert(0, new ListItem("----------Select Product----------", "0"));
ddlFinishedProduct.SelectedIndex = 0;
}