Quote Originally Posted by Hack
Concantanate them using the & character.
you can't use the & concat method in c#. you have to use +
You really should be concating them at the database anyway...less load on your app . like this:
Code:
SELECT field1 + ' ' + field2 AS BothFields FROM TABLE
then, when you bind (i'm assuming you're binding), bind to 'BothFields'