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
"Angela" <an****@kaisen.co.uk> wrote in message
news:6f**************************@posting.google.c om...
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