如何在一个简单但完整的c#项目中连接来自两个不同sql server数据库的两个表？

using System.Data.SqlClient;

string connStr1 = "Server=Server1;Database=DB1;User Id=username;Password=password;";
string connStr2 = "Server=Server2;Database=DB2;User Id=username;Password=password;";

SqlConnection conn1 = new SqlConnection(connStr1);
conn1.Open();

SqlConnection conn2 = new SqlConnection(connStr2);
conn2.Open();

string sql1 = "SELECT * FROM Table1;";
string sql2 = "SELECT * FROM Table2;";

SqlCommand cmd1 = new SqlCommand(sql1, conn1);
SqlCommand cmd2 = new SqlCommand(sql2, conn2);

// 执行查询，并获取数据
SqlDataReader reader1 = cmd1.ExecuteReader();
SqlDataReader reader2 = cmd2.ExecuteReader();

// 处理查询结果
while (reader1.Read())
{
    // 从第一个表中获取数据
    string data = reader1.GetString(0);
    // 进行适当的处理或操作
}

while (reader2.Read())
{
    // 从第二个表中获取数据
    string data = reader2.GetString(0);
    // 进行适当的处理或操作
}

// 关闭连接和读取器
reader1.Close();
reader2.Close();
conn1.Close();
conn2.Close();

using (SqlConnection conn1 = new SqlConnection(connStr1))
{
    conn1.Open();
    using (SqlCommand cmd1 = new SqlCommand(sql1, conn1))
    {
        using (SqlDataReader reader1 = cmd1.ExecuteReader())
        {
            while (reader1.Read())
            {
                // 处理查询结果
            }
        }
    }
}

using (SqlConnection conn2 = new SqlConnection(connStr2))
{
    conn2.Open();
    using (SqlCommand cmd2 = new SqlCommand(sql2, conn2))
    {
        using (SqlDataReader reader2 = cmd2.ExecuteReader())
        {
            while (reader2.Read())
            {
                // 处理查询结果
            }
        }
    }
}