//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
{ }
}
