ADO.Net equivlent of an Updatable ADO Recordset.

[Byron Hopp]

Is there a good example of creating an Ado.net object which can be updated
field by field and then update the sql server as the old ADO recordset?

Byron...

 

[Mark Rae]

Is there a good example of creating an Ado.net object which can be updated
field by field and then update the sql server as the old ADO recordset?

http://www.developerfusion.co.uk/forums/topic-23554

 

[Sahil Malik [MVP]]

That kind of ease is provided by CommandBuilder. It isn't exactly like
Recordset but it's close. But obviously the less effort you put in, the
crappier the query will be. Prefer to look at the underlying data structure
and specify your commands yourself.

 

[W.G. Ryan MVP]

A DataReader is the closest to a recordset but it isn't updateable. The
closest is using a DataSEt/DataTable and using a DataAdapter to update it.

 

[Cor Ligthert [MVP]]

Byron,

In my opinion is the datatable the closest to the recordset.

The main difference is that a datatable is disconnected while a recordset is
connected to the database.

I hope this helps,

Cor

 

[William \(Bill\) Vaughn]

Of course, disconnected client-side Recordsets are more equivalent to the
disconnected DataTable.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Chad Z. Hower aka Kudzu]

Is there a good example of creating an Ado.net object which can be
updated field by field and then update the sql server as the old ADO
recordset?

There really is no equivalent of the updatable recordset (formerly called a dynaset). You have
to issue separate update statements.