C#交叉连接数据表

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

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string sqlQuery = "SELECT * FROM Table1 CROSS JOIN Table2";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(sqlQuery, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                // 处理结果集中的数据
            }

            reader.Close();
        }
    }
}