ADO.Net equivlent of an Updatable ADO Recordset.

  • Thread starter Thread starter Byron Hopp
  • Start date Start date
B

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...
 
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.
 
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.
 
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
 
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.
__________________________________
 
Byron Hopp said:
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?
Click to expand...

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