//Function to fill dropdownlist protected void fillCategory() { try { string query = "SELECT distinct productCategoryName, productCategoryID from productcategory"; cf.FillDropDownList(ddlCategory, query, "productCategoryID", "productCategoryName"); ddlCategory.Items.Insert(0, "Select Category"); } catch { } }
protected void btnSearch_Click(object sender, EventArgs e) { try { cf.setQuery("select * from product WHERE productName='" + txtProduct.Text.Trim() + "'"); dt = cf.QueryEx(); if (dt.Rows.Count > 0) { cf.setQuery("select productID, productName, productDescription, price, productCategoryName from product inner join productcategory on product.productCategoryID = productcategory.productCategoryID where productName = '" + txtProduct.Text.Trim() + "'"); dt = cf.QueryEx(); if (dt.Rows.Count > 0) { grd_Product.Visible = true; grd_Product.DataSource = dt; grd_Product.DataBind(); empty.Visible = false; } else { grd_Product.Visible = false; } divDropdown.Attributes.CssStyle.Add("display", "none"); } else { string queryddl = "select productID,productName FROM product WHERE productCategoryID = (select productCategoryID from productcategory where productCategoryName = '" + txtProduct.Text.Trim() + "')"; cf.setQuery(queryddl); dt = cf.QueryEx(); if (dt.Rows.Count > 0) { cf.FillDropDownList(ddlProducts, queryddl, "productID", "productName"); ddlProducts.Items.Insert(0, new ListItem("Select Product", "0")); divDropdown.Attributes.CssStyle.Add("display", "block"); empty.Visible = false; grd_Product.Visible = false; } else { grd_Product.Visible = false; empty.Visible = true; } } } catch { } }