protected void BindData()
{
string where = "1=1";
if (!String.IsNullOrEmpty(txtTenNhom.Text.Trim()))
{
where += "AND " + string.Format(" Ten_Nhom like N'%{0}%'", UltilFunc.SqlFormatText(this.txtTenNhom.Text.Trim()));
}
pages.PageSize = Global.MembersPerPage;
DataSet _ds;
_ds = _nhomnguoidungDAL.BindGridT_Nhom(pages.PageIndex, pages.PageSize, where);
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
_ds = _nhomnguoidungDAL.BindGridT_Nhom(pages.PageIndex - 1, pages.PageSize, where);
}
DataTable _dtgroup = _ds.Tables[0];
_dtgroup = LoadDataUserWithGroup(_dtgroup);
grdListNhom.DataSource = _dtgroup;// _ds.Tables[0].DefaultView;
grdListNhom.DataBind();
pages.TotalRecords = currentPage.TotalRecords = TotalRecords;
currentPage.TotalPages = pages.CalculateTotalPages();
currentPage.PageIndex = pages.PageIndex;
}
