csv file import

Question

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

saroj bhattacharya · Answer

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 Jadav · Answer

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

saroj bhattacharya · Answer

i already try this sir ....... please send me the full code

Nilesh Jadav · Answer

Check here : http://www.codeproject.com/Articles/12170/FileHelpers-v-Delimited-CSV-or-Fixed-Data-Impor

saroj bhattacharya · Answer

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 Jadav · Answer

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

saroj bhattacharya · Answer

please any one help me for this issue.

Manas Mohapatra · Answer

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(Countrytypeof(string)) }); string csvData = File.ReadAllText(csvPath); foreach (string row in csvData.Split('
')) { 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/

saroj bhattacharya · Answer

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 Mohapatra · Answer

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.

saroj bhattacharya · Answer

sir i want insert csv file into my sql database using upload button in asp.net

Manas Mohapatra · Answer

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.