DispalyMember property

HI
I need to assign more then one value to DispalyMember property of ComboBox
I want to display â??first_nameâ?? and â??last_nameâ?? fields

As far as I know I can assign only one field to DispalyMemebr
Is there any work around

Thank you
Jerr

Chris
Mon Jan 19 12:48:10 CST 2004

Change your SQL to bring back a concatenated field:

Instead of
SELECT fname, lname FROM ....

use
SELECT fname + ' ' + lname AS name FROM ...

then set DisplayMember to 'name'

--
Chris Tacke, eMVP
Co-Founder and Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net


"Jerry" <anonymous@discussions.microsoft.com> wrote in message
news:D2DFA938-871B-4E1B-B1B2-627BD4848246@microsoft.com...
> HI,
> I need to assign more then one value to DispalyMember property of
ComboBox.
> I want to display "first_name" and "last_name" fields.
>
> As far as I know I can assign only one field to DispalyMemebr.
> Is there any work around?
>
> Thank you,
> Jerry
>

anonymous
Mon Jan 19 14:56:39 CST 2004

Thank you,

It worked,
I also tried (and it worked)

my_dataset.Tables(0).Columns.Add(New DataColumn("full_name"))
my_dataset.Tables(0).Columns("full_name").Expression = "first_name + ' ' + last_name"

Jerry