appending rows to datatable

[shankar]

Hi all,

This is the way to append the rows from one datatable into another with the
same schema.

Here Temp and Temp1 are the datatables

For Each rows As DataRow In tempTable.Rows
Temp1 .NewRow()
Temp1 .ImportRow(rows )
Next

-Vignesh.S

[Ollie Riches]

check out ItemArray on the DataRow class

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata datarowclassite marraytopic.asp

something like:

foreach(Datarow row in Table1.Rows)
{
DataRow newRow = Table2.NewRow() ;
newRow.ItemArra y = row.ItemArray;
}

--
HTH

Ollie Riches
http://www.phoneanalyser.net

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

"shankar" <sh*****@discus sions.microsoft .com> wrote in message
news:EF******** *************** ***********@mic rosoft.com...

Hi all,

This is the way to append the rows from one datatable into another with the same schema.

Here Temp and Temp1 are the datatables

For Each rows As DataRow In tempTable.Rows
Temp1 .NewRow()
Temp1 .ImportRow(rows )
Next

-Vignesh.S

[Ollie Riches]

should have been

foreach(Datarow row in Table1.Rows)
{
DataRow newRow = Table2.NewRow() ;
newRow.ItemArra y = row.ItemArray;

Table2.Rows.Add (newRow);
}

Ollie Riches
"Ollie Riches" <ol**********@p honeanalser.net > wrote in message
news:ux******** ******@TK2MSFTN GP12.phx.gbl...

check out ItemArray on the DataRow class

http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdata datarowclassite marraytopic.asp

something like:

foreach(Datarow row in Table1.Rows)
{
DataRow newRow = Table2.NewRow() ;
newRow.ItemArra y = row.ItemArray;
}

--
HTH

Ollie Riches
http://www.phoneanalyser.net

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a programmer
helping programmers.

"shankar" <sh*****@discus sions.microsoft .com> wrote in message
news:EF******** *************** ***********@mic rosoft.com...

Hi all,

This is the way to append the rows from one datatable into another with

the

same schema.

Here Temp and Temp1 are the datatables

For Each rows As DataRow In tempTable.Rows
Temp1 .NewRow()
Temp1 .ImportRow(rows )
Next

-Vignesh.S