Rowfilter error in DataView (Syntax Error: Missing Operand after 'ProductName' Operator

Dear all,

I'm using following code to filter data in listbox. But error msg Syntax Error: Missing Operand after 'ProductName' Operator appears. Can any one figure out the Syntax error please.

Private Sub FilterProductId()

Try

Dim ProductIDs As TechManagement.DBComponents.ProductDB = New TechManagement.DBComponents.ProductDB

Dim filterview As DataView = New DataView(ProductIDs.GetProductIDS)

Catch ex As Exception

MessageBox.Show(ex.Message, Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation)

End Try

End Sub

Thanks

cybertaz69 Thanks for your reply.

But it does not work. I changed the code as below after filtering, it gives strange data in the listbox "System.Data.DataRowView"

Here something Error I can' short out.

Thank you verymuch cybertaz69

But I have 2 columns. I know it is impossible to put 2 columns as DisplayMember. So what is the solution

Thanks for giving your valuable time