public void BindCustomer() { try { int strCnt = 0; DataTable dtCustomer = new DataTable(); DataSet dsCustomer = customerMaintenance.GetCustomerSelect(customer.Replace("'", "''")); dtCustomer = dsCustomer.Tables[0]; // Filter DataTable dtCustomer.DefaultView.RowFilter = BindWhereClause(); strCnt = dtCustomer.DefaultView.ToTable().Rows.Count; dtCustomer = dtCustomer.DefaultView.ToTable(); int maxRowCount = customerMaintenance.GetSQLWarningRowCount(); if (strCnt < maxRowCount) { if (dtCustomer.Rows.Count > 0) { if (hidSort.Value.Trim() != "") { dtCustomer.DefaultView.Sort = hidSort.Value; } else { dtCustomer.DefaultView.Sort = "CustName ASC"; } dtCustomer = dtCustomer.DefaultView.ToTable(); dgCustomerList.DataSource = dtCustomer; gridPager.InitPager(dgCustomerList, 100); //dgCustomerList.DataBind(); lblMessage.Visible = false; dgCustomerList.Visible = true;; } else { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } } else { lblMessage.Text = "Maximum rows exceeded. Please refine your filter with using the parameters above and then click Search."; lblMessage.Visible = true; dgCustomerList.Visible = false; } } catch (Exception ex) { lblMessage.Text = "No record found"; lblMessage.Visible = true; dgCustomerList.Visible = false; } pnlCustomerSearch.Update(); }