private void Search() { DataTable dtProducts = null; ProductParameters pmtProduct = new ProductParameters(); pmtProduct.Name = SQLUtil.CreateSearchQueryCondition( this.frmProduct.txtSchName.Text.Trim(), SQLUtil.SearchQueryConditionsEnum.AND); pmtProduct.ProductBrandId = this.frmProduct.pbcSchProductBrand.Value == null ? -1 : this.frmProduct.pbcSchProductBrand.Value.ProductBrandId; try { dtProducts = srvProduct.SearchByParameters("Product.Search100Products", pmtProduct, false); } catch { } this.frmProduct.grdSchSearch.DataSource = null; this.frmProduct.grdSchSearch.DataSource = dtProducts; }