将DataTable中的值插入数据库

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

public class Program
{
    public static void Main()
    {
        // 连接数据库
        string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 创建插入命令
            string insertQuery = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)";
            using (SqlCommand command = new SqlCommand(insertQuery, connection))
            {
                // 添加参数
                command.Parameters.Add("@Value1", SqlDbType.VarChar);
                command.Parameters.Add("@Value2", SqlDbType.Int);

                // 遍历DataTable
                DataTable dataTable = GetDataTable(); // 假设有一个名为GetDataTable的方法返回一个DataTable对象
                foreach (DataRow row in dataTable.Rows)
                {
                    // 设置参数值
                    command.Parameters["@Value1"].Value = row["Column1"];
                    command.Parameters["@Value2"].Value = row["Column2"];

                    // 执行插入命令
                    command.ExecuteNonQuery();
                }
            }

            // 关闭连接
            connection.Close();
        }
    }
}