public void ddlSubCategory_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                var pro = (from a in db.tbl_ProductListDtls
                           where a.IsDelete == false & a.SubCatId == int.Parse(ddlSubCategory.SelectedItem.Value)
                           select new
                {
                    a.ProductId,
                    a.ProductName
                }).ToList();

                ddlProduct.DataSource     = pro;
                ddlProduct.DataTextField  = "ProductName";
                ddlProduct.DataValueField = "ProductId";
                ddlProduct.DataBind();
                db.Dispose();
                ddlProduct.Items.Insert(0, new ListItem("--Select Product--", "0"));

                //var value = int.Parse(ddlProduct.SelectedItem.Value);
                //var value = int.Parse(ddlSubCategory.SelectedItem.Value);
                //var getData = (from s in db.stockItemList(value) select s).ToList();
                //gvItemList.DataSource = getData;
                //gvItemList.DataBind();
                //gvItemList.Visible = true;
            }
        }
        protected void ddlAddCategory_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                var Subcat = (from a in db.tbl_SubCategoryDtls
                              where a.IsDelete == false & a.CatId == int.Parse(ddlAddCategory.SelectedItem.Value)
                              select new { a.SubCatId, a.SubCatName, }).ToList();


                ddlSubCategoryPnlProd.DataSource     = Subcat;
                ddlSubCategoryPnlProd.DataTextField  = "SubCatName";
                ddlSubCategoryPnlProd.DataValueField = "SubCatId";
                ddlSubCategoryPnlProd.DataBind();
                db.Dispose();
                ddlSubCategoryPnlProd.Items.Insert(0, new ListItem("--Select Sub-Category--", "0"));
            }
        }
示例#3
0
 protected void ddlSubCat_SelectedIndexChanged(object sender, EventArgs e)
 {
     using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
     {
         var product = (from a in db.tbl_ProductListDtls
                        where a.IsDelete == false & a.SubCatId == int.Parse(ddlSubCat.SelectedItem.Value)
                        select new
         {
             a.ProductId,
             a.ProductName
         }).ToList();
         ddlProduct.DataSource     = product;
         ddlProduct.DataTextField  = "ProductName";
         ddlProduct.DataValueField = "ProductId";
         ddlProduct.DataBind();
         db.Dispose();
         ddlProduct.Items.Insert(0, new ListItem("--Select Sub-Product--", "0"));
     }
 }
        protected void BindCategory()
        {
            using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
            {
                var cat = (from a in db.mstCategories
                           where a.IsDelete == false
                           select new
                {
                    a.CatId,
                    a.CategoryName
                }).ToList();

                ddlCategory.DataSource     = cat;
                ddlCategory.DataTextField  = "CategoryName";
                ddlCategory.DataValueField = "CatId";
                ddlCategory.DataBind();
                db.Dispose();
                ddlCategory.Items.Insert(0, new ListItem("--Select Category--", "0"));
            }
        }