Cloning Row in Typed Dataset Table

I am having touble figuring out a good way to clone a record ( row ) in a
typed dataset table without copying each field one by one. Is there a
'clone' function that I have missed that would allow me to make a deep copy
of a record?

uhmm ?



YourTypeDataSetClass.tablenameRow yourNewRecorsRow;



mow you can use it



yourNewRecorsRow =
(YourTypeDataSetClass.tablenameRow)YourTypedDataset.table[pos];



the are many ways to do this, the better approach depend on you particular
code.



I hope I understand you question



MajorTom



"wacampbell" <wacampbell@discussions.microsoft.com> wrote in message
news:180D0B8C-A2A5-47D8-86DE-67C495EF2807@microsoft.com...
>I am having touble figuring out a good way to clone a record ( row ) in a
> typed dataset table without copying each field one by one. Is there a
> 'clone' function that I have missed that would allow me to make a deep
> copy
> of a record?

Thanks for the reply MajorTom,

I may not have explained it well, and BTW I should have meantioned I am
using C#.

> YourTypeDataSetClass.tablenameRow yourNewRecorsRow;
> yourNewRecorsRow =
> (YourTypeDataSetClass.tablenameRow)YourTypedDataset.table[pos];

I think this just gives me a reference pointer to the record in the dataset.
It doesn't actually copy the record. IE, if I make changes to
'yourNewRecorsRow', it will change the record in the dataset also.

I need to make what I think is called a 'deep copy' so I can change
'yourNewRecorsRow' without affecting the original data in the dataset.

For now, I have been doing this:

YourTypeDataSetClass.tablenameRow yourNewRecorsRow =
(YourTypeDataSetClass.tablenameRow) YourTypeDataSet.tablename.NewRow();

yourNewRecorsRow.Field1 = YourTypeDataSet.tablename[pos].Field1
yourNewRecorsRow.Field2 = YourTypeDataSet.tablename[pos].Field2
..... etc

With the problem being that if I add a field to the dataset, I have to keep
these 'cloning' routines in sync. There has to be some kind of 'deep' record
copy ability somewhere.

Thanks for answering.

Wayne

if you create a new instance of your dataset and merge to this one your
record is going to be 'disconnected' from the original table.



but you have to use the merge method instead of the copy to avoid the
exception that this record belong to another table.



I going to find an example for you is that approach you think will work, the
big difference is you have a second dataset only for one record.


MajorTom

"wacampbell" <wacampbell@discussions.microsoft.com> wrote in message
news:80C37172-DEE0-4AFB-98AB-7A116CE0D4ED@microsoft.com...
> Thanks for the reply MajorTom,
>
> I may not have explained it well, and BTW I should have meantioned I am
> using C#.
>
>> YourTypeDataSetClass.tablenameRow yourNewRecorsRow;
>> yourNewRecorsRow =
>> (YourTypeDataSetClass.tablenameRow)YourTypedDataset.table[pos];
>
> I think this just gives me a reference pointer to the record in the
> dataset.
> It doesn't actually copy the record. IE, if I make changes to
> 'yourNewRecorsRow', it will change the record in the dataset also.
>
> I need to make what I think is called a 'deep copy' so I can change
> 'yourNewRecorsRow' without affecting the original data in the dataset.
>
> For now, I have been doing this:
>
> YourTypeDataSetClass.tablenameRow yourNewRecorsRow =
> (YourTypeDataSetClass.tablenameRow) YourTypeDataSet.tablename.NewRow();
>
> yourNewRecorsRow.Field1 = YourTypeDataSet.tablename[pos].Field1
> yourNewRecorsRow.Field2 = YourTypeDataSet.tablename[pos].Field2
> .... etc
>
> With the problem being that if I add a field to the dataset, I have to
> keep
> these 'cloning' routines in sync. There has to be some kind of 'deep'
> record
> copy ability somewhere.
>
> Thanks for answering.
>
> Wayne

wacampbell wrote:
[...]
> yourNewRecorsRow.Field1 = YourTypeDataSet.tablename[pos].Field1
> yourNewRecorsRow.Field2 = YourTypeDataSet.tablename[pos].Field2
> .... etc
>
I think, this solves your problem:

TypedDataSet.Table1Row row = typedDataSet1.Table1.NewTable1Row();
row.ItemArray = typedDataSet1.Table1.Rows[0].ItemArray;
typedDataSet1.Table1.AddTable1Row(row);

--
darek