Database one column to ListBox?

[lolcocks]

Hi,

From my database I have managed to fire a query so select just one column of the name of the details I want.
It shows up fine in the data grid but I want to use ListBox instead of DataGrid.

How can I achieve this?


Here is my code:



This is the result:




Please let me know what I can do.

[kebo]

Start by posting code as text wrapped in code tags...

You need to set the DisplayMember of the list box to the data table column name.

ListBox1.DisplayMember="CName"

I can't remember whether the DisplayMember should be set before or after the data source is set, but I do believe it matters.

[techgnome]

DisplayMember and ValueMember both need to be set BEFORE the DataSource ... Doesn't matter which order Display/Value member gets set, they just need to be set before the datasource.

-tg

[lolcocks]

Start by posting code as text wrapped in code tags...

You need to set the DisplayMember of the list box to the data table column name.

ListBox1.DisplayMember="CName"

I can't remember whether the DisplayMember should be set before or after the data source is set, but I do believe it matters.

DisplayMember and ValueMember both need to be set BEFORE the DataSource ... Doesn't matter which order Display/Value member gets set, they just need to be set before the datasource.

-tg

Thanks guys, that worked! Thank you so much! +rep.