Filter row in DataGridView in vb.net

34 Views Asked by At

I am doing a project where I have to filter row using rowHeader in Header. in DataGridView in vb.net. Can you help me to find the correct way to filter. I can't use.RowFilter. I am using 4.8 .Net framework.

 Dim searchText As String = txtSalesReport.Text.Trim()

 If String.IsNullOrEmpty(searchText) Then
     DataGridView1.DataSource = Nothing
     Exit Sub
 End If

 For Each row As DataRow In dataTable.Rows
     Dim rowHeader As String = row(0).ToString()

     If rowHeader.Equals(searchText, StringComparison.OrdinalIgnoreCase) Then
         Dim filteredTable As New DataTable()

         For Each column As DataColumn In dataTable.Columns
             filteredTable.Columns.Add(column.ColumnName, column.DataType)
         Next

         filteredTable.Rows.Add(row.ItemArray)

         DataGridView1.DataSource = filteredTable

         Exit Sub
     End If
 Next

 DataGridView1.DataSource = Nothing
0

There are 0 best solutions below