private void BinddtgData(string TableType) { DB = CreateDataBase(this.DropDownList1.SelectedValue.Trim()); if (_PageIndex < 1) _PageIndex = 1; _RecordCount = DB.getCount(qrytypelist.SelectedItem.Value, Condition); if (_RecordCount > 0) { _PageCount = _RecordCount / _PageSize; if (_RecordCount % _PageSize > 0) _PageCount++; } DataSet ds = DB.RunProcedure(TableType, _PageSize, _PageIndex, "Asc", Condition); dtgData.DataSource = ds.Tables[0].DefaultView; dtgData.DataBind(); ViewState["ds"] = ds; lblRecordCount.Text = _RecordCount.ToString(); lblPageCount.Text = _PageCount.ToString(); lblPageIndex.Text = _PageIndex.ToString(); if (_PageIndex > 1) lnkPrev.Visible = true; else lnkPrev.Visible = false; if (_PageIndex < _PageCount) lnkNext.Visible = true; else lnkNext.Visible = false; BindlsbPage(_PageCount, _PageIndex); }