如何使用C#.Net将Excel中的内容更新到MySql数据库

using System;
using System.Data;
using System.Data.OleDb;
using MySql.Data.MySqlClient;

namespace ExcelToMySQL
{
    class Program
    {
        static void Main(string[] args)
        {
            // 连接MySQL数据库
            string connectionString = "server=localhost;user=root;password=123456;database=mydatabase;";
            MySqlConnection connection = new MySqlConnection(connectionString);
            connection.Open();

            // 读取Excel数据
            string excelFilePath = "C:\\path\\to\\excel.xlsx";
            string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties='Excel 12.0;HDR=YES;'";
            OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
            excelConnection.Open();
            OleDbCommand excelCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", excelConnection);
            OleDbDataReader excelDataReader = excelCommand.ExecuteReader();

            // 遍历Excel数据并插入到MySQL数据库
            while (excelDataReader.Read())
            {
                string column1Value = excelDataReader.GetString(0);
                int column2Value = excelDataReader.GetInt32(1);

                // 创建MySQLCommand对象并执行插入操作
                MySqlCommand mysqlCommand = new MySqlCommand("INSERT INTO mytable (column1, column2) VALUES (@column1, @column2)", connection);
                mysqlCommand.Parameters.AddWithValue("@column1", column1Value);
                mysqlCommand.Parameters.AddWithValue("@column2", column2Value);
                mysqlCommand.ExecuteNonQuery();
            }

            // 关闭连接
            excelDataReader.Close();
            excelConnection.Close();
            connection.Close();

            Console.WriteLine("Excel数据已成功更新到MySQL数据库。");
            Console.ReadLine();
        }
    }
}