how do you bind dropdownlist with in edit mode with item is not in the list

Posted on 2009-05-07
Medium Priority
Last Modified: 2013-11-08
expert: I have a asp .net C# web INSERT and EDIT Mode FormView with a dropdownlist with "make a selection" as one of the choices. The DDL is loaded from a db table list which does not include "make a selection". When user does not make a selection a NULL is inserted into the db record . However when I bring the record up and click the edit link I get error "SelectedValue which is invalid because it does not exist in the list of items". I am not sure how to fix this issue?  My code is below:
<asp:DropDownList ID="MYDdl" runat="server" AppendDataBoundItems="True"
                                        DataSourceID="MYTypeDataSource" DataTextField="car_type"    
                                        SelectedValue='<%# Bind("car_type") %>' Width="200px">
                                        <asp:ListItem Value="-1">--make a selection --</asp:ListItem>
                  // C# code behind
                   if (MYDdl.SelectedValue == "-1")
                        e.Values["car_type"] = null;

Open in new window

Question by:tcmmaxt
  • 2
LVL 15

Expert Comment

ID: 24329154
What do you want to do -> handle the case where you get a null value from the database? Or, prevent inserting a null value in to the database?

Author Comment

ID: 24329243
expert: What do you want to do -> handle the case where you get a null value from the database
Yes -->handle the case where you get a null value from the database
LVL 15

Accepted Solution

mohan_sekar earned 2000 total points
ID: 24329305
Ok, you got to do two things.
Set 'AppendDataBoundItems' to True for the Dropdown list. In Page_Load, add the following line
dropdownlist.items.add("Please make a selection");

Step 2: when you get a null value from the database, select the 1st item
dropdownlist.selectedindex = 0;

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question