Sorry Michel ... I'm still trying to catch up on posts since being out of town for several days last week ... and I missed seeing your other post until after I replied to this one.

As you have seen, a bit data type in SQL Server is treated as a boolean data type in Visual Studio.

~~Bonnie



>>If your SQL database is using a bit, you can still pass an integer for the boolean value. And, as long as it is not something greater than 1, it works fine. So there is no need to do any conversion.
>
>Yes, as you probably have seen in my other reply.
>
>But, this also related to the way we handle the SQL query, as I also mentioned. I was surprise to see that we can still have VB.NET code using a boolean approach to deal with Bit field or Numeric(1,0) field in a datarow.