C# GridView iterate over non displayed rows 1

[Qik3Coder]

I have a standard grid view with 100 items in it.
I have the page size set to 25.

I need to inspect all items to get a full total of all items in the grid, not just the items on page 1.

I already have a foreach that iterates over the row collection, but this only iterates over the first 25.

TIA,
Lodlaiden



I haz all the letters: SME, BA, QA, PM, DEV, DBA, UAT, SE, HD

 

[jbenson001]

You should be iterating over the datasource of the grid, not the grid itself.

 

[jmeckley]

it would be more efficient, and scalable to
1. query a page of 25 records
2. query for the total number of records (to render paging links)
3. query for the calculated value

Jason Meckley
Programmer

faq855-7190
faq732-7259

 

[Qik3Coder]

That was a contrived example.

I'm dynamically generating filter dropdowns based on the current data set.

I thought about creating queries for each of these, but didn't want to dupe the logic that gets the base data set.

Thanks,
Lodlaiden

I haz all the letters: SME, BA, QA, PM, DEV, DBA, UAT, SE, HD

 

[jmeckley]

if the results are small then you won't have a problem, but if you get into hundreds of records you will start to see performance degrade, at which point you will need to reduce the amount of data retrieved from the database

Jason Meckley
Programmer

faq855-7190
faq732-7259