public void loadMansx()
{
ddrMansx.DataSource = bus.ShowVendor();
ddrMansx.DataTextField = "VendorName";
ddrMansx.DataValueField = "VendorID";
ddrMansx.DataBind();
}
public void LoadDrop()
{
DropDownList1.DataSource = bus.ShowVendor();
DropDownList1.DataTextField = "VendorName";
DropDownList1.DataValueField = "VendorID";
DropDownList1.DataBind();
DropDownList2.DataSource = bus.ShowCategory();
DropDownList2.DataTextField = "CategoryName";
DropDownList2.DataValueField = "CategoryID";
DropDownList2.DataBind();
}