Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

SqlDataAdapter Reference

The SqlDataAdapter class offers properties, methods, and events to meet your every need. Let’s meet them now.

Properties of the SqlDataAdapter Class

You can divide the SqlDataAdapter class’s properties into two groups—those that control communication with the data store, and those that control communication with the DataSet.

The properties that control communication with the data store are the ones that contain SqlCommand objects: the SelectCommand, UpdateCommand, InsertCommand, and DeleteCommand properties. These properties contain SqlCommand objects that the SqlDataAdapter executes when you want to move information back and forth between a DataSet and your data store—to retrieve rows into your DataSet or to submit changes ...