c#中带有文本框和复选框的Select语句

// 引入必要的命名空间
using System;
using System.Data.SqlClient;
using System.Windows.Forms;

// 创建一个窗体类
public class MainForm : Form
{
    private TextBox textBox;
    private CheckBox checkBox;
    private Button button;

    public MainForm()
    {
        // 初始化窗体和控件
        this.textBox = new TextBox();
        this.checkBox = new CheckBox();
        this.button = new Button();

        this.textBox.Location = new System.Drawing.Point(10, 10);
        this.textBox.Size = new System.Drawing.Size(200, 20);

        this.checkBox.Location = new System.Drawing.Point(10, 40);
        this.checkBox.Text = "选择条件";

        this.button.Location = new System.Drawing.Point(10, 70);
        this.button.Text = "查询";
        this.button.Click += new EventHandler(this.Button_Click);

        this.Controls.Add(this.textBox);
        this.Controls.Add(this.checkBox);
        this.Controls.Add(this.button);
    }

    private void Button_Click(object sender, EventArgs e)
    {
        // 获取用户选择的条件
        string condition = "";
        if (this.checkBox.Checked)
        {
            condition = " WHERE column = '" + this.textBox.Text + "'";
        }

        // 构建查询语句
        string query = "SELECT * FROM table" + condition;

        // 执行查询并处理结果
        using (SqlConnection connection = new SqlConnection("connectionString"))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
    }

    // 入口方法
    public static void Main()
    {
        Application.Run(new MainForm());
    }
}