views:

302

answers:

4

I have a field in a SQL Server table that is of type bit.

When I try to use a Boolean in VB.NET when passing parameters to a stored procedure, there are never any matches. I have also tried passing an integer to the stored procedure and that does not work either.

A: 

Have you tried using a Bit ?

u07ch
+1  A: 

have a look at this table:

http://msdn.microsoft.com/en-us/library/ms131092.aspx

Tony
thanks for the info!!
WACM161
+1  A: 

How about

SqlDbType.Bit
astander
+1  A: 

System.Data.SqlTypes.SqlBoolean

Remus Rusanu