Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Specifying a filter based on rowid

Thread Tools

Specifying a filter based on rowid

Posts: n/a
I have a datatable that I want to display the first 10 records, then display
the next 10 records, and so forth. I'm storing the dataset in a session
variable because as the user makes changes, they don't want them saved until
they press the save button.

Which means I need to initially load the datatable getting rows 1-10 from
the db and display those. Works fine. When the user goes to the next set, I
need to have the first set somewhere in case they have changed them. Well if
I saved the values back in to the datatable and have pulled all of the
records initially (so I don't go back to the db every page reload) I could
modify them to my hearts content until they press save. But how can I have a
datalist limit the number of rows to display. The way I did it before was to
only load the number of rows I needed into the datatable. But now if I have
everything it will display them all.

I suppose if I had to I could copy the 10 records I need for this page into
a new datatable and then bind that.

Ideally I'd like to be able to do some kind of dataview with a .select that
said something like ('RowID >= 0 and RowID <=9') where RowID is the internal
ID of the row. If I have to, I will add it to the stored proc that is
getting me the data but I'd rather not.



Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ruby-oci8-1.0.0 rowid Amos Ruby 1 01-17-2008 03:20 PM
oci8 oracle rowid Mark Pelletier Ruby 1 09-24-2007 01:48 PM
UV Protector filter vs. Skylight filter? john Digital Photography 8 06-26-2004 03:44 PM
Access (ROWID) Unique ID from Datagrid Column Mona Syed ASP .Net Datagrid Control 0 06-01-2004 02:52 PM
how to get current rowid in datagrid Lerp ASP .Net 2 05-21-2004 11:05 PM