in SQL server 2008 i cant find datatype "Yes/No" or is there any other datatype which will work same as "Yes/No" ?
SQL Server 2008
Page 1 of 13 Replies - 658 Views - Last Post: 10 September 2010 - 03:12 AM
Replies To: SQL Server 2008
#2
Re: SQL Server 2008
Posted 03 September 2010 - 03:24 AM
"Bit" is what you are looking for. It takes the values 0/1(False/True).
#3
Re: SQL Server 2008
Posted 09 September 2010 - 02:27 AM
i have two radio buttons ,one of them will be choose by user..
i want to store value which is choosed by user in database
i have taken bit datatype for the particular column,so i want code to check which is selected ...
thanks in advance
i want to store value which is choosed by user in database
i have taken bit datatype for the particular column,so i want code to check which is selected ...
thanks in advance
#4
Re: SQL Server 2008
Posted 10 September 2010 - 03:12 AM
Same applies with what ionut stated. Store the value of one of the option buttons as a bit. If true is stored, then option1 is checked, otherwise you would set your code to make option2 checked.
If myBitValueFromMyDatabase = True Then
Option1.Checked = True
else
Option2.Checked = True
End If
If myBitValueFromMyDatabase = True Then
Option1.Checked = True
else
Option2.Checked = True
End If
Page 1 of 1
|
|

New Topic/Question
Reply




MultiQuote




|