从SELECT IN语句C#获取值

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
        string query = "SELECT * FROM YourTable WHERE YourColumn IN (@Value1, @Value2)";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            command.Parameters.AddWithValue("@Value1", "Value1");
            command.Parameters.AddWithValue("@Value2", "Value2");

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                // 获取每一行的数据值
                string value = reader["YourColumn"].ToString();
                Console.WriteLine(value);
            }

            reader.Close();
        }
    }
}