How do I...Make A Boolean Be Represented As 'yes / No' Instead Of True/False with Checkbox?

Question

0.00/5 (No votes)

See more:

I have a checkbox in my project to save invoice status (Yes-No)

VB

If ch1.Checked = True Then cmd.Parameters.AddWithValue("@cancelled", "Yes") Else cmd.Parameters.AddWithValue("@cancelled", "No")

Saving and displaying is working normally, but when I try to read the column with datareader as the following

<pre lang="vb">
ch1.Checked = dr!cancelled
<pre lang="vb">

it gives me error

[FormatException: Input string was not in a correct format.]

[InvalidCastException: Conversion from string "No" to type 'Boolean' is not valid.]

Posted 2-Sep-14 16:20pm

Dena2013

Add a Solution

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)

debashishPaul · Answer 1 · 2014-09-02T16:53:00

Like the Exception message suggests, you are trying to perform an invalid casting.

In my opinion, in database, the status should save the boolean values which can be formatted as "Yes" or "No" according to the needs.

If you want to keep everything else as is, you have to check the value of cancelled and assign the respective boolean value to ch1.Checked. Something like this:

C#

ch1.Checked = dr!cancelled == "Yes"; //Returns true if "Yes", false otherwise.

This is just an example. You can use Methods from the System.String to compare the values and obviously, make the string to either Upper or to Lower case and then perform the comparison.