Microsoft, Asp.Net, 2.0 - asp:FormView | EditItemTemplate | asp:radiobuttonlist

Dear Experts,
I have using an asp:FormView to capture data from end users.  Within this form I want the user to be able to edit a response if a mistake is made using 3 different asp:ListItems.  My problem is that when the user clicks on the form's edit button the edit portion of the asp:FormView does not capture the result that has already been stored in SQL Server.  So to the user, it looks like nothing was ever chosen.

How can I get the asp:RadioButtonList  to properly display the "selected" option that is stored in the database?  I'm new at codebehind and VB Scripting, so any example would be greatly appreciated.  I've read a lot about databinding options, but I don;t seem to grasp how to properly do it.

I am using a stored procedure to select all the necessary fields for the form.  This particular asp:RadioButtonList will be used for 15 different questions, each using the same 3 response options.  I should also mention that the field in the database is storing String values and not Boleen values.

Here's my code snippet:


<asp:RadioButtonList ID="Sect1Fld1Opt1" runat="server" RepeatDirection="Horizontal">
         <asp:ListItem Text="N/A" Value="N/A" />
         <asp:ListItem Text="Complies" Value="Complies" />
         <asp:ListItem Text="Repairs Needed" Value="Repairs Needed" />

Who is Participating?
crazymanConnect With a Mentor Commented:
Try adding this to the RadioButtonList

SelectedValue = '<%# Eval("YourFieldWithSelectedValueIn")%>'
BeallcorpAuthor Commented:
Excellent!  Thank you crazyman! I can't tell you how long I've been staring at this bugger.
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.

All Courses

From novice to tech pro — start learning today.