how can you get 2 datafields displayed in a combo box?

How can you get 2 datafields displayed in a combo box, and still return just
one of the fields?

I need to return a company name in order to help users visually determine
who a rep works for, but need only the repcode to pass on to another
variable.

SC

[Martin Dechev]

Set the DataTextField and the DataValueField properties of the DropDownList
control to the column names of the corresponding columns. If you have the
MSDN Library installed there are examples in the topics for these
properties.

Hope this helps
Martin
<[e-mail] > wrote in message
news:u5******** *****@tk2msftng p13.phx.gbl...

How can you get 2 datafields displayed in a combo box, and still return just one of the fields?

I need to return a company name in order to help users visually determine
who a rep works for, but need only the repcode to pass on to another
variable.

SC

Martin - thanks for the response -

A follow-up question -

If I am in my select statement formatting the first of the 2 fields, for
example:

select
'(' + company + ')' as company1,
salesrepname as Salesrepname

would I need to put in the field only (company), or the result of the AS
(company1) or would it be the string formatted '('+company+')' ?

Thanks,

SC

"Martin Dechev" <de*******@hotm ail.com> wrote in message
news:eh******** ******@TK2MSFTN GP10.phx.gbl...

Set the DataTextField and the DataValueField properties of the DropDownList control to the column names of the corresponding columns. If you have the
MSDN Library installed there are examples in the topics for these
properties.

Hope this helps
Martin
<[e-mail] > wrote in message
news:u5******** *****@tk2msftng p13.phx.gbl...

How can you get 2 datafields displayed in a combo box, and still return

just

one of the fields?

I need to return a company name in order to help users visually determine who a rep works for, but need only the repcode to pass on to another
variable.

SC

[Martin Dechev]

The column name will be what you specify with the AS clause, in your example
the table in the dataset should have columns with names "company1" and
"Salesrepna me". The same if it is DataReader.

Hope this helps
Martin
<[e-mail] > wrote in message
news:ut******** ******@TK2MSFTN GP12.phx.gbl...

Martin - thanks for the response -

A follow-up question -

If I am in my select statement formatting the first of the 2 fields, for
example:

select
'(' + company + ')' as company1,
salesrepname as Salesrepname

would I need to put in the field only (company), or the result of the AS
(company1) or would it be the string formatted '('+company+')' ?

Thanks,

SC

"Martin Dechev" <de*******@hotm ail.com> wrote in message
news:eh******** ******@TK2MSFTN GP10.phx.gbl...

Set the DataTextField and the DataValueField properties of the

DropDownList

control to the column names of the corresponding columns. If you have the

MSDN Library installed there are examples in the topics for these
properties.

Hope this helps
Martin
<[e-mail] > wrote in message
news:u5******** *****@tk2msftng p13.phx.gbl...

How can you get 2 datafields displayed in a combo box, and still

return just

one of the fields?

I need to return a company name in order to help users visually

determine who a rep works for, but need only the repcode to pass on to another
variable.

SC