查询数据库并将结果输出到C#中的build IN语句

using System;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        // 连接数据库
        string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword;";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 构建SQL查询语句
            string query = "SELECT ColumnName FROM TableName WHERE Condition";

            // 执行SQL查询语句
            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            // 构建build IN语句
            string buildInStatement = "IN (";
            while (reader.Read())
            {
                string value = reader.GetString(0); // 假设查询结果为字符串类型
                buildInStatement += "'" + value + "',";
            }
            buildInStatement = buildInStatement.TrimEnd(',') + ")";

            // 使用build IN语句进行进一步处理
            // TODO: 在此处添加你的代码，例如将build IN语句作为参数传递给其他方法或函数

            // 关闭连接
            reader.Close();
            connection.Close();
        }
    }
}