MysqlBulk upload for a datatable

Hi

I have a datatable and want that datatable to upload in a table in mysql. I have used bulkupload in sql, need to know how we can do the same using MySqlBulkLoader.

I dont want to give each and every column name of the table while upload and neither want to convert the datatable to cvs format.

Is there a way i can directly bulk upload using mysql from datatable directly?
baishali debAsked:
Who is Participating?
 
ZberteocConnect With a Mentor Commented:
If you intend to import data from flat files inside MySQL then the LOAD statement is the way to go:

https://dev.mysql.com/doc/refman/5.7/en/load-data.html
0
 
arnoldConnect With a Mentor Commented:
Not sure what you have, mysqldump might be what you are looking for to backup a table from a database.
You could then restore the data from table into ...

To your question example for usage
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html
0
 
arnoldCommented:
Mysqlbulkload is an interface to load data Infile for a .net app......
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.