private void Search() { SqlString ProductName = SqlString.Null; if (txtSearchProductName.Text.Trim() != "") ProductName = Convert.ToString(txtSearchProductName.Text.Trim()); ProductBAL balProduct = new ProductBAL (); DataTable dtProduct = balProduct.Search(ProductName); if (dtProduct != null && dtProduct.Rows.Count > 0) { gvProduct.DataSource = dtProduct; gvProduct.DataBind(); } else { gvProduct.DataSource = null; gvProduct.DataBind(); } }