Hello
I am using SQL Server to store Data. When I want to store Boolean values in SQL Server with ASP.NET what is the DataType equivalent to this in SQL. In other words what is the easiest way to store Boolean in SQL without hassles of changing datatype. Can I use Bit????

I have been assigning a string value of T for True and F for False but I have to change this in ASP.NET before storing it as varchar (1) in SQL. There has to be a better way. Thanks.

Yes, you can use bit. Then you can use something like

Dim da As New SqlDataAdapter("SELECT field FROM table", "Provider=...")
Dim ds As New DataSet

da.Fill(ds)

Dim BooleanReturned As Boolean = CBool(ds.Tables(0).Rows(0).Item("field")


Devjunkies.com

Hey,

I haven't had any problems passing boolean values to a bit field back and forth.

Brian

well, my question also related with bekim.
if on my web form i using treeview, once i cehck on any particular treenode, just assume my default value and uncheck the checkbox on treenode is false; checked changed for true. how should i using any method that can convert the bit (datatype on the field) to represent yes/no?

i using this for granting privilege to my usergroup, once i check the treenode, then they can have the access on the system.

thank you, i need the inspiration

Hey,

When you say yes/no, you really mean True/False (boolean values) correct? ADO.NET should convert these values for you, so boolean is converted to bit, and vice versa.

Brian