Concatenate

[Mike Moore]

Is there an easy way to concatenate two columns (i.e. last name and first
name columns) in a data set so both can show up in a data text field of a
combo box?

[Mark Rae]

"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:6D**********************************@microsof t.com...

Is there an easy way to concatenate two columns (i.e. last name and first
name columns) in a data set so both can show up in a data text field of a
combo box?

Easiest way is to do it in your SQL statement e.g.

SELECT <...other columns...>, FirstName + ' ' + LastName As FullName,
<...other columns...>
FROM <...table(s)...>
WHERE <...criteria...>

Then bind your combo box to the FullName field

[Mike Moore]

This solves the problem by doing the query a special way, which I already
thought was possible, but more work.

what I wanted was a way to combine two columns *after* a query was performed
by setting the datatextfield property a certain way.

Mike Moore


"Mark Rae" wrote:

"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:6D**********************************@microsof t.com...

Is there an easy way to concatenate two columns (i.e. last name and first
name columns) in a data set so both can show up in a data text field of a
combo box?

Easiest way is to do it in your SQL statement e.g.

SELECT <...other columns...>, FirstName + ' ' + LastName As FullName,
<...other columns...>
FROM <...table(s)...>
WHERE <...criteria...>

Then bind your combo box to the FullName field

[Mark Rae]

"Mike Moore" <Mi*******@discussions.microsoft.com> wrote in message
news:0D**********************************@microsof t.com...

but more work.
Hardly... :-)
what I wanted was a way to combine two columns *after* a query was
performed
by setting the datatextfield property a certain way.

I don't believe so. However, you could abandon the DataSource() and
DataBind() method of populating the dropdown and instead iterate through the
records in the DataSet / DataReader, concatenate the two name fields and
then add them to the dropdown using its Items.Add() method.

However, I think you'll find that is certainly more work...