如何使用SqlCommand搜索具有多个输入的数据

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
        string query = "SELECT * FROM YourTable WHERE Column1 = @Value1 AND Column2 = @Value2";

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

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                // 添加参数
                command.Parameters.AddWithValue("@Value1", "Input1");
                command.Parameters.AddWithValue("@Value2", "Input2");

                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 处理查询结果
                        Console.WriteLine(reader["ColumnName"]);
                    }
                }
            }
        }
    }
}