protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tblCategory = categoryAdpter.GetCategory();
ddl_Category.DataSource = tblCategory;
ddl_Category.DataTextField = "CategoryName";
ddl_Category.DataValueField = tblCategory.CategoryIdColumn.ToString();
ddl_Category.DataBind();
ddl_Category.Items.Insert(0, new ListItem("Select Category", "-1"));
tblProducts = productAdapter.GetProduct();
ddl_Product.DataSource = tblProducts;
ddl_Product.DataTextField = "ProductName";
ddl_Product.DataValueField = tblProducts.ProductIdColumn.ToString();
ddl_Product.DataBind();
ddl_Product.Items.Insert(0, new ListItem("Select Product", "-1"));
tblProductByCategory = adapter.GetProductsByCategory();
grdProducts.DataSource = tblProductByCategory;
grdProducts.DataBind();
}
}