Using a DataTable to Populate a DB

[checkai]

Here is what I need to do.
I have a selection of

Select * from tblWIP where WIPID = Variable

this will load a datatable with < 25 items into it....

Then I need to take those items loaded in the datatable and insert them into tblWIP
1.) With negative values and
2.) With 2 different values

This process is a WIP transfer which negates the first records and adds in new records....can I use the Datatable like this?

thanks,
DLC

 

[wsmall73]

this seems pretty simple or am I missing something....
populate the dataset and the you can use the datareader to loop through the records inserting them into another table.... with what ever logic you need in the middle.