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