|
Subject:
|
Combining Two DataTextField's for a DropDownBox
|
|
Posted By:
|
testsubject
|
Post Date:
|
1/3/2006 6:54:01 AM
|
Hi folks,
I know this is a really simple question but how do you combine two DataTextField's into one??
Exmaple:
Say I have a drop down box and in there the Text Value is "Joe Bloggs"), but in my data reader is pulls back two fields FirstName and SurName.
In the DataTextField property of the DropDownBox how do I set the property to use two fields??
Thanks
|
|
Reply By:
|
planoie
|
Reply Date:
|
1/3/2006 11:32:47 AM
|
What about writing a query that returns what you want:
SELECT FirstName+' '+SurName AS FirstSurName FROM table...
Then set the DataTextField to "FirstSurName"
-Peter
|
