DataSet Problem

keyur

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

keyur11y ago
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 Banger11y ago
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.

County,State,ID,Address,PostalCode
keyur11y ago
Below are few fields

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

I have csv files and load to dataset.

Can you help me ?
Joginder Banger11y ago
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 Rajput11y ago
http://www.codeproject.com/Articles/30102/Comparing-DataSets-using-LINQ