private void BindDSProducts()
{
// ------------------------------------------------------------------------
// Implement paging based upon the lettering filter specified
BPProducts bp = new BPProducts();
if (ddlProductCategories.SelectedValue == "-1")
{
DSProducts = bp.SelectAllWithProductCategories();
}
else
{
DSProducts = bp.SelectByProductCategoryID(Convert.ToInt32(ddlProductCategories.SelectedValue));
}
DSProducts.tbl_Products.DefaultView.RowFilter = RowFilter("ProductName", "ProductActive");
DSProducts.tbl_Products.DefaultView.Sort = "ProductName";
letters_Bind();
dgProduct.DataBind();
SetPagerButtons();
if (DSProducts.tbl_Products.DefaultView.Count == 0)
{
lblError.Visible = true;
lblError.Text = "0 Records found.";
}
else
{
lblError.Visible = false;
lblError.Text = "";
}
}
