I'm going crazy. I want to have a drop-down show all the names in a table, plus the first item should be "Add New". If the user selects the first item, the code-behind file redirects the user to a page that allows them to add the new entry. I was sure I saw how to do this in asp.net 4, but now I can't find it anywhere. What I remember was using a union something like this:

SELECT 0 AS ID, 'Add New' AS Name UNION it.ID, it.Name

I can't get this to work any way, and I can't find it on the web.

Can you help?

Hi there,

Can't you just add the "null" item to the markup and set AppendDataBoundItems to true on the control?

http://imar.spaanjaars.com/281/how-d...trol-in-aspnet

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

That works. Thanks!