asp.net dropdownlist selected value if the value does not exist

Question

I have a control that holds a dropdownlist that holds variables (A, B, C, N/A). The variables are pulled from a class. When an item is submitted, in the database it will store the letter and an identifier. If the database entry with the identifier exists, this code runs fine, if the database does not hold an identifier for the entry (it does not exist yet) then I get an error.

Code:

 <EditItemTemplate>
                            <asp:DropDownList runat="server" 
                                ID="ddlQualityTypes" 
                                DataSource='<%# CodeLists.QualityTypes() %>'
                                DataTextField="strCode" 
                                DataValueField="strCode" 
                                SelectedValue='<%#Eval("strQualityCode")
    == null ? "A" : Eval("strQualityCode") %>'
                                />
                        </EditItemTemplate>

Any ideas on how to get around this?

EDIT: strQualityCode is the name of the variable that is databound to the object holding which letter corresponds to the item.

What should happen when the database does not hold an identifier for the entry? — James Johnson
– James Johnson, Commented Sep 8, 2011 at 19:56

James Johnson · Accepted Answer · 2011-09-08 19:55:12Z

1

I would make the field nullable in the database, and make it an optional parameter in your stored procedure. If the value of the dropdown is null or empty, don't pass the parameter to the stored procedure.

answered Sep 8, 2011 at 19:55

James Johnson

46.1k8 gold badges75 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

asp.net dropdownlist selected value if the value does not exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related