C# checkbox code

Hi Carl ,

I hope you still here :)....after the db guy created the new database and tables he added more columns and requested to add them to the app soo i did add these columns to the app and now it look like this see screenshot...

my missed understanding for now is how to add the checkbox to the column closed which provide database as "false or true" I want the checkbox to show me "v" inside the box and instead it shows me the word true or fales.

I have written the code for this checkbox this way:

string scheck = Reader.GetBoolean(Reader.GetOrdinal("closed")).ToString();

Open in new window

checkbox1.Text = scheck;

Open in new window

Capture.JPG

Moti Mashiah

Asked: 2014-04-08

Advertise Here

1 Solution

LVL 27

Shaun KlineLead Software EngineerCommented: 2014-04-08

Instead of setting the text property, set the checked property.

LVL 1

Moti Mashiah.NET DeveloperAuthor Commented: 2014-04-08

that way I will see the "V" always in to the box.

My intention is to see the "V" in the checkbox when the database say true.

LVL 18

Jerry MillerCommented: 2014-04-08

Like Shaun stated, you need to set the checked and not the text.

checkbox1.Checked= scheck; instead of checkbox1.Text = scheck;

LVL 1

Moti Mashiah.NET DeveloperAuthor Commented: 2014-04-08

thanks ,

After I changed I got this issue "cannot implicitly convert type string to bool

LVL 18

Jerry MillerCommented: 2014-04-08

Declare scheck as a Boolean instead of a string.

bool scheck = Reader.GetBoolean(Reader.GetOrdinal("closed"))

LVL 1

Moti Mashiah.NET DeveloperAuthor Commented: 2014-04-08

Thank you very much now it works fine..

I have one more question:

I would like to query just the false from the "Close" Column. I assume I need some if statement for this.

can you help with the code.