Store checkbox to Database Yes/No Field

[garak76]

Hi,

I receive an error when I try to store a checkbox value
to my MS-SQL Database Yes/No Field.
I assign the field with the following code:

row["INT_Height"] = txtHeight.Text;
row["BOL_Jump"] = chkJump.Checked;
...
dataAdapter.Update(ds, "tbl_Root_Characters"

I get the error:
ERROR: Syntaxerror converting varchar value 'True' to a row of type bit

can anybody help
thx
Frank

 

[wsmall73]

It's literally trying to save 'TRUE' to a bit field 1 or 0. You will need to convert it to either a 1 or 0 before your update.

 

[garak76]

I also tried this:

row["BOL_Jump"] = 1;

But my try.. catch... block gets the same error
and data is not stored.

[...]
row["BOL_Jump"] = 1;
row.EndEdit();

try
{
dataAdapter.Update(ds, "tbl_Root_Characters"
ds.AcceptChanges();
}
catch( Exception ex )
{
System.Console.WriteLine( "READING:" );
System.Console.WriteLine( " ERROR:" + ex.Message );
} }

 

[obislavu]

wsmall73 is right.
Here is an example that is working 100%!
In MS - SQL there is no Yes/No data type. The type should be bit and the values are 1 or 0.
When you load the source database into a DataSet object a Yes/No source field is stored in a field of a DataTable object as DataType of System.Boolean and you should check it like here:
DataRow drFound = ...;
if drFound["myCheckColumn"].ToString().ToLower()== "true&quot
{
// get from database 1
}
else
// get from databse 0

If you want to alter the the myckeckcolumn you have to say:
drFound["mycheckColumn"]= 1;
or
drFound["mychcekColumn"] = 0;

Now you can call :
myDataAdapter.Update(ds, "myTable"
ds.Tables["myTable"].AcceptChanges(); // "myCheckColumn" is part of the "myTable"

-obislavu-