copy row from one datatable to another

[Guest]

I have read posts and tried many things and I am not getting how to do this.

I have a datagrid bound to a dataset (the source). When a row is selected
on the datagrid, I need to duplicate that row into another dataset (the
destination). The destination dataset will be bound to a a repeater that is
located below the datagrid.

I cloned the source dataset to the destination and have datatables
referenced for both datasets. I have primary keys defined for each datatable
and the schemas are identical.

The datagriditem only contains a portion of the columns from the source
dataset. The repeater will display more of the columns from the destination
dataset.

I can get the primary key for the selected datagriditem, but that is as far
as I can get.

How do I do copy a selected row to the destination dataset? I am using
asp.net 1.1 with code-behind of vb.net. If needed, I can post the code that
I have so far.

Thanks, Alex

 

[Guest]

Hi Alex,

One way you can copy row from one datatable to another datatable is to use
datatable. LoadDataRow method. Following snippet code shows how to do it:

Foreach (row As DataRow in sourceTable.Rows)
destinationTable.LoadDataRow(row.ItemArray, False)
Next


HTH

Elton Wang

 

[Robbe Morris [C# MVP]]

http://www.eggheadcafe.com/articles/copydatatable.asp

 

[Cor Ligthert [MVP]]

Alex,

You can use the datatable.importrow method, this prevents that when you use
this in an update this will be seen as a New Row.

http://msdn.microsoft.com/library/d...lrfsystemdatadatatableclassimportrowtopic.asp

I hope this helps,

Cor

 

[Guest]

Hi Robbe,

I think that in dotnet framework 1.1, there is DataTable.Copy() method.

http://msdn.microsoft.com/library/d...ml/frlrfsystemdatadatatableclasscopytopic.asp


Elton Wang

 

[Robbe Morris [C# MVP]]

That sample demonstrates this along with reminding you
that it sets a reference on each row to the new DataTable.

I assumed the poster didn't want to copy every row.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.masterado.net