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

[Guest]

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

 

[Miha Markic [MVP C#]]

Hi Ronen,

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