Merging datasets with different schema

Mar 11 2005 12:49 PM
I am trying to learn how to work with datasets. In my previous post I asked about setting a primary key because I thought when I merged two data sets with different schema it would work like sql join, but it does not. I have followed this article and made 2 datasets merge with same schema but they do not tell how to work when schema is not identicle: http://aspalliance.com/148 I think I may need to create a 3rd dataset, with columns for both datasets then fill the 3rd dataset with rows from dataset 1 & 2... Is there a way to merge schemas?

Answers (1)