On the CopyDatafrom method does that copy the entire data data table or just the current row?
You can have it copy from the DataTable or the DataView. So if you use the DataView you could filter out just that one record then the CopyDataFrom would only move in that one record. This is the second parameter of the CopyDataFrom method that specifies the data that will be copied in and from where.
FYI....all DataTables already have a view attached to them so this is the view that will be used when using that option:
MyDataTable.DefaultView