How to bind asp:CheckBox to MySql table?

[ross1228]

We're having issues bind an asp:checkbox to a mysql table. We've got far enough to retrieve the value and set the checked value of the checkbox, but when we try to update our mysql table it say's we cannot convert from type 'bool' to type 'string'. And if we try to insert a string it say's the input type is not correct.

Any suggestions?

 

[ca8msm]

What datatype is the field you are trying to update?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ross1228]

We've tried boolean and bit.

 

[ca8msm]

Do you get exactly the same error if the type is boolean or bit? I can't see how the conversion to a string would be a valid error from the database so it must be something in your code.

Can you provide the code to create the MySQL table, the stored procedure code for the update, and the .NET code to perform the update?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]