ASP.NET Drop Down List error with null values in SqlDataSource

Question

I have a drop down list on a form view which are both bound to different data sources.

When trying to run the program I am getting 'ddlFieldName' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value.

I think it is because the field associated with the drop down list contains a null value which isnt in the referencing table. I have tried to work round this by adding an empty item in the list but it doesnt seem to be working:

<asp:DropDownList ID="ddlAgency" runat="server" 
DataSourceID="dsAgency" DataTextField="Agency" 
DataValueField="AgencyID" SelectedValue='<%# Bind("Agency") %>'  >
<asp:ListItem></asp:ListItem></asp:DropDownList>

Can anyone suggest a way round this?

Thanks

anD666

Dan Diplo · Accepted Answer · 2010-01-25 10:44:26Z

2

Try adding AppendDataBoundItems="true" to the DropDownList as one if its properties. See http://weblogs.asp.net/scottgu/archive/2006/01/29/436804.aspx

answered Jan 25, 2010 at 10:44

Dan Diplo

25.4k4 gold badges71 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CodeFirstAndy Over a year ago

I realised I had missed that off just before checking the post. This was the problem. Thank you

Saar · Accepted Answer · 2010-01-25 10:45:44Z

0

One workaround could be.

Try to assign Selected value in code behind. There you can check for null value easily.

answered Jan 25, 2010 at 10:45

Saar

8,5225 gold badges33 silver badges33 bronze badges

Collectives™ on Stack Overflow

ASP.NET Drop Down List error with null values in SqlDataSource

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related