Updating the Data Source Using SQLCommandBuilder
SQLDataAdapter does not automatically create the SQL statements to reconcile changes back to the data source. The SQLCommandBuilder class will perform this task for you. SQLCommandBuilder is easy to use and requires little coding.
The SQLCommandBuilder class uses the SelectCommand property of SQLDataAdapter to retrieve metadata about the data set. From this information, SQLCommandBuilder builds the appropriate InsertCommand, UpdateCommand, and DeleteCommand classes. These classes contain the appropriate SQL statements needed to perform their functions against the data source. There are, however, limitations with SQLCommandBuilder, which are listed here:
SQLCommandBuilder works with only a single ...
Get Delphi for .NET Developer’s Guide 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.
