Getting Total Item Count in Paging Datagrid

[jason smith]

I'm not sure if I am just missing some obvious function call or what.

I want to be able to get the overall count of the records returned from
my database query. When I use datagrid.Item.Count, it only returns the
count for the current page. I see a property that lists pagecount, but
nothing for totalcount. I want to have a label above my datagrid that
says "n results returned".

Can anyone help, thanks.

 

[Prasad]

Hi

Use dataGrid.PageCount * dataGrid.PageSize

HTH
Prasad

 

[jason smith]

That solution will not give me the exact number. For example if the user
has paging set to 100 items per page and there are 577 items returned,
your solution will display 600 items found.

Is there a way to do (pagecount-1 * numberofpages) + (lastpagecount).


Thanks,

 

[Alvin Bruney]

get it from the underlying datagrid
datagrid.table[0].rows.count will always be accurate.

 

[Alvin Bruney]

sorry i meant dataset. duh...brain fart.

get it from the underlying datagrid
datagrid.table[0].rows.count will always be accurate.

That solution will not give me the exact number. For example if the user
has paging set to 100 items per page and there are 577 items returned,
your solution will display 600 items found.

Is there a way to do (pagecount-1 * numberofpages) + (lastpagecount).


Thanks,