TableAdapter Fill() returns SQL syntax error for data type bit

microsoft.public.dotnet.framework.adonet

28 Feb 2006 1:25 PM

Ronen

Hi,

When calling the Fill() method for a TableAdapter I get the following error:
"syntax error converting the varchar value 'TRUE' to a column of data type
bit"

The typed DataSet to be filled maps the SQL bit columns to a System.boolean
column ('TRUE' instead of 1).

Any workaround for this?

Thanks,

-Ronen

1 Mar 2006 8:25 AM

Miha Markic [MVP C#]

Hi Ronen,

It sounds to me like you are trying to bind a string (and not bit) to
System.Boolean.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"Ronen" <ronmey***@hotmail.com> wrote in message
news:4F767A7A-AD9C-4627-A7F3-732EC2E8900F@microsoft.com...
> Hi,
>
> When calling the Fill() method for a TableAdapter I get the following
> error:
> "syntax error converting the varchar value 'TRUE' to a column of data type
> bit"
>
> The typed DataSet to be filled maps the SQL bit columns to a
> System.boolean
> column ('TRUE' instead of 1).
>
> Any workaround for this?
>
> Thanks,
>
> -Ronen