Filter DataGridView with the text entered in TextBox in WinForms

• Download source code - 21.6 KB

Introduction

In this article, let us see how to filter a DataGridView when we type some values in a textbox.

Using the code

1. Create a new Windows application. Add a DataGridView and a TextBox control.



2. I have an XML file which am going to bind to the GridView.
XML File 1

<?xml version="1.0" standalone="yes" ?> 
- <NewDataSet>
- <Table1>
  <Server>Server1</Server> 
  <Database>Database1</Database> 
  </Table1>
- <Table1>
  <Server>Server2</Server> 
  <Database>Database2</Database> 
  </Table1>
- <Table1>
  <Server>Server3</Server> 
  <Database>Database3</Database> 
  </Table1>
</NewDataSet>

3. Create two properties of type DataSet and DataView as below.

public DataSet ds
{
    get;
    set;
}

public DataView dv
{
    get;
    set;
}

4. In the Form constructor, create an object of DataSet and DataView.

public Form1()
{
    InitializeComponent();
    ds = new DataSet();
   dv = new DataView();
}

5. Now in the form load, read the XML file and save the values into the DataSet. Then load the tables inside DataView with DataTable inside DataSet. Now bind this DataView to the GridView.

private void Form1_Load(object sender, EventArgs e)
{
    string path = "C:\\XMLFile1.xml";
    ds.ReadXml(path);            
    dv.Table = ds.Tables[0];
    dataGridView1.DataSource = dv; 
}

6. Now in the text_changed property of the textbox, add the below code. Here I am filtering it with the column Server.

dv.RowFilter = "Server like '%" + textBox1.Text + "%'";
dataGridView1.DataSource = dv;

7. Run the application and check.
1. Form load.



2. Valid data in column Server.



3. Invalid data in column Server.

I have attached the complete source code also.