Copying Rows from a DataSet

's Computer Specifications

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

Thanks

Brad

's Computer Specifications

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

"Brad" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there an easy way to copy rows from one data set to another other than
> field by field copy?
>
> Thanks
>
> Brad
>

's Computer Specifications

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" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Is there an easy way to copy rows from one data set to another other than
> field by field copy?
>
> Thanks
>
> Brad
>

's Computer Specifications

On Thu, 12 Jul 2007 17:29:55 -0400, "Brad" <(E-Mail Removed)>
wrote:

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

ImportRow?

--
Philip Daniels

's Computer Specifications

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

"William (Bill) Vaughn" <(E-Mail Removed)> wrote in message
news:55EBE1C9-E15E-4459-960B-(E-Mail Removed)...
> Did you try selecting rows with a DataView and then using the Clone or
> Copy methods?
>
>
> "Brad" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Is there an easy way to copy rows from one data set to another other than
>> field by field copy?
>>
>> Thanks
>>
>> Brad
>>
>

's Computer Specifications

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

"Cor Ligthert [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
>> Is there an easy way to copy rows from one data set to another other than
>> field by field copy?
>>
>> Thanks
>>
>> Brad
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying the filtered data to clipboard is copying non-visible rows	=?Utf-8?B?U2VldGhhUmFtYW4=?=	Microsoft Excel Crashes	10	12th Jul 2006 09:39 PM
copying a datatable content from an untyped dataset into a table which is inside a typed dataset	Nedu N	Microsoft Dot NET Framework	3	31st Oct 2003 01:05 PM
copying a datatable content from an untyped dataset into a table which is inside a typed dataset	Nedu N	Microsoft ADO .NET	2	31st Oct 2003 01:05 PM
copying a datatable content from an untyped dataset into a table which is inside a typed dataset	Nedu N	Microsoft ASP .NET	2	31st Oct 2003 01:05 PM
Re: copy/move rows from a dataset to another dataset?	Stephen Muecke	Microsoft ADO .NET	1	22nd Jul 2003 04:56 PM