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" />