O'Reilly logo

Delphi for .NET Developer’s Guide by Xavier Pacheco

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required