DataSet Problem

Question

Hello

I have two dataset. there are more then 10k rows in both dataset.

Now I have to compare both dataset with multiple keys (Composite key) and find the differ rows based on that.

Means,
Dataset1 have County,State,ID,Address,PostalCode
Dataset2 have County,State,ID,Address,PostalCode

I have to compare with ID,County multiple key and find different and new rows

Can you give idea to do this?

I do not want loop each row which already hang the system

Thanks
Keyur

keyur · Answer

Thanks for reply. But I can not do like this.User import multiple files and i have to do runtime and find rows. Thanks for help

Joginder Banger · Answer

first of all csv file import in datatable. How to import csv file data in sql table try this link http://www.c-sharpcorner.com/UploadFile/5b3fc9/import-the-csv-file-data-in-sql-server-with-the-help-of-ssi/ Make a temporary file import in table . make a table as per your requirement. CountyStateIDAddressPostalCode

keyur · Answer

Below are few fields Dataset1 have CountyStateIDAddressPostalCode Dataset2 have CountyStateIDAddressPostalCode I have csv files and load to dataset. Can you help me ?

Joginder Banger · Answer

Hi Keyur first of all share your table design for better understanding what you try why are you used dataset for compare data. you can choose join for better performance.

Khargesh Rajput · Answer

http://www.codeproject.com/Articles/30102/Comparing-DataSets-using-LINQ