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 = ""; } }