ADO.Net批量插入数据

using System.Data.SqlClient;

public void BulkInsert(DataTable dataTable, string connectionString)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();

        using (SqlTransaction transaction = connection.BeginTransaction())
        {
            using (SqlCommand command = new SqlCommand())
            {
                command.Connection = connection;
                command.Transaction = transaction;
                command.CommandText = "INSERT INTO [TableName] ([Column1], [Column2], [Column3]) VALUES (@Value1, @Value2, @Value3)";

                command.Parameters.Add("@Value1", SqlDbType.NVarChar, 50);
                command.Parameters.Add("@Value2", SqlDbType.Int);
                command.Parameters.Add("@Value3", SqlDbType.DateTime);

                foreach (DataRow row in dataTable.Rows)
                {
                    command.Parameters["@Value1"].Value = row["Column1"];
                    command.Parameters["@Value2"].Value = row["Column2"];
                    command.Parameters["@Value3"].Value = row["Column3"];

                    command.ExecuteNonQuery();
                }
            }

            transaction.Commit();
        }
    }
}

DataTable dataTable = new DataTable();
// 填充数据到DataTable
BulkInsert(dataTable, "your_connection_string");