//This is the GridView of all the items in the Table
protected override void Fill()
{
try {
DataView dv = new DataView();
if (txtSearch.Text == string.Empty)
{
gvData.EmptyDataText = Message.EMPTY_LIST;
dv = new DataView(Redirect.Items().Tables[0]);
}
else
{
gvData.EmptyDataText = Message.EMPTY_LIST_SEARCHED;
dv = new DataView(Redirect.Items(txtSearch.Text.Trim()).Tables[0]);
}
dv.Sort = (GridSortDirection == SortDirection.Ascending) ? GridSortExpression + " ASC" : GridSortExpression + " DESC";
gvData.PageSize = GridViewPageSize;
gvData.PageIndex = PageIndex;
ItemCount = dv.Table.Rows.Count;
if (SetupPager())
{
tablePager.Visible = true;
string maxRecords = SPA.Configuration.AppSetting("MaxRecords");
if (ItemCount == int.Parse(maxRecords))
{
lblPagingItemsTotal.Text = string.Format("<font color=red>{0}</font>", lblPagingItemsTotal.Text);
lblPagingItemsTotal.ToolTip = string.Format("Maximum record threshold of {0} encounterd! The value can be adjusted by an application administrator.", maxRecords);
}
}
else
{
tablePager.Visible = false;
}
gvData.DataSource = dv;
gvData.DataBind();
} catch (Exception ex) {
SPA.Error.WriteError(ex);
if (ShowDebug)
{
lblErrorMessage.Text = ex.ToString();
}
}
}