• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2194
  • Last Modified:

Get selected value from database to default on dropdown box

Hi have a dropdown box which needs to display either 0, 3 or 9 depending on what is selected in the database. I have it saving ok when someone submits the form, but when it reloads the form up, it doesnt default to the last selection, which i need it to do. The only problem is, its in a datagrid, so there are lots of these dropdown boxes.
Here is my code:-

<asp:TemplateColumn HeaderText="Score">
<asp:DropDownList id="Score" runat="server"  selectedindex='<%# DataBinder.Eval(Container.DataItem, "score") %>'>
<asp:ListItem Value="0">0</asp:ListItem>
<asp:ListItem Value="3">3</asp:ListItem>
<asp:ListItem Value="9">9</asp:ListItem>

the program runs a stored procedure which gets the value for score, but comes up with the error
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: value
pointing to :-
<asp:DropDownList id="Score" runat="server"  selectedindex='<%# DataBinder.Eval(Container.DataItem, "score") %>'>
Line 20:                                     <asp:ListItem Value="0">0</asp:ListItem>
Line 21:                                     <asp:ListItem Value="3">3</asp:ListItem>

any help appreciated!

1 Solution
add this attribute to the dropdownlist:

Text='<%# Bind("field name goes here") %>'
Bob LearnedCommented:
It sounds like you aren't checking for Page.IsPostBack before loading data into the DropDownList.

make sure there is item in list corresponding to value you are getting from db, might be null is getting returned or so.

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now