Disconnected Recordset??

[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,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[William Ryan eMVP]

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
"Mark" <an*******@devdex.com> wrote in message
news:uo**************@TK2MSFTNGP10.phx.gbl...

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,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!