How do I Get The Selected Value From Database To Radio Button

Question

0.00/5 (No votes)

See more:

I have a small web application but when i retrieve data to edit ,i can retrieve every cell to there textbox but i can't get radio button value

C#

SqlDataReader dr;

dr = comm.ExecuteReader();
if (dr.HasRows == true)
{
    dr.Read();
    RegionNameTextBox.Text = dr["RegionNameEn"].ToString();
    StatusRadioButtonList.Text = dr["RegionStatus"].ToString();
    dr.Close();
    comm.Parameters.Clear();
}

Posted 10-Sep-12 20:01pm

M.Saied

Updated 26-Nov-17 23:13pm

Add a Solution

Comments

prashant patil 4987 11-Sep-12 2:04am

first check your radio value bind to radio button or not.

2 solutions

Solution 1

Looks like you are trying to assign a Radio Button checked or not-checked.

C#

//To set the text of the Radiobutton
StatusRadioButtonList.Text = "Selected value";

//Tot set checked or not
StatusRadioButtonList.Checked = true;

//If you are trying to check and set more than 1 Radio button
//All the radio button should of same group
if (rdoStatusRadioButtonListA.Text.ToString().Equals("One"))
        {
            rdoStatusRadioButtonListA.Checked = true;
        }
else  {
            rdoStatusRadioButtonListA.Checked = false;
            rdoStatusRadioButtonListB.Checked = true;
     }

Let me know if this answer doesn't solve your problem. I will provide in much detail.

Posted 10-Sep-12 20:27pm

Swinkaran

Comments

M.Saied 11-Sep-12 2:42am

i got this error (RadioButtonList' does not contain a definition for 'Checked' )
i have one radio button list with two option (Enable , Disable) and i used this
StatusRadioButtonList.SelectedIndex =Convert.ToInt32(dr["RegionStatus"]) and works fine but its reflect value if it enable i get it in radio button disable and vice but in database its ok

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)

V_R · Accepted Answer · 2012-09-10T20:29:00

If you retrieving the Active or Inactive value from database you can use following code,

C#

if(dr["RegionStatus"].ToString()=="Active")
{
   StatusRadioButtonList.Items[0].Selected=true;
   StatusRadioButtonList.Items[1].Selected=false;
}
else if(dr["RegionStatus"].ToString()=="Inactive")
{
   StatusRadioButtonList.Items[0].Selected=false;
   StatusRadioButtonList.Items[1].Selected=true;
}