Jul 16, 2008 04:11 PM|Moonshadow|LINK
Like others in this thread I am trying to use a SqlDataSource for displaying and editing data from a Mysql DB. I can display the data in a Gridview ok. The SELECT and UPDATE commands are working. But I can't get the DELETE and INSERT commands to work.
I am using a MySQL ODBC 3.51 Driver
as per my web host.
The DELETE erro is: SQLBindParameter not used for all parameters
The INSERT error is: Column count doesn't match value count at row 1
[The "id" column is primary but not auto incremented]
I think I have tried all the variations in this thread. Any help would be greatly appreciated. Here is my code for the SqlDataSource.