• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

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?
0
baishali deb
Asked:
baishali deb
  • 2
2 Solutions
 
arnoldCommented:
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
 
ZberteocCommented:
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
 
arnoldCommented:
Mysqlbulkload is an interface to load data Infile for a .net app......
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now