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...

"Byron Hopp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> 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

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.


--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------
---------------


"Byron Hopp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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...
>
>

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 Hopp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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...
>

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.
__________________________________

"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

"Byron Hopp" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):
> 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.


--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Blogs: http://www.hower.org/kudzu/blogs