retrieve PageCount of DataGrid

[David Potahisnsky]

I have ASPX page with DataGrid object. To fill this object I use DataTable

that contain result of stored procedure. In my case it's about 300 rows.



I would like to display this table with paging.



This is code to retrieve table:



DataTable dtMainTable = null;

DataSet Ds = SqlHelper.ExecuteDataset(strConnectionString,

CommandType.StoredProcedure, "a_test_procedure", null);

Ds.Tables[0].TableName = "PermissonFunctions";

dtMainTable = Ds.Tables[0];





this is code for data bind of datagid:



ReportGrid.DataSource = dtMainTable;

ReportGrid.AllowPaging = true;

ReportGrid.CurrentPageIndex = 0;

ReportGrid.DataBind();







This code displays cool table on ASPX page.



My problem is that I need to display the total number of pages that could be
displayed.



I'm trying to use:



ReportGrid.PageCount, but any time returns me zero (0). Please help me to

retrieve PageCount.







Thank you, David Potahinsky