2 field Values within DropDownList.DataValueField

rit01 · January 27th, 2006, 12:40 PM

Hi All

Not sure whether it is possible but is there any way to include 2 database fields within the same DropDownList.DataValueField field directly within the control:

Code:

<asp:DropDownList ID="DropDownList1" runat="server" 
DataSourceID="SqlDBSrc" DataTextField="NAME" DataValueField="FIELD1 + 
FIELD2" SelectedValue='<%# Bind("FIELD1ID") %>'>

If not what syntax would you recommend to achieve this?

As always your advice is much appreciated

Rit

Rit
www.designandonline.co.uk

Imar · January 27th, 2006, 01:03 PM

Hi Rit,

Unfortunately, you can't.

However, it's pretty easy to combine the columns in your select statement, alias them and then use that alias.

E.g.:

SELECT Field1 + Field2 AS NewColumn FROM Bla bla bla

And then use NewColumn for the DataValueFIeld:

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDBSrc" DataTextField="NAME" DataValueField="NewColumn" SelectedValue='<%# Bind("FIELD1ID") %>'>

If you post code in this forum, can you please add a line break here and there? Makes the page much easier to read and type replies in...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

rit01 · January 27th, 2006, 01:25 PM

Imar, you are a star buddy!

And many thanks for the line break tip ;)

Rit

Rit
www.designandonline.co.uk

Naveed Alam · October 19th, 2015, 10:55 AM

Sir can you please paste the code in code behind in asp.net c#

May 11th, 2016, 03:22 AM

Thanks for ideas and solution, that my work i hope in future