The Sql Data Source control supports the same operations, but the approach is different, and this tutorial shows how to configure the Sql Data Source to insert, update, and delete data.
As discussed in An Overview of Inserting, Updating, and Deleting, the Grid View control provides built-in updating and deleting capabilities, while the Details View and Form View controls include inserting support along with editing and deleting functionality.
Net applications for retrieving, accessing and updating data. Net object model is nothing but the structured process flow through various components.
A data provider is used for connecting to a database, executing commands and retrieving data, storing it in a dataset, reading the retrieved data and updating the database. Net consists of the following four objects: Data Adapter This is integral to the working of ADO.
With the Sql Data Source, we need to provide SQL statements (or stored procedures) to execute.