CODEWITHSUNDEEP
winformsdatagridviewvb.net-2010datagridviewcombobox
roy
roy

Reputation: 729

How to filter datagridview with combobbox without query and with invisible column in vb.net

How to filter datagridview with combobbox without query and with invisible column in vb.net? and is it possible to be only distinct or unique value? I want filter in "SHI" column. Note : I use visual studio 2010 Thanks roy

Private Sub DataGridView()

        Try
            dt = New DataTable
            Dim query = "select ITM,ITC,QOH,PRS,PRSOBBRT,PRSOBNET,SHI,FILENAME1,FILENAME2,FILENAME3,FILENAME4,FILENAME5,FILENAME6 FROM IFG WHERE QOH > 0"
Using con As OleDbConnection = New OleDbConnection(cn)
                Using cmd As OleDbCommand = New OleDbCommand(query, con)
 Using adapter As New OleDbDataAdapter(cmd)
                        adapter.Fill(dt)
                        Me.DataGridView1.DataSource = dt

                    End Using
                End Using
            End Using
For x As Integer = 7 To 12
                Me.DataGridView1.Columns(x).Visible = False
            Next
Catch myerror As OleDbException
            MessageBox.Show("Error: " & myerror.Message)
        Finally
            'cn.Dispose()
        End Try
    End Sub

Upvotes: 0

Views: 298

Answers (0)

Related Questions