protected void FillDDL(DropDownList ddl, string sFilter)
{
ddl.AppendDataBoundItems = true;
ddl.DataSource = NorthwindAccess.GetSuppliersSDS(sFilter); // binds the SDS
ddl.DataTextField = "CompanyName";
ddl.DataValueField = "SupplierID";
ddl.Items.Clear(); // clear any existing items
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("Now Pick a Company form [" + ddl.Items.Count + "]", ""));
ddl.AutoPostBack = true;
}
/// <summary>
/// Fills the DDL on a filter input
/// </summary>
/// <param name="input"></param>
protected void FillDropList(string input)
{
SqlDataSource result = NorthwindAccess.GetSuppliersSDS(input);
SupplierDDL.AppendDataBoundItems = true;
SupplierDDL.DataSource = result;
SupplierDDL.DataTextField = "CompanyName";
SupplierDDL.DataValueField = "SupplierID";
SupplierDDL.Items.Clear();
SupplierDDL.DataBind();
SupplierDDL.Items.Insert(0, new ListItem("Now pick a company from[" + SupplierDDL.Items.Count + "]"));
SupplierDDL.AutoPostBack = true;
}