How to retrieve radio button value from database using C#

Question

I have a group box contains radio buttons eg.

o Level 1

o Level 2

How can I load value from database and check radio botton on my GUI?

private void button_clone_Click(object sender, EventArgs e)
{
    try
    {
        connection.Open();
        OleDbCommand command = new OleDbCommand();
        command.Connection = connection;
        command.CommandText = "SELECT * from PPAPdatabase where [PSW ID]=" + txt_c_PSW_ID.Text + "";
        OleDbDataReader dr = null;
        dr = command.ExecuteReader();                
        while (dr.Read())
        {
            comboBox_PPAP.Text = (dr["Reason"].ToString());
            checkedListBox_prodline.Text = (dr["Production Line"].ToString());                    
            checkedListBox_owner.Text = (dr["Owner"].ToString());              
            txt_comment.Text = (dr["Comment"].ToString());                                                          
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show("An error has occurred: " + ex.Message,
                "Important Note",
                MessageBoxButtons.OK,
                MessageBoxIcon.Error,
                MessageBoxDefaultButton.Button1);
    }
    finally
    {
        connection.Close();
    }

Thanks in advance!

What kind of data is it that you are trying to bind the radio button with? Is it a bit, string, integer column? — Dr Schizo
– Dr Schizo, Commented Jun 20, 2016 at 20:45
@DrSchizo I have a column named PPAP level, and I just save the text of the levels in that colum. — NOGRP90
– NOGRP90, Commented Jun 20, 2016 at 21:51
Can you post how the data looks like? Do you want the radio checked if the column has anything in it, i.e. is NOT an empty string? — Dr Schizo
– Dr Schizo, Commented Jun 20, 2016 at 22:16

Dr Schizo · Accepted Answer · 2016-06-20 22:22:18Z

1

Assuming your radio button is called radioButton1 and the column your referring to stores values as either 1 or 0 then you would do:

radioButton1.Checked = row["PPAP"].ToString() == "1";

edited Jun 20, 2016 at 22:22

answered Jun 20, 2016 at 20:17

Dr Schizo

4,4887 gold badges47 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to retrieve radio button value from database using C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related