Display 2 Columns from a datasource in a DropDownList

[news-server.maine.rr.com]

Hi,

Is it possible to DISPLAY 2 columns somehow in a dropdownlist?

For example:

DataField Value = bound to ProductId

DataField Display = Product Name and Product Number

Thanks for any tips.

Frank

 

[bruce barker]

other than using a fixedwidth font and spaces, no. you can build your
own dropdown in javascript.

-- bruce (sqlwork.com)

 

[Patrick.O.Ige]

Frank if inunderstand you do you want to have for example
"FirstName, Lastname" displayed in the dropdowen menu?
Patrick

 

[Frank]

For anyone else, my solution was to use an ObjectDataSource that pointed to
a custom class and method which does the database access, then returns a
collection of ListItems to be used by the DropDownList.

While pulling the fields from the SqlDataReader, I built ListItems and set
the ListItem.Text = sqlDataReader["field1"].ToString() + " " +
sqlDataReader["field2"].ToString();

Then I set the value:

myListItem.Value = "RowID";

Then add each ListItem to an ListItemCollection, and return that Collection
to the ObjectDataSource.

Works like a charm.

Frank