How do i get the Total Grid Item Count when Paging is enabled?

[Ullas]

Hi,
I am trying to get the total items count on my grid (total count of all the items in all the pages of the grid) in my code behind when Paging is enabled.
 
My data source for the grid returns 17 rows and the data is displayed in 2 pages. 
When i do an Items count it only returns me 10 (since my page size is 10)
i tried this code which was suggested in this forum -

 

<telerik:RadGrid ID="GridInvoiceDetailsPO" runat="server" AllowPaging="True"
AutoGenerateColumns="False" PageSize="10" Visible="True" Skin="Outlook"
PagerStyle-Mode="NextPrevAndNumeric" PagerStyle-AlwaysVisible="true"

.... />

int i = GridInvoiceDetailsPO.Items.Count;

GridInvoiceDetailsPO.AllowPaging = false;

GridInvoiceDetailsPO.Rebind();

int j = GridInvoiceDetailsPO.Items.Count;

GridInvoiceDetailsPO.AllowPaging = true;

GridInvoiceDetailsPO.Rebind();

int k = GridInvoiceDetailsPO.Items.Count;

 

 

 

But i, j and k all return 10. is there something i am doing wrong?
Also i dont just want to get the total count, i want to iterate through the collection and get/set some data.

Ullas

 

 

[Shinu]

Hello Ullas,

Try the following code snippet.
C#:

protected void rad_ItemEvent(object sender, GridItemEventArgs e)
{
 if (e.EventInfo is GridInitializePagerItem)
        {
            int i=(e.EventInfo as GridInitializePagerItem).PagingManager.DataSourceCount;
        }
}

Thanks,
Shinu.

[Ullas]

Thanks Shinu.
I can get the count that way. But i want to loop through the collection and access each and every item. how can i do that?

Ullas

[Pavlina]

Hello Ullas,

When the grid is in paging mode only the items for the current page are retrieved - there are no items in memory. However, if you want to operate with all records from the source when the grid paging is enabled, reference directly the data from the underlying data source to process further operations over it.

All the best,
Pavlina
the Telerik team

[Ullas]

OK.
is there any way we can do this in JavaScript as well?

Ullas

[Pavlina]

Hi Ullas,

You can refer to the forum thread below for more information about how to achieve your goal:
http://www.telerik.com/community/forums/aspnet/grid/retrieving-all-grid-values-client-side.aspx

Regards,
Pavlina
the Telerik team