U
UJ
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.
TIA.
Jeffrey.
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.
TIA.
Jeffrey.