Merging datasets with different schema

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.