how to import csv file into the database using vb.net

Question

0.00/5 (No votes)

See more:

help me please

i want to import test.csv into database using vb.net

first i will upload test.csv into text box
and after that i will click "submit" button to import it into the database sqlserver

i want to put test.csv into
table name which contains name,contacts

i hope someone can help me because it is urgent

Posted 11-May-10 4:23am

rainbowemo

Add a Solution

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

Tom Deketelaere · Answer 1 · 2010-05-11T04:37:00

This looks suspiciously a lot like homework.

So here is a way to get you started (nobody will just give you the code for this)

Step 1 : create form with textbox (probably better to take a richtextbox since that's multiline)

Step 2: read the .csv file (it's just a text file so read it like any other text file) in the load / shown / button click event
You can use several methodes for this (streamreader / my.computer.filesystem... / ...)

Step 3: write it to the database (look into connecting to database)
You'll need the namespace: system.data.sqlclient
look into: sqlconnection / sqlcommand / sqlparamater (very important) / sqltransaction / ...

You'll also need to know how to split the text you'v read into the corresponding columns. (usually there is a character indicating the start of a new column)

You'll have to the research on your own for this.

rainbowemo · Answer 2 · 2010-05-11T04:53:00

its not a homework.but i just learn vb.net only 2 days and i need to learn very fast because i have urgent matters
i have done the upload part.where i click upload and the test.csv were uploaded into the text box

the problem is
i just need "submit" button to work.but it seems didnt work out.i want it when i click submit, it will import the test.csv to sms_contact table in sql server
noob here.need an example to learn from

William Winner · Answer 3 · 2010-05-11T05:27:00

Solution 3

If you need an example, then I suggest you use google. There is a wealth of information on how to do just what you are asking.

Here, I've done the hard part for you: http://tinyurl.com/26zoa5f[^]

Posted 11-May-10 5:27am

William Winner

how to import csv file into the database using vb.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0