且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

筛选BindingSource和DataGridView

更新时间:2023-12-06 16:10:46

使用DataTable是最简单的方法,因此您不必实现IBindingListView

CS:

public partial class Form1 : Form
{
    MyDataTable dt;
    BindingSource bs;

    public Form1()
    {
        InitializeComponent();

        dt = new MyDataTable();
        bs = new BindingSource();
        bs.DataSource = dt.DefaultView;
        dataGridView1.DataSource = bs;
    }

    private void buttonAdd_Click(object sender, EventArgs e)
    {
        var r = new Random();
        var dr = dt.NewRow();
        dr[0] = r.Next(1111, 9999);
        dr[1] = r.Next(1111, 9999);
        dr[2] = r.Next(1111, 9999);
        dt.Rows.InsertAt(dr, 0);
    }

    private void buttonRemove_Click(object sender, EventArgs e)
    {
        dt.Rows.RemoveAt(0);
    }

    private void buttonClear_Click(object sender, EventArgs e)
    {
        textBox1.Text =
        textBox2.Text =
        textBox3.Text = string.Empty;
        UpdateDgv();
    }

    private void textBox1_TextChanged(object sender, EventArgs e)
    {
        UpdateDgv();
    }

    private void textBox2_TextChanged(object sender, EventArgs e)
    {
        UpdateDgv();
    }

    private void textBox3_TextChanged(object sender, EventArgs e)
    {
        UpdateDgv();
    }

    private void UpdateDgv()
    {
        string filter = GetFilter();

        if (filter != string.Empty)
            this.Text = filter;
        else this.Text = "All records";

        bs.Filter = filter;
    }

    private string GetFilter()
    {
        string filter = string.Empty;

        if (textBox1.Text != string.Empty)
            filter = string.Format("Data1 like '{0}%'", textBox1.Text);

        if (textBox2.Text != string.Empty)
        {
            if (textBox1.Text != string.Empty)
                filter += " and ";
            filter += string.Format("Data2 like '{0}%'", textBox2.Text);
        }

        if (textBox3.Text != string.Empty)
        {
            if (filter != string.Empty)
                filter += " and ";
            filter += string.Format("Data3 like '{0}%'", textBox3.Text);
        }

        return filter;
    }
}

数据表:

public class MyDataTable : DataTable
{
    public MyDataTable()
    {
        Columns.Add("Data1", typeof(string));
        Columns.Add("Data2", typeof(string));
        Columns.Add("Data3", typeof(string));

        DataRow dr;
        var r = new Random();
        for (int i = 0; i < 1000; i++)
        {
            dr = NewRow();
            dr["Data1"] = r.Next(1111, 9999);
            dr["Data2"] = r.Next(1111, 9999);
            dr["Data3"] = r.Next(1111, 9999);
            Rows.Add(dr);
        }
    }
}