private void BindProduct(int brand_id)
{
ddlProduct.Text = string.Empty;
ProductController controller = new ProductController();
ProductCollections collection = controller.GetProductList(brand_id);
ddlProduct.DisplayMember = "ProductName";
ddlProduct.ValueMember = "ProductID";
ddlProduct.DataSource = collection;
ddlProduct.Enabled = true;
}
public ProductCollections GetProductList(int brand_id)
{
ProductCollections collection = new ProductCollections();
IDataReader reader = DataAccess.SelectList(brand_id);
Product prod = new Product();
prod.ProductID = 0;
prod.ProductName = "Select Product";
collection.Add(prod);
while (reader.Read())
{
Product product = new Product();
product.ProductName = Convert.ToString(reader["product_name"]);
product.Price = Convert.ToDecimal(reader["price"]);
product.ProductID = Convert.ToInt32(reader["product_id"]);
collection.Add(product);
}
return(collection);
}
