I've just installed to Sql2005 Express (MSDE is also running on the same machine). Now when I try to add a SqlDataAdapter (running the wizard) using VB.Net 2003, I get a message that only the SELECT statement can be generated; that there are errors (unspecified) generating the INSERT/UPDATE/DELETE statements. Is there an issue here I'm missing? And a solution?

Thanks.

It's been awhile, so I could be wrong but IIRC you 2003 couldn't generate insert/Update/delete code when it involved multiple tables.


Try to work without the wizards (once you feel comfortable), you'll learn alot more. :)

Make sure there is a "primary key" in the table you are selecting from, and that this is included in your SQL statement.