Filtrar DataGridView

[Aquaventus]

Hola ci2000 para hacer filtros a nivel de datagridview puedes usar DataView :

Código vb:

Public Class frmBuscar
 
    Dim vista As New DataView
 
    Private Sub frmTablas_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim Tabla As New DataTable
        Dim Adaptador As New MySqlDataAdapter("SELECT * FROM calles ORDER BY calle", Conexion)
 
        Adaptador.Fill(Tabla)
        vista.Table = Tabla
        dgvTablas.DataSource = Tabla
 
        dgvTablas.Columns.Item(0).Width = 50
        dgvTablas.Columns.Item(1).Width = 50
        dgvTablas.Columns.Item(2).Width = 290
        'seleccioanr fila completa al hacer clic en un registro
        dgvTablas.SelectionMode = DataGridViewSelectionMode.FullRowSelect
 
        Tabla = Nothing
        Adaptador = Nothing
    End Sub
 
    Private Sub btnSalir_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSalir.Click
        Me.Close()
    End Sub
 
    Private Sub btnBuscar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBuscar.Click
        Dim filtro As String = String.Empty
        filtro = "calle LIKE '%alm%'"
        vista.RowFilter = filtro
        vista.Sort = "calle"
        dgvTablas.DataSource = vista
        dgvTablas.Update()
    End Sub
End Class
 

Saludos!.