Copy C# datatable into mysql database table

Question

I have created one DataTable in C# dynamically. I want to insert this whole DataTable in MySql database table.

I am using MySql hence SqlBulkCopy is not an option for me. I have tried MySqlBulkLoader but it seems it only insert data from file.

I can do it via iterating through every datarow of datatable and insert it to database.

Is there any another way I can achieve multiple inserts into database?

Thanks for any help!

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter(v=vs.71).aspx — Derek, Dec 03 '12 at 12:28

score 0 · Accepted Answer · answered Dec 03 '12 at 12:38

If the number of rows are not much you can simply create an insert statement INSERT INTO table VALUES (1,2,3), (4,5,6), (7,8,9);

Though, if the number of rows are high, you can probably create a temporary text file and then use BulkLoader !

1 Answers1