Custom displaymember in comboBox

[Bill Nguyen]

How can I have the comboBox display valuemember in addition to the column
specified in displaymember?
For example, I want to display stationID 1999 (valuemember) and stationName
such as "1999 - Station 1999" .

Any help is greatly appreciated.

Thanks

Bill

 

[Cor Ligthert [MVP]]

Bill,

I never used it, however those who did where very glad with it.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2934&lngWId=10

I hope this help,

Cor

 

[Lucky]

hi Bill,
if you are fetching data from the database then u can do it in
Query itself. try this: "select ValueMember + ' - ' + displayMember as
DisMember,ValueMember from TableX"

 

[Cor Ligthert [MVP]]

Lucky,

No that is not the way, you can add an extra column in the datatable with an
expression, however most don't like that way.

Cor

 

[Lucky]

hi Cor,
of course people wont go that way. do u know how much it costs to add
one column in the DB Table? and whats ths worng in using this Query.
can u tell me the flaws in this Query. coz i've done this in my project
and it is working fine. why not to get most out of the SQL when it is
providing.
i definatly would like to have your views on this dude.

 

[Cor Ligthert [MVP]]

Lucky,

of course people wont go that way. do u know how much it costs to add
one column in the DB Table? and whats ths worng in using this Query.
can u tell me the flaws in this Query. coz i've done this in my project
and it is working fine. why not to get most out of the SQL when it is
providing.
i definatly would like to have your views on this dude.

It cost this statemement

dt.columns.add("MyDisplayValue",Gettype(System.String),"First + Second")

Cor

 

[Bill Nguyen]

I'm using Lucky's tip now since I need to get it done quickly but I would
like to use Cor's later on.
Thank you both!

Bill