Does anybody have a tip on how to list more than one field on a DataCombo - specifically, I need to show Lastname, Firstname Middlename which I have as separate database fields.
Printable View
Does anybody have a tip on how to list more than one field on a DataCombo - specifically, I need to show Lastname, Firstname Middlename which I have as separate database fields.
Concatenate your fields into 1, then add them to the list. You might have to do this manually, I don't think the bound listbox/combobox can do this by itself...
Example of concatenation & SQL: http://www.vb-world.net/ubb/Forum3/HTML/002596.html
Are you saying this should be done on the database side, not in code? ie, I need to add another field for the concatenated ones?
I am saying that you probably can't use a bound control, and have to do this in code (unless you make a query/view to do this for you, and bind the control to that query field instead)
That's a good idea - the query/view. Thanks.