Display SQL information on C# RadioButtons

Question

My C# program is connected to my SQL CE Database. I use a SQLCEDATAREADER to fill some of the textboxes in my program. I have a "Gender" column in my database and a radiobutton with Male and Female. If a certain entry in my database has "M" in the gender column, how can I make the Male radio button appear pressed?

I tried

if(dr["Gender"].ToString = "M")
{
    rbMale = true
}

That obviously didnt work.

What do you mean by _didn't work_? You get any exception or error message? `=` is an assingment operator, if you wanna compare your strings, you need to use `==` instead. Since `ToString` is a method, you need to use it as `ToString()`. And `rbMale = true` needs to `;` at the end of the line. — Soner Gönül, Mar 02 '15 at 08:51
Right syntax should be `if(dr["Gender"].ToString() == "M") { rbMale = true; }` but we _still_ need more information about your problem. — Soner Gönül, Mar 02 '15 at 08:55
Well it says "Cannot implicitly convert type 'bool' to 'System.Windows.Forms.RadioButton" — Dave Howson, Mar 02 '15 at 08:58
Looks like `rbMale` is `RadioButton`, it is too normal to get this error. Look it's `Checked` property. You can get and set this property if your condition returns `true`. — Soner Gönül, Mar 02 '15 at 09:03

score 1 · Accepted Answer · edited Mar 02 '15 at 11:45

1

if(dr["Gender"].ToString() = "M")
    rbMale.Checked = true
else
    rbFemale.Checked = true

edited Mar 02 '15 at 11:45

JoeBilly

3,057
29
35

answered Mar 02 '15 at 09:14

Vynhoû Tawa

68
1
14

What if `dr["Gender"]` is null ? ;) – JoeBilly Mar 02 '15 at 11:44
if (!string.isNullOrEmpty(dr["Gender"].ToString())) :o – Vynhoû Tawa Mar 06 '15 at 11:11
`if (Convert.ToString(dr["Gender"]) == "M")` – JoeBilly Mar 09 '15 at 08:58

jammy · Answer 2 · 2015-03-02T10:32:00.910

1

Perhaps collapse to one line -

rbMale.Checked = (Convert.ToString(dr["Gender"])=="M");

edited Mar 02 '15 at 10:32

answered Mar 02 '15 at 09:20

jammy

31
3

This answer is definitly better. : one line boolean affectation, cannot throw a NullReferenceException (`dr["Gender"]` null). The external `()` are not necessary though, it makes the code less readable. Less is more ;) One point though, if the asker don't want to change the state of the box if `false` : this code do it. – JoeBilly Mar 02 '15 at 11:38

score 0 · Answer 3 · answered Mar 02 '15 at 09:02

0

If rbMale is the name of your radio button control, you can mark it checked by setting its Checked property to true.

rbMale.Checked = true;

answered Mar 02 '15 at 09:02

bittusarkar

6,247
3
30
50

Display SQL information on C# RadioButtons

3 Answers3