Displaying a datagrid X rows at a time

[quanga]

Hi-
I have a datagrid that in some cases can be several thousand rows in
length. What I'd like it to do is have the data pushed to the browser
after every, say, 100 rows or so. Kind of a "response.flush" effect--
at a certain recurring point in the process, take what we've got and
send it to the browser. Is this possible?

Thanks.

 

[Teemu Keiski]

Hi,

that is called paging.

here are a few resources for yiou:

 

[Teemu Keiski]

Sorry, typed too fast

Resources:

ASP.NET DataGrid Paging
http://www.dotnetjunkies.com/Tutorial/AAF84EAD-C412-4304-A88A-AF26F8C883E6.dcik

ASP.NET DataGrid Paging Part 2 - Custom Paging
http://www.dotnetjunkies.com/Tutorial/EA868776-D71E-448A-BC23-B64B871F967F.dcik

ASP.NET DataGrid Paging - Custom Paging w/ Caching & Numeric Links
http://www.dotnetjunkies.com/Tutorial/07FB766A-35F2-4691-923A-D5F1BA3A12DD.dcik

Easy DataGrid Paging with the DataGridPager
http://aspalliance.com/628

 

[William F. Robertson, Jr.]

Not without using paging as Teemu recommended. It seems as though you still
want to show the 1000+ rows at a time. The DataGrid is rendered as an html
table. Internet Explorer renders table in one pass. IOW, the table (grid)
will not be show to the user on their machine until the whole table has been
received and parsed by the browser.

bill

 

[quanga]

Yeah Bill, that's more of what I had in mind; we want to show the whole
list and avoid paging if we can. Sounds like we might have to split up
the data into separate datagrids somehow. Thanks to you and Teemu for
your help.

 

[jasonkester]

Yeah Bill, that's more of what I had in mind; we want to show the whole
list and avoid paging if we can. Sounds like we might have to split up
the data into separate datagrids somehow.

You could do Response.Flush() if you didn't use bound controls like the
DataGrid or Repeater. Render the page like it was classic ASP. Render
the tableHeader, flush, then do a foreach on your rows, rendering HTML
rows and flushing periodically.

It's easy enough to do. In fact, it's exactly how you did it 3 years
ago.


Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/