Data Adapter Update/Delete

Prompted Error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

Scenario/Findings: Was trying to update a record using the data adapter but prompted with the above error. Resolved by setting the primary key in the table.

Written by admin on January 31st, 2010 with no comments.
Read more articles on Search Engine and Software Review and Supplement.

Related articles

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:




You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .