Display member with Table Select Option

Hello All,

I have a DataSet CategoySect with Multiple Tables. I am selecting one table with data as below.

Name          Type
Test            ICD
Test2           ICD
Test3           ICD2
Test4           ICD2

Code Snippet I Use is

categorycombo.DataSource=CategorySect.Tables(0).Select("Type = 'ICD'")
categorycombo.DisplayMember = "Name"
categorycombo.ValueMember = "Name"

When i use this as datasource for combobox with Select option i get a message as

Cannot bind to the new display member. Parameter name: newDisplayMember

If I use without Table.select it works fine. but i want to load data into combo box based on specific type. Can some one guide me as to how to make this work?

Thanks in advance for Any/All Help.

AVK

Tags: Visual Basic, .NET (.NET 3.5)