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