Stuart,
I don't use MySQL and I don't use the CommandBuilder, but a Google on your error message turned up this:
http://forums.devshed.com/net-development-87/update-datasaet-to-mysql-84331.htmlHe says:
ADO.Net makes heavy use of the schema information of your database and i guess your MySQL driver (or mysql itself) doesn't support returning enough information to generate the dynamic INSERT/UPDATE/DELETE statement called/generated by the DataSet.
IMHO you need to generate your sql statements by yourself (if you stick to using MySQL - or try another provider if there's one...) The poster in this following link shows how to get some schema information and it solved his problem (but I don't know if he was using MySql or not) ... so check it out:
http://discuss.develop.com/archives/wa.exe?A2=ind0110d&L=dotnet&P=39101Hopefully it will help. =0)
~~Bonnie
>Hi
>I am once again having a go at using MySQL as a back end. I can now query MySQL but I cannot add a record. It fails at
>
>IDbCommand cb = this.CommandBuilder.GetInsertCommand();
>
>
>And I get the error
>
>
>Dynamic SQL generation is not supported against a SelectCommand that does not return any base table
>
>
>Any ideas?
>
>THANKS
>
>Stuart