The following namespaces are required to enable the use of databases in ASP.NET pages:
• The System.Data namespace.
• The System.Data.OleDb namespace (to use any data provider, such as Access, Oracle, or SQL)
• The System.Data.SQLClient namespace (specifically to use SQL as the data provider)

The DataAdapter.Update() method calls any of the DML statements, such as the UPDATE, INSERT, or DELETEstatements, as the case may be to update, insert, or delete a row in a DataSet. TheDataSet.Acceptchanges() method reflects all the changes made to the row since the last time theAcceptChanges() method was called.

Object pooling is a concept of storing a pool (group) of objects in memory that can be reused later as needed. Whenever, a new object is required to create, an object from the pool can be allocated for this request; thereby, minimizing the object creation. A pool can also refer to a group of connections and threads. Pooling, therefore, helps in minimizing the use of system resources, improves system scalability, and performance.

The DataSource property and the DataMember property are used to bind a DataGridView control.

You must set the DataSource property and call the DataBind() method.