Disconnected Recordset??

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi - I have a recordset generated from a search between two dates - if
the user wishes to 'update' some of the records to show their interest
in some of the dates, is there a way I can just update the recordset,
and write it back to the database (used to use rs.Edit, rs.Update etc in
old ASP) - or do I still need to run an update query for the records I
want to update?

Thanks for any pointers,
 
Mark:

Are you using an ADO recordset or are you using a DataSet? If a dataset,
the rowstate of any rows modified/inserted/deleted will be marked as such
and you can just pass an update with those rows.

However, if you call dataadapter.update on a dataset that doesn't have
changes !DataSet.HasChanges;
then it won't submit anything back tot he db
 
Back
Top