I have a
MySqlCommandBuilder commandBuilder = new MySqlCommandBuilder(adapter);
adapter.InsertCommand = commandBuilder.GetInsertCommand();
The only solution which I see is:
1) Convert DataTable to csv-> you can google it.
2) Save it on server side in temp directory.
MySqlBulkLoader here is link to article about it. Load the file saved in the temp directory.
4) After that delete the file from the temp directory.