Merging datasets with different schema

Question

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?

mibuyt · Answer

Hi Question: 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. Answer: Actually you can merge datasets with different schemas with dataset.Merge(...). But the url you provided also use the merge method. Hmm.. how about showing me some snippets of code? Question: but they do not tell how to work when schema is not identicle Answer: Well you can look at DataSet.ReadXmlSchema method and do your own comparision between dataset schemas. I suggest you to look at IComparable interface. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataDataSetClassReadXmlSchemaTopic.asp Hope it helps you somewhere. Cheers.