使用SqlParameter从2个表中获取数据

SELECT table1.column1, table2.column2
FROM table1
INNER JOIN table2 ON table1.id = table2.id
WHERE table1.column3 = @param1

string connectionString = "YourConnectionString";
string query = "SELECT table1.column1, table2.column2 FROM table1 INNER JOIN table2 ON table1.id = table2.id WHERE table1.column3 = @param1";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    using (SqlCommand command = new SqlCommand(query, connection))
    {
        command.Parameters.AddWithValue("@param1", paramValue);

        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 获取查询结果中的数据
                var column1Value = reader["column1"];
                var column2Value = reader["column2"];

                // 进行后续处理
            }
        }
    }
}