how to retrieve radiobutton value from database to radiobutton

Question

0.00/5 (No votes)

See more:

Hii,

how to retrieve radiobutton value from database to radiobutton

example:

Type: 1. General 2. reserve
i hav two radiobuttons as show above.
If type general is stored is database then "General" Radiobutton will check or vice versa.

How to retrieve this..

Thanks in advanced

Posted 19-May-14 2:39am

Member 10794814

Add a Solution

Comments

Thanks7872 19-May-14 8:53am

Have Radiobuttonlist with Values. Store only values in DB. At the time of retrieving it, set list's Selectvalue property to one you got from DB.

If you have Radiobuttons, you should check in code which value you got. Based on that set corresponding button's Checked property to true.
Was that so hard? Try something before posting something.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SRS(The Coder) · Answer 1 · 2014-05-19T03:34:00

Let say you have the radiobuttonlist control as follows :-

XML

<asp:RadioButtonList ID="rbl" runat="server">
            <asp:ListItem Text="General" Value="1"></asp:ListItem>
            <asp:ListItem Text="Reserve" Value="2"></asp:ListItem>
        </asp:RadioButtonList>

Now you can do this in two steps as described below :-

i) Assuming you got the value as '1' from DB which is 'General'.

Then get the ListItem by the value you have as below -

C#

ListItem item = rbl.Items.FindByValue("1");

We can pass the appropriate value which we are getting from database rather than passing the string "1" here. Also if you are getting the text from database like "General" then you can use the method 'FindValueByText' here.

ii) Now in the second step we can set the selected index by setting the selected index of this item in radiolist as below :-

C#

rbl.SelectedIndex = rbl.Items.IndexOf(item);

Hope this will be of help for you.