DataGridView 基于单选按钮筛选数据

本文关键字：筛选 数据 单选按钮 DataGridView | 更新日期: 2023-09-27 18:30:51

我有一些单选按钮

一个单选按钮称为开放票证另一个称为封闭式票证

按下"打开工单"按钮时，我想筛选 DataGridView 上显示的数据

关于如何完成此操作的任何建议？

DataGridView 基于单选按钮筛选数据

您可以通过

对BindingSource应用过滤器来过滤datagridview。MSDN 提供了有关如何筛选绑定源的示例。链接以及代码如下。

来自 MSDN 的示例：

private void PopulateDataViewAndFilter()
{
    DataSet set1 = new DataSet();
    // Some xml data to populate the DataSet with.
    string musicXml =
        "<?xml version='1.0' encoding='UTF-8'?>" +
        "<music>" +
        "<recording><artist>Coldplay</artist><cd>X&amp;Y</cd></recording>" +
        "<recording><artist>Dave Matthews</artist><cd>Under the Table and Dreaming</cd></recording>" +
        "<recording><artist>Dave Matthews</artist><cd>Live at Red Rocks</cd></recording>" +
        "<recording><artist>Natalie Merchant</artist><cd>Tigerlily</cd></recording>" +
        "<recording><artist>U2</artist><cd>How to Dismantle an Atomic Bomb</cd></recording>" +
        "</music>";
    // Read the xml.
    StringReader reader = new StringReader(musicXml);
    set1.ReadXml(reader);
    // Get a DataView of the table contained in the dataset.
    DataTableCollection tables = set1.Tables;
    DataView view1 = new DataView(tables[0]);
    // Create a DataGridView control and add it to the form.
    DataGridView datagridview1 = new DataGridView();
    datagridview1.AutoGenerateColumns = true;
    this.Controls.Add(datagridview1);
    // Create a BindingSource and set its DataSource property to
    // the DataView.
    BindingSource source1 = new BindingSource();
    source1.DataSource = view1;
    // Set the data source for the DataGridView.
    datagridview1.DataSource = source1;
    //The Filter string can include Boolean expressions.
    source1.Filter = "artist = 'Dave Matthews' OR cd = 'Tigerlily'";
}
相关文章：