Hows compare each records of Two Table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Dear Developer,
I have to compare 2 table. I want to compare the each record entry of the both table in c# or vb.net coding.If any record is miss from one table to other table then i insert that record on that table.
Any body tell wats logic i implement to compare the each record of 2 table or its greatful for me if anybody share small code for implementing this logic.

In both table have 3 coloum "Trans_Id", "number" ,"Amount"

Thanks,
Ravi Sharma

Posted 19-Jul-11 9:12am

Ravi Sharma 2

Add a Solution

Comments

Kschuler 19-Jul-11 15:16pm

What code do you have so far? What isn't working?

1 solution

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)

OriginalGriff · Answer 1 · 2011-07-19T09:17:00

You could always run a query that returns only the different records:

SELECT Trans_Id, number ,Amount FROM myTable1
EXCEPT
SELECT Trans_Id, number ,Amount FROM myTable2

This returns the records that are in myTable1 but not in myTable2

"thanks for your reply, but this i have to do with c# coding."

Then it's a simple merge job:

1) Set up two SqlCommand objects, one per table.
2) Return each table, ordered by the three fields in the same order, into a separate reader.
3) Loop round, building two lists of records that need to be added.
3a) If one side runs out, add all remaining records from the other side to it's list.
3b) If Table1 current record is greater than Table2, add Table 2 record to Table1 list and advance Table 2. Do the same for Table2. If they are the same, move both on.
4) When you run out of records, add the appropriate list to the appropriate table.