且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用mysqlbulkloader将数据表导入mysql表

更新时间:2023-01-21 14:02:56





尝试检查以下链接:

http://dev.mysql.com/doc/refman/5.1/en/connector-net-programming-bulk-loader.html [ ^ ]



问候

Robert


 错误  7  '  colummap'不是'MySql.Data的成员.MySqlClient.MySqlBulkLoader。跨度> 


How to import data table to mysql table using mysqlbulkloader using c#

 public void SqlBulkCopyImport(DataTable dt,string TableName)
        {
            try
            {
                {
                    con.Open();
                    MySqlBulkLoader bulkCopy = new MySqlBulkLoader(con);
//                    {
                        // Specify the destination table name.
                        bulkCopy.TableName = TableName;
//                        foreach (DataColumn dc in dt.Columns)
//                        {
//                            bulkCopy.colummap.Add(dc.ColumnName, dc.ColumnName);
//                        }
                        // Write from the source to the destination.
                        //how exactly to do this??
//                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }

Hi,

try to check following link:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-programming-bulk-loader.html[^]

Regards
Robert


Error   7   'colummap' is not a member of 'MySql.Data.MySqlClient.MySqlBulkLoader'.