Copy data table to mysql table

[MostafaFCI4]

I have a C# .NET Application which get data from QuickBooks via the ODBC Driver and save the result to C# data table.
So, I want to transfer this data table to a mysql table on my own server. That's the code I use:

 
using System.IO;
using MySql.Data.MySqlClient;
//Add mysql dll on the .NET Tab in Project's references
 
string connStr = "DSN=QBTest;";
 
            string myServerAddress = "192.168.0.243";
            string myDataBase = "CostTest";
            string myUsername = "root";
            string myPassword = "itpassw0rd_1";
            string mysqlStr = "SERVER=" + myServerAddress + ";" +
                                "DATABASE=" + myDataBase + ";" +
                                "UID=" + myUsername + ";" +
                                "PASSWORD=" + myPassword + 
                                ";Allow Zero Datetime=true;";
            MySqlConnection myConn = new MySqlConnection(mysqlStr);
            //string connStr = "DSN=QuickBooks Data;OLE DB Services=-2;";
            OdbcConnection conn = new OdbcConnection(connStr);
            string comStr = "sp_report TxnDetailByAccount show TxnType, Date, RefNumber, Name, Memo, TextItemName, Debit, Credit, RunningBalance parameters DateFrom={d'2009-01-01'}, DateTo={d'2009-12-31'}, AccountFilterFullNameWithChildren='Cost of Goods Sold', SummarizeRowsBy='ItemDetail'";
            OdbcDataAdapter da = new OdbcDataAdapter(comStr, conn);
            try
            {
                conn.Open();
                DataTable dt1 = new DataTable();//dataSet1.Account;
                da.Fill(dt1);
                dataGridView1.DataSource = dt1;
                dataGridView1.AutoGenerateColumns = true;
}
catch
            {
                MessageBox.Show("Failed to connect with QuickBooks ODBC!");
            }
            finally
            {
                conn.Close();
            }
 
 

[r035198x]

Use code tags when posting code.
So, what's the problem? Does the code compile? Does it run with errors?

[MostafaFCI4]

the code run without errors. Until the line 28 it populates the result of my query, but all I need to transfer this result to mysql table