csv file import

11y3.2k.NET

hi am saroj i need some help

i want to import csv file into mysql database table.

where csv file header and table column header order are not match. i give examaple

suppose my csv file header are like

1.name

2.ph_no

3.address

and my table column header are like

1.address

2.name

3.ph_no

4.postal_code

in that case how to import the csv file data into mysql database table

using upload button in asp.net???????

please help me i am fresher in that field

thanks in advance

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

11y ago
i just want to import csv file into mysql database table with gui mapping in asp.net.
here i am attach my design view file (screen short).

please help me.
Nilesh Jadav11y ago
Hey saroj!

Might this Source Code works for you !

http://www.codeproject.com/Articles/11435/Importing-CSV-Data-and-saving-it-in-database

https://www.youtube.com/watch?v=FueG-G83_PM

http://boxqs.com/tube/3YBTVn1a4oM/reading-csv-file-data-into-a-datatable-using-c-net
11y ago
i already try this sir .......
please send me the full code
Nilesh Jadav11y ago
Check here :

http://www.codeproject.com/Articles/12170/FileHelpers-v-Delimited-CSV-or-Fixed-Data-Impor
11y ago
can any one have complete demo como code to import csv file into mysql database using upload button in asp.net.
please help me i am fresher in this field.
thanks
Nilesh Jadav11y ago
refer this link :

http://www.nullskull.com/q/10391060/importing-csv-file-into-mysql-db-using-aspnet.aspx

http://www.developersnote.com/2013/11/how-to-upload-csv-file-into-mysql.html#.VaYE87Wddh8
11y ago
please any one help me for this issue.
Manas Mohapatra11y ago
If you have 100 columns and those are unordered then you have to do it manually inside your code.
Follow below code to read data from CSV file:

//Upload and save the file
string csvPath = Server.MapPath("~/Files/") + Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(csvPath);

// Creating data table to hold CSV data

DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Country",typeof(string)) });

string csvData = File.ReadAllText(csvPath);
foreach (string row in csvData.Split('\n'))
{
if (!string.IsNullOrEmpty(row))
{
dt.Rows.Add();
int i = 0;
foreach (string cell in row.Split(','))
{
dt.Rows[dt.Rows.Count - 1][i] = cell;
i++;
}
}
}

Then follow below link to insert whole CSV data into MySQL Database. I provided above code because below article is creating a custom data table and inserting into database.

https://jishnutkl.wordpress.com/tag/mysql-bulk-insert-from-c-net/
11y ago
yes sir i already download mysql connector and add mysql.data.dll
after that what can i do??

i just want to upload csv file

where database table have lot's of column field
suppose more then 100

and csv field are like
1.name
2.address
3.ph_no
and order are not match with the data table
suppose any order
order means
my my sql table ph_no is the first column
and my csv file first column is name or any ofthese
in that case how can i import csv file?
Manas Mohapatra11y ago
Hi,

As per my understanding you want to upload CSV file data to MySQL database on clicking of Upload button - Correct me I am wrong.

If my assumption is correct then you can follow 1st answer whatever I added.

If it didn't solve your problem please describe the problem deeply.

Thanks.
11y ago
sir i want insert csv file into my sql database using upload button in asp.net
Manas Mohapatra11y ago
Hi Saroj,

As per requirement please follow below steps link to import CSV file into MySQL database.

First download MySQL connector:
You need to use MySQL connector to connect MySQL database. Just download and add reference(MySql.Data.dll) in your project. You can download below link:

http://dev.mysql.com/downloads/connector/net/1.0.html

How to implement:
Below link provides how it can be implemented and data will insert at one shot.

http://theonetechnologies.com/outsourcing/post/mysql-bulk-data-import-using-net-connector-mysqlbulkloader-class.aspx

Hope this will help you.

Note: If you find anything useful please accept my answer.