C#，将多行插入到SQL数据库中

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
        
        // 建立数据库连接
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            // 构建SQL插入语句
            string sql = "INSERT INTO YourTable (Column1, Column2) VALUES (@Value1, @Value2)";
            
            // 创建SqlCommand对象
            using (SqlCommand command = new SqlCommand(sql, connection))
            {
                // 添加参数
                command.Parameters.AddWithValue("@Value1", "Value1");
                command.Parameters.AddWithValue("@Value2", "Value2");
                
                // 执行插入操作
                command.ExecuteNonQuery();
            }
        }
        
        Console.WriteLine("数据插入成功！");
    }
}