Updating from ADO recordSet - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Updating from ADO recordSet

Author

Topic

Billpl
Yak Posting Veteran

71 Posts

Posted - 2005-02-13 : 14:39:27

Ok, I going to expose my ignorance of handling remote recordSets and/or Views in ADO. I'm in the planning stage of a project using Flash Remoting and ADO .Net. The Flash client has no problem consuming an ADO recordSet then after updating, passing it back to the object and reconstructing the recordSet with the changes. Question being, what do I have to do to get the new recordSet to Update (as is) SQL without having to parse through the recordSet?

Example

1. Flash - Request Specific Query
2. Object -Create ADO.recordSet from SQL
3. Flash - pickup RecordSet and disconnect
4. Flash - Update Data
5. Flash - reconnect to Object and reconstruct recordSet
6. Object - Update SQL (as is) from recordSet
7. Done

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-13 : 15:06:04

call the SqlDataAdapter.Update method:
ds = your dataset
SqlDataAdapter da = new SqlDataAdapter()
da.Update(ds);

of course the dataadapter needs to have the correct commands for update, insert, delete, and select specified.

Go with the flow & have fun! Else fight the flow

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources