CSV, Excel File Reading

Question

1.80/5 (2 votes)

See more:

Hi,

I have same table in both two databases(one is ource and other is target). I want to compare those two tables using C# amd find out which records are inserted and which are updated.Based on that I have to generate the final CSV file or Excel file, which has to be inserted into the target database into the same table.

Thanks in advance.

Posted 24-Jul-13 5:41am

sivared

Updated 24-Jul-13 6:35am

v2

Add a Solution

Comments

Ron Beyer 24-Jul-13 11:45am

OK, so what is your question? I see what you want to do, but nothing saying what you've tried or where you are stuck?

sivared 24-Jul-13 12:08pm

I have same table in both two databases(one is ource and other is target). I want to compare those two tables using C# amd find out which records are inserted and which are updated.Based on that I have to generate the final CSV file or Excel file, which has to be inserted into the target database into the same table.

[no name] 24-Jul-13 11:45am

Okay... and? Did you maybe have some sort of a question?

sivared 24-Jul-13 12:20pm

I have same table in both two databases(one is ource and other is target). I want to compare those two tables using C# amd find out which records are inserted and which are updated.Based on that I have to generate the final CSV file or Excel file, which has to be inserted into the target database into the same table.

[no name] 24-Jul-13 12:27pm

So? How is you repeating this over and over make this somehow a question? What is the specific issue that you are having with the code that you have written?

ZurdoDev 24-Jul-13 12:06pm

There are many many examples online. Where are you stuck?

sivared 24-Jul-13 12:20pm

I have searched , but my requirement is I have same table in both two databases(one is ource and other is target). I want to compare those two tables using C# amd find out which records are inserted and which are updated.Based on that I have to generate the final CSV file or Excel file, which has to be inserted into the target database into the same table. Please provide me one good link or site for this.

ZurdoDev 24-Jul-13 12:20pm

There are SQL comparison tools. Have you tried one of those?

sivared 24-Jul-13 12:24pm

We are using Oracle database. We cannot use Comparision tools. I have used Toad for the comparision.

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)

ExcelledProducts CEO · Accepted Answer · 2013-07-24T14:03:00

You can compare the amount of lines ...

If their are more lines in your new CSV then that means records have been added. This will only work if you know that other data is the same.

C#

[] oldCSV = System.IO.File.ReadAllLines("LOCATION");
[] newCSV = System.IO.File.ReadAllLines("LOCATION");

if ((newCSV.Length - 1) > (oldCSV.Length)) {
    //their are differences so get the new differences
    for (diff = Convert.ToInt32(((newCSV.Length - 1) > (oldCSV.Length))); diff <= newCSV.Length; diff++) {
        //do what you want with the changes
    }
} else {
    //no changes
}

If you want to compare each line to see if a certain value has been changed then you can loop through both of them.

C#

[] oldCSV = System.IO.File.ReadAllLines("LOCATION");
    [] newCSV = System.IO.File.ReadAllLines("LOCATION");

    foreach (object oldRecord_loopVariable in oldCSV) {
        oldRecord = oldRecord_loopVariable;
        foreach (object newRecord_loopVariable in newCSV) {
            newRecord = newRecord_loopVariable;
            if (oldRecord == newRecord) {
            //no record changed
            } else {
                //something is not the same
            }
        }
    }