Copying Rows from a DataSet -- dotnet ado.net

William (Bill) Vaughn
7/12/2007 4:19:02 PM

Did you try selecting rows with a DataView and then using the Clone or Copy
methods?

[quoted text, click to view]

Brad
7/12/2007 5:29:55 PM

Is there an easy way to copy rows from one data set to another other than
field by field copy?

Thanks

Brad

Cor Ligthert [MVP]
7/14/2007 12:00:00 AM

Brad,

I think that this needs a short explanation.

A datarow is an object from the datatable, that uses one other object (the
Columns) from its table to describe what is in it. Therefore as you don't
have the table, you have in fact nothing. The reference to that table is in
the datarow and you cannot reference one row to more tables.

I think therefore that mostly an easier way is to copy the table and than to
remove the rows you don't need.

Cor

"Brad" <brad.markisohn@roche.com> schreef in bericht
news:eZUFNvMxHHA.4384@TK2MSFTNGP02.phx.gbl...
[quoted text, click to view]

PhilipDaniels NO[at]SPAM foo.com
7/15/2007 7:20:52 PM

On Thu, 12 Jul 2007 17:29:55 -0400, "Brad" <brad.markisohn@roche.com>
[quoted text, click to view]

ImportRow?

--

Brad
7/17/2007 1:00:26 PM

Bill,

Thanks for your suggestion. The DataView was a good solution to my problem.
What I really needed was a way to filter on a table for reporting purposes.

Brad

[quoted text, click to view]

Brad
7/17/2007 1:01:26 PM

Cor,

Thanks for the explanation. It helped highlight my problem. I used Bill's
suggestion to create a filtered data view to get the data from my DataSet.

Brad

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet ado.net

dotnet ado.net : Copying Rows from a DataSet