copy datarow from one dataset to another

[cpopham]

I have a dataview set up to filter a dataset based on a combobox selection the user makes. Now how do I copy that particular datarow the user has selected into another dataset?

 

The unique field of the datarow ReqNum.

 

 

Chester

[Nerseus]

You can do it one of two ways, both manual but one more so than the other. I assume the DataSet's have tables with the same columns already?

 

The manual-manual method: loop through each row in your filtered DataView. Then loop through each column in your source table and copy the data elements to a NewRow created from the destination datatable.

 

The auto-manual method: Use dataset.Copy to get a new dataset then delete the unwanted rows (use a filter that's backwards to what you have). Use MergeRows on the destination table, passing in the slimmed down copied dataset.

 

-ner