P
Peter Van Wilrijk
Hi,
In VB6 I used a method requery to repopulate a recordset. I don't find
an equivalent for the .NET dataset.
I don't update my datasets at all, but I use them to navigate through
subsets of my tables, saying my dataset contains primary keys, ordered
in a specific way. When I go the next, previous, first or last record
in the dataset I execute a select stored procedure. When I do an
insert, delete or update I call a stored procedure, implying I should do
a requery of the dataset (subset) because a row might be deleted or
inserted in the database, while it's not reflected in the disconnected
dataset.
Of course I can execute the query to create the dataset again, after
each insert/delete. I wondered there might be a method dataset.requery
or a workaround to achieve this easily??
Thanks a lot,
Kind regards,
Perre Van Wilrijk.
In VB6 I used a method requery to repopulate a recordset. I don't find
an equivalent for the .NET dataset.
I don't update my datasets at all, but I use them to navigate through
subsets of my tables, saying my dataset contains primary keys, ordered
in a specific way. When I go the next, previous, first or last record
in the dataset I execute a select stored procedure. When I do an
insert, delete or update I call a stored procedure, implying I should do
a requery of the dataset (subset) because a row might be deleted or
inserted in the database, while it's not reflected in the disconnected
dataset.
Of course I can execute the query to create the dataset again, after
each insert/delete. I wondered there might be a method dataset.requery
or a workaround to achieve this easily??
Thanks a lot,
Kind regards,
Perre Van Wilrijk.