|
|
Archive of Entries
|
 |
|
|
|
 |
|
|
asp.net grid paging
|
|
|
Location: Blogs The Woolston Blog |
 |
| Posted by: daniel |
9/2/2004 4:00 PM |
worked on a project today setting up a grid thats datasourced to a query that could potentially bring back thousands of rows. so bringing back that much info is baad. so i limit the query to the top 10 rows of the query and depending on the paging direction, i'll limit the rows by the running ID and sort accordingly. With our db2 database, its company policy to avoid temp tables; which is understandable. dont want a hundred people creating a hundred tables just to page thru a grid. so using the typical page tracking method isnt gonna fly. so we'll do this my way.
built the procs, built the forms and blammo..done. works like a charm.
did i mention that I really am not a big fan of DB2. I miss the ability to create procs in SqlSrvr2k by just typing CREATE PROCEDURE. DB2 makes the simplest tasks just another degree more difficult. |
|
| Permalink |
Trackback |
|
|
|
|
Search_Blog
|
|
|
|
|
|