如何按textBox过滤数据库中的数据以在列表中显示C#中的结果视图

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace FilterDataExample
{
    public partial class Form1 : Form
    {
        private SqlConnection connection;
        private SqlDataAdapter adapter;
        private DataSet dataSet;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // 连接到数据库
            string connectionString = "YourConnectionString";
            connection = new SqlConnection(connectionString);
            connection.Open();

            // 查询并过滤数据
            string query = "SELECT * FROM YourTable";
            adapter = new SqlDataAdapter(query, connection);
            dataSet = new DataSet();
            adapter.Fill(dataSet, "FilteredData");

            // 显示结果
            dataGridView1.DataSource = dataSet.Tables["FilteredData"];
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            // 过滤数据
            string filter = textBox1.Text;
            dataSet.Tables["FilteredData"].DefaultView.RowFilter = $"ColumnName LIKE '%{filter}%'";
        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            // 关闭连接
            connection.Close();
        }
    }
}