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