in vb.net datagrideview filter by Combobox

Viewed 19
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim dt As DataTable
    Dim dv As DataView


    dt = DirectCast(DataGridView1.DataSource, DataTable)
   

    dv = New DataView(dt, "[Game Name]='DERA'", "[Game Name] desc", DataViewRowState.CurrentRows)
    DataGridView1.DataSource = dv
End Sub

this is my code is working , But I need this code filter by combobox1 as like next code

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim dt As DataTable
    Dim dv As DataView


    dt = DirectCast(DataGridView1.DataSource, DataTable)
   

    dv = New DataView(dt, "[Game Name]" = ComboBox2.SelectedItem, "[Game Name] desc", DataViewRowState.CurrentRows)
    DataGridView1.DataSource = dv
End Sub
0 Answers
Related