When Importing Data From Text File I Want To Update Database Table

Question

1.00/5 (2 votes)

See more:

when importing data from text file i want to update database table with new records(old + new records) and count the no of new records imported from textfile in C# windows form application.

I don't want to import records which are already present in database.

No primary key constraint in database table.

can any one help me to solve this problem.

Thanks.

Posted 4-Jun-14 23:52pm

Karthik Achari

Updated 4-Jun-14 23:53pm

v2

Add a Solution

Comments

Herman<T>.Instance 5-Jun-14 5:55am

Create a copy of the file in which you append a hashvalue based on the contents per line. If you store the hashes in your DB you can see which are new

Karthik Achari 5-Jun-14 6:39am

Can you help me how to append hash value in to database because i am a begineer to database and C#
Thanks for your valuable suggestion

Herman<T>.Instance 5-Jun-14 8:04am

make one long string from all fields in a datarow. Calculate the hash over this string and store it somewhere.

[no name] 5-Jun-14 6:11am

You have not described any problem as yet. All you have described so far is some work you need to do.

Karthik Achari 5-Jun-14 6:15am

i am importing data from text file and updated in the grid view and database but i want to know how many new records are imported(irrespective of old records)
Thanks

DamithSL 5-Jun-14 6:19am

can you update the question with your code?

Karthik Achari 5-Jun-14 6:21am

Ok

Richard MacCutchan 5-Jun-14 7:24am

Read each record from the text file. Use the key from that record to find the same key in the database. If the record exists then ignore it. If the record does not exist, then import it to the database and add 1 to the import counter. Repeat until EOF.

Karthik Achari 5-Jun-14 7:35am

Thanks a lot

ZurdoDev 5-Jun-14 7:24am

Where are you stuck?

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)

Prasad Avunoori · Answer 1 · 2014-06-05T23:59:00

1. Load the txt into a temporary table.

2. Use the "except" key word in sql server to get the records which are not existing in Actual table and existing in Temporary table.
e.g.

SQL

Select col1,col2, col3 from ActualTable
          Except
Select col1,col2, col3 from TemporaryTable

3. Then insert the resultant records of step 2 into ActualTable.