将数组添加到我的ExecuteReader()函数

string[] array = { "value1", "value2" };
// 错误的用法
SqlDataReader reader = command.ExecuteReader(array);

string[] array = { "value1", "value2" };
string connectionString = "your_connection_string";
string queryString = "SELECT * FROM YourTable WHERE YourColumn IN ({0})";

// 构建参数化查询字符串
string inClause = string.Join(",", array.Select((value, index) => "@p" + index));
queryString = string.Format(queryString, inClause);

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(queryString, connection);
    
    // 添加参数
    for (int i = 0; i < array.Length; i++)
    {
        command.Parameters.AddWithValue("@p" + i, array[i]);
    }
    
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();
    
    // 处理DataReader...
}