How to give a comboBox's DisplayMember 2 or more columns?

[Jackfan]

Hi:
How to give a comboBox's DisplayMember 2 or more columns?
Like:
comboBox.DisplayMember = "CustomerId" + "CustomerName";
comboBox.ValueMember = "CustomerId";

[Shardool Karnik]

Use a DataView and combine the two as IdName in the sql select statement .... there is no other way that i know of ....

> Hi:
> How to give a comboBox's DisplayMember 2 or more columns?
> Like:
> comboBox.DisplayMember = "CustomerId" + "CustomerName";
> comboBox.ValueMember = "CustomerId";

[Rohit]

Sorry to post a question on question but what if I want more than 1 value member.. Like in my case, I have 3 columns that form a composite key of a colimn.. So I want all 3 to be value member for a column of another column.. How do I achieve that?