Import CSV file with Visual studio C #

Question

1.00/5 (2 votes)

See more:

hello,

I have a website project with C # language. my idea is to use the FileUpload tool of Visual Studio to import files to my application. what i need is to import a CSV file that contains dozens of data, in order to insert these data in my database.
an example is I have a table "Customer" which has the following structure:
id_custumer int IsIdentity,
name varchar (100),
surname varchar (100),
age int,
locality varchar (200)

as I said, I have created a csv file that contains various customer data. I want, through FileUpload, import this file into my application and adding the data to my table "customer".

any idea how to do this?

Posted 19-Aug-13 23:43pm

fasher_the_one

Add a Solution

Comments

OriginalGriff 20-Aug-13 5:47am

What have you tried?
Where are you stuck?

fasher_the_one 20-Aug-13 5:52am

as I'm giving my first steps with the visual studio, I'm still learning a lot. this is my first case where I need this solution. what I mean is that it has not moved forward at all in this problem. what I've got is just a page containing an FileUpload. the rest I still do not know how to solve.

OriginalGriff 20-Aug-13 6:02am

OK, it's not too complex: just take it in easy stages.
First off, can you get the FileUpload to load a file into your program (Whether you store it as a file or keep it as data in your code)?

fasher_the_one 20-Aug-13 6:12am

Let me explain by steps.
I intend to import the csv file for my project, but I want to store in the database the data contained in that file and not the file. imagines that the csv file has 50 customers data, then when I import this file into my project, I plan to add these 50 data in the table "customer" of my database

OriginalGriff 20-Aug-13 6:55am

:laugh:
Yes I kinda figured that...
So if you can upload the file, you need to process the CSV data into fields and rows, then add it to your DB.
Can you process the CSV once it is uploaded yourself?

fasher_the_one 20-Aug-13 7:28am

I did not understand well what you asked me. but let me answer if this is the question. my csv file is ready and well processed because within SQL I can enter the data in the table through the BUILK INSERT.
but now I need to insert this in my project, where I intend to import this csv file in FileUpload and process the data so that they can be added in the table.
I do not know if I made myself clear.

4 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)

Pheonyx · Answer 1 · 2013-08-19T23:52:00

Reading a CSV file is a very basic concept and there are thousands of links on how to do it if you use google.

Once you have a tool that can read the CSV the next stage is to insert the data in the your database (I am making an assumption that it is an SQL database, but if it is not then it should still be fairly straight forward). You need to google SQL Insert Statement and the SQL Command object (.Net).

Once you have those two working, then all you need is a file upload mechanism in your website that sends the file to the server and triggers the import once the file is transferred. Again this is easy to find via Google, I should know I had to look up the same thing about 6 weeks ago as I completely forgot how to do it.

You are not doing anything hard here, nor anything that has not been done 1000's of times before, so try actually searching for stuff rather than expecting the code to be handed to you.

I suggest you look up CSV helper as a tool to help with reading the CSV file, and make sure you encode some validation into the process incase people pass you incorrectly formatted files.
Also look up SQLParameters to help prevent against SQL Injection attacks via the file upload process.

Once you basic processes are in place, I suggest you consider the limitations, if you are uploading 1000's of records you might want to consider asynchronous processing of the file so you can inform the user of progress, or just have the file submitted and run the import on a background thread and send out an e-mail once it is complete/failed.

Thomas ktg · Answer 2 · 2013-08-19T23:51:00

Solution 1

Hi fasher,

If this is what you are expecting please go through this links.

Reading and Writing CSV Files in C#[^]
A Fast CSV Reader[^]
http://stackoverflow.com/questions/1050112/how-to-read-a-csv-file-into-a-net-datatable[^]

Posted 19-Aug-13 23:51pm

Thomas ktg

Om Prakash Pant · Answer 3 · 2013-08-19T23:54:00

Solution 3

Please check here for an example

Posted 19-Aug-13 23:54pm

Om Prakash Pant

Comments

fasher_the_one 20-Aug-13 6:14am

obrigada,

mas eu não pretendo armazenar o ficheiro em si, mas sim os dados contidos nesse ficheiro (csv)

Gitanjali Singh · Answer 4 · 2013-08-20T01:50:00

Solution 4

Try this link

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

Posted 20-Aug-13 1:50am

Gitanjali Singh