Questions That Should Be Asked More Frequently
Q | How do the Data Adapter Configuration Wizard and CommandBuilder objects handle a scenario in which I want to refresh the contents of my row after submitting an update? Some things seem to work automatically, but others don’t. |
A | The wizard will include queries to refresh your data immediately after you submit a new row or modify an existing row only if you’re using a SqlDataAdapter. If you do not want the Data Adapter Configuration Wizard to generate these refresh queries, click the Advanced Options button in the wizard and turn this feature off. The CommandBuilder classes do not generate refresh queries no matter what .NET Data Provider you’re using. |
Q | I have cascading referential integrity constraints ... |
Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
