将嵌套集合写入数据表c#

// 嵌套集合示例数据
List<List<string>> nestedList = new List<List<string>>();
nestedList.Add(new List<string> { "John", "Doe", "john.doe@example.com" });
nestedList.Add(new List<string> { "Jane", "Smith", "jane.smith@example.com" });

// 连接到数据库
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // 遍历嵌套集合并插入数据
    foreach (List<string> innerList in nestedList)
    {
        // 创建SQL插入语句
        string sql = "INSERT INTO YourTable (Column1, Column2, Column3) VALUES (@Value1, @Value2, @Value3)";

        // 创建命令对象
        using (SqlCommand command = new SqlCommand(sql, connection))
        {
            // 设置参数值
            command.Parameters.AddWithValue("@Value1", innerList[0]);
            command.Parameters.AddWithValue("@Value2", innerList[1]);
            command.Parameters.AddWithValue("@Value3", innerList[2]);

            // 执行插入操作
            command.ExecuteNonQuery();
        }
    }
}