[RESOLVED] [2005] Datatable as DataSource

[Chathura]

Hi All,
I have a data table which has 4 columns. I want to display 1 column and other columns should be invisible. I want to display this column value in a combo box and I've set its properties as follows.

cbo.datasource=dt
cbo.displaymember= dt.columns(1).Tostring
cbo.ValueMember= dt.columns(0).Tostring

Is there any way to add the other columns to a collection, hashtable or something directly. (I.e. not one by one, just setting the datasource)


Any idea will be highly appreciated.
Thanks

[jmcilhinney]

When the user makes a selection the Selecteditem will return a DataRowView. You can simply index that object to get the other column values, e.g.

Dim val As Object = DirectCast(myComboBox.SelectedItem, DataRowView)("ColumnName")

[Chathura]

Great!!!!
Mr. John

Thank you very much.

It's working perfectly