How to combine datasets?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have one dataset with columns a thru c. Then another that gets
columns a and d thru f. I need a dataset that has columns a thru f.
What is the best way to do it?

I currently have a thru c in dataset1. Then I use a datareader for set
#2 and start constructing a new dataset in the reader loop.

Thanks,
Brett

.

Relevant Pages