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); }