Binding two data columns to DataTextField

[Angela]

Hi everyone,

Is it possible to bind the DataTextField property to two values from a
database.

I would like the text from column("book") and the text from
column("code") to appear in the DataTextField of a dropdown.

If this is not possible is there are work around?


Thanks


Angela

 

[Ben]

I'm sure there are many approaches to this, but I would do it inside
OnItemDataBind. Create a datarowview, and process information as necessary.

 

[David Wier]

You can accomplish this easily by creating the item displayed in your SQL
statement:
Select book + ' ' + code as BookCode from (YourTableName)
Then, use 'BookCode' as your DataTextField

David Wier
MCP, MVP ASP.NET, ASPInsider
http://aspnet101.com
http://aspexpress.com