Filter my Datatable through combobox

[Lee21]

guyz help me. I want to filter the data that's being displayed to my datagrid once I click the combobox and select a specific value,the selected value will be the item to filter the data that I needed to be displayed in the datagrid.. I'm using a datatable,a combobox and a datagrid..here's my code

------------------------------------------------------------------------
Private Sub cboView_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboView.Click

        dt = New DataTable
        sda = New SqlDataAdapter("SELECT DISTINCT KPIPOSTCODE FROM KKPIGROUP", sqlcon)
        sda.Fill(dt)

        If dt.Rows.Count <> 0 Then

            cboView.DataSource = dt
            cboView.DisplayMember = dt.Columns(0).ColumnName
            Call ref()

        Else
        End If

    End Sub
'''here is function ref
------------------------------------------------------------------------------------
Public Sub ref()

        dt = New DataTable
        sda = New SqlDataAdapter("SELECT * FROM KKPIGROUP where KPIPOSTCODE = '" & cboView.text & "' ", sqlcon)
        sda.Fill(dt)
        If dt.Rows.Count = 0 Then
        Else
            dg.DataSource = dt
            dg.Enabled = True
        End If

    End Sub

I hope you help me..

[kvprajapati]

>Filter my Datatable through combobox

Call ref() method in the handler of SelectedIndexChanged event of ComboBox.

[Lee21]

Private Sub cboView_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboView.SelectedIndexChanged
         Call ref()
    End Sub

I've tried what you've said but there is something wrong happened. The item in the combobox were not the same.. Please see attached screenshot..