Problem inserting value from Check Box

vivekshah · June 5th, 2006, 02:46 AM

Hi ALL

I have a SQL Server table customer which has fields regarding details of customer.
I added one column IsCorporate of data type bit with Default(0).

Now on the form that gets all details of customer there i have an checkbox
"Is Coprorate".

I tried the following way to insert in the query.

Code:

insert into customer (IsCorporate) VAlues (+((chkCorporate.Checked==true)?1:0)+);

on executing this Query there is no response from the server.

What could be the problem?

Vivek Shah

MAKO · June 6th, 2006, 02:15 PM

The problem, I think, is that you're using a ternary operator to check for your checkbox value. The ternary operator is used for assingment to variables depending on certain condition. To use the ternary in your code, you should change it to:

Code:

bit check;
check = (chkCorporate.Checked)? 1:0;
insert into customer (IsCorporate) VAlues (check);

MAKO - "El super simio"

MAKO · June 6th, 2006, 02:32 PM

Sorry, that code should have read like this:

Code:

bit check;
check = (chkCorporate.Checked)? 1:0;
"insert into customer (IsCorporate) VAlues (" + check + ");";

MAKO - "El super simio"

vivekshah · June 8th, 2006, 08:17 AM

thanks this works efficiently

Vivek Shah