How do I Concatinate two fields using databinding in Win Forms?

[Craig]

I have a data adapter that I created in a Win forms application. I used
the "data adapter configuration wizard" to create the stored procedures in
the database (SQL server 7). I can bind the data to a combo box and it
works fine when I'm displaying only one field.

What I need to do is display two fields concatinated together, e.g. ID + '
' + Title.

Can this be acheived without having to requery the data?

I did try to put an extra field on the end of the query which was the two
fields joined together, but the wizard kept failing to create the update
and delete stored procedures. Presumably because of the extra field.

Thanks,
Craig

 

[William Ryan]

You can use an Expression column
http://www.ondotnet.com/pub/a/dotnet/2003/05/26/datacolumn_expressions.html

 

[Craig]

http://www.ondotnet.com/pub/a/dotnet/2003/05/26/datacolumn_expressions.
html

That looks like exactly what I'm after.

Thank a lot.

Craig