Checkbox into/out of MS SQL as what value?

[hari]

I am trying to enter the results of a checkbox into an MS SQL table.The
checkbox returns a bool value that I want to place in the database as a bit.
Or is there a better method? I need to read those bits back into the
checkboxes when the database is queried.

Thanks for any help on this.
Harry

[Anders Norås]

A bit has two possible values on / off. A boolean has two possible values
true / false.
I think you've found the perfect datatype for storing your value!

Anders Norås
blog: http://dotnetjunkies.com/weblog/anoras

"hari" <mackeyha2athotmaildotcom> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

I am trying to enter the results of a checkbox into an MS SQL table.The
checkbox returns a bool value that I want to place in the database as a
bit. Or is there a better method? I need to read those bits back into the
checkboxes when the database is queried.

Thanks for any help on this.
Harry

[Tampa .NET Koder]

Read the bit value from the database and cast it into a bool. Then set the
checkbox value property to that bool value

"hari" wrote:

I am trying to enter the results of a checkbox into an MS SQL table.The
checkbox returns a bool value that I want to place in the database as a bit.
Or is there a better method? I need to read those bits back into the
checkboxes when the database is queried.

Thanks for any help on this.
Harry

[Hermit Dave]

IMHO bit is the best way to store boolean value in SQL Server.

in most cases you should be alright.... if you face any problems just use
explicit cast and you should be fine.

--

Regards,

Hermit Dave (D'way)
http://hdave.blogspot.com
"hari" <mackeyha2athotmaildotcom> wrote in message
news:#4**************@TK2MSFTNGP12.phx.gbl...

I am trying to enter the results of a checkbox into an MS SQL table.The
checkbox returns a bool value that I want to place in the database as a bit. Or is there a better method? I need to read those bits back into the
checkboxes when the database is queried.

Thanks for any help on this.
Harry

[Kevin Spencer]

> checkbox value property to that bool value

That would be the ckeckbox's "checked" attribute.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Tampa .NET Koder" <Ta***********@discussions.microsoft.com> wrote in
message news:7E**********************************@microsof t.com...

Read the bit value from the database and cast it into a bool. Then set the
checkbox value property to that bool value

"hari" wrote:

I am trying to enter the results of a checkbox into an MS SQL table.The
checkbox returns a bool value that I want to place in the database as a bit. Or is there a better method? I need to read those bits back into the
checkboxes when the database is queried.

Thanks for any help on this.
Harry