how to add a existing datatable rows to new datatable rows?

[rajesh.forum]

hi all!
im checking a value with datatable's each row value of a particular column.If the condition satisfied then that particular complete row values should be shifted in new datatable row..thats it..Thanks in advance for ur suggestion..

with regards
rajesh.

 

[cjard]

Something like:

Dim foundRows() as RajeshDataRow = rajestDataSet.RajeshDataTable.Select("[rajeshColumn] = 'rajesh'")
Dim newDataTable as New RajeshDataTable
If rows.Length > 0 Then
  For Each ro as rajeshDataRow In foundRows
     rajeshDataSet.rajeshDataTable.RemoveRow(ro)
     newDataTable.AddRajeshRow(ro)
  Next ro
End If