Hi there

In my database i have a table person. With the following fields.
Name
surname
gender
telephone

Now i want to look up the person table from a combobox. But i can only select one of the field. How can i create a field in my dataset that joins name and surname so i can lookup the full name in my combobox. In delphi this was a calculated field but how do i do this in C#.

I've ran into the same problem, but they helped me in this forum, so I think it's time to pass the note.

- Create a table in a dataset using the xsd from VS.
- Add a new column and insert the expression "= name + surname"

with that you'll be ready to populate your combobox and set the new column as its display member.

good luck!


MAKO - "El super simio"

Hi there MAKO thanks for your reply
column expresion:NAME+(', ')+SURNAME

Yes MacDevv, you can do just as easy as open your xsd (dataset designer) where the tables are displayed and simply add a new column at the end of your persons table named fullname, or something, and add the expression [name + sourname] in the column properties.

"Hacia la victoria siempre!"

msn = [email protected]

MAKO - "El super simio"