how to create and insert a large csv file into data table?

Question

0.00/5 (No votes)

See more:

I have 77 columns' and 3000 rows in my csv file. I have to store it in a data base programmaticaly.some columns are integer and some of them are varchar.
please show me an example or any link that topic explained.how to split,remove spaces etc.using file streame reader how can I do this?
how can I insert? pls help mee

Posted 16-Jun-15 2:51am

Manidas Payyoli

Add a Solution

Comments

Tomas Takac 16-Jun-15 9:07am

Do you need to do that form C#? Otherwise you can use BULK INSERT[^] command.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mathew Soji · Answer 1 · 2015-06-16T03:34:00

Solution 1

Please refer below.

C# - CSV Import Export[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=323[^]

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-csv-file-records-into-sql-server-database-using-as/[^]

Posted 16-Jun-15 3:34am

Mathew Soji

Updated 16-Jun-15 3:38am

v2

how to create and insert a large csv file into data table?

1 solution

Solution 1

Add your solution here

Preview 0

how to create and insert a large csv file into data table?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us