May 2004
Intermediate to advanced
888 pages
22h 31m
English
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 ...
Read now
Unlock full access