用于将多个数据插入数据库的C#嵌套循环

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // 数据库连接字符串
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";

        // 多个数据
        int[] data1 = { 1, 2, 3 };
        string[] data2 = { "A", "B", "C" };

        // 嵌套循环插入数据库
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 外层循环遍历第一个数据数组
            for (int i = 0; i < data1.Length; i++)
            {
                // 内层循环遍历第二个数据数组
                for (int j = 0; j < data2.Length; j++)
                {
                    // 构造SQL插入语句
                    string sql = $"INSERT INTO YourTable (Column1, Column2) VALUES ({data1[i]}, '{data2[j]}')";

                    // 执行SQL插入语句
                    using (SqlCommand command = new SqlCommand(sql, connection))
                    {
                        command.ExecuteNonQuery();
                    }
                }
            }
        }

        Console.WriteLine("数据插入完成。");
        Console.ReadLine();
    }
}