combobox multicolumns

[fasttrack]

Hi I have a problem:

I would like to show with a combobox a result of a easy query like:

select col1, col2 from T1.
I would like to use datadapter and dataset to populate the combobox, but I would like show only a column (eg col1) and use the col2 as parameter to be passed to vb.net code.

How can I do ?

I tried with a column (select col1 from T1) and it works, but how to do in the case of more cols selection.....

 

[kulrom]

As comboBox doesn't come in multicolumns mode you should make own with such feature ... take a look at this example or you just google for it i'm pretty sure codeprojects.com will have one

http://www.edneeis.com/control.aspx?ID=7

HTH
Regards

 

[Blokz]

If you only want col1 to be displayed, but want to use col2 for something else when selected, you could store col2 in the .value property.

Blokz