ComboMombo :: Adding a Data Member to a combobox

[grantc2]

I have a ComboBox that I need to fill with customerLastName and customerFirstName. ( I need to add a comma too) It should look like this:

Doe, John

After I set the ComboBox's source and the DataMember, it works, but how can I add a second Data Member (customerFName) and the comma?? Also, should I code it or use Visual Studio in Designer Mode.

[Edneeis]

You don't, you have to concat the two fields in your query and use that as the DisplayMember.

"SELECT *,CustomerLastName + ', ' + CustomerFirstName AS CustomerFullName FROM Customers"

Then bind the DisplayMember to CustomerFullName

[grantc2]

Thanks