compare data in one datatable against the data in another

Question

0.00/5 (No votes)

See more:

Hi,
I have two datatables.
dtToBeChecked and dtCriteria
dtCriteria is a set of records which have criteria for each field in dtToBeChecked.
The records inside dtToBeChecked need to be checked against dtCriteria to see if the data match. (Trying to make sure that the data in dtToBeChecked are all valid and match the criteria in dtCriteria and if one of the values in dtToBeChecked does not match what is in the dtCriteria then return false).
For example, the fields in dtToBeChecked are all present in dtCriteria. And the values in dtToBeChecked will be checked against the values for the entered fields in dtCriteria.

I have decided to:
1- loop through the rows in dtToBeChecked
2- get the fieldname and cell value
3- loop through the rows in dtCriteria and see if there is a match.
4 return false if there is no match.

Is what I am trying to do correct?

Thanks

Posted 13-Oct-11 23:20pm

arkiboys

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodingLover · Answer 1 · 2011-10-13T23:35:00

For me it's not a good approach. Because your iteration is number_records_in_table_1 * number_records_in_table_2

I have an options as follows,
- Sort both tables by a unique ID. (I hope you have a such, and this is one of the advantages having a unique key)
- Step on both tables at once and compare the IDs. If you find a mismatch then the comparison is failed. You can log data and do whatever you want at that point.

Improving more that, you can traverse through the first table and load all the unique IDs to a dictionary. Then traverse through the second table and compare against the dictionary.

shijuse · Answer 2 · 2011-10-13T23:38:00

Solution 2

http://forums.asp.net/t/1459790.aspx[^]

or

http://stackoverflow.com/questions/164144/c-how-to-compare-two-datatables-a-b-how-to-show-rows-which-are-in-b-but-not[^]

Posted 13-Oct-11 23:38pm

shijuse

Updated 13-Oct-11 23:41pm

v4

Comments

André Kraak 14-Oct-11 5:41am

I made your links click-able.

CodingLover 14-Oct-11 5:45am

Oh, that may be I couldn't do that. ;) Anyway, now it's more clear.