winform数据库批量提交

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "your_connection_string_here";
        string tableName = "YourTableName";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
            {
                bulkCopy.DestinationTableName = tableName;

                DataTable data = new DataTable();
                data.Columns.Add("Column1", typeof(int));
                data.Columns.Add("Column2", typeof(string));

                // 添加数据
                data.Rows.Add(1, "Value1");
                data.Rows.Add(2, "Value2");
                data.Rows.Add(3, "Value3");

                bulkCopy.WriteToServer(data);
            }

            connection.Close();
        }
    }
}