This website completely moved to new platform. For latest content, visit www.programmingposts.com

Search this Site

13 Nov 2012

ADO.NET CLASSES

ADO.NET Classes:


 Connection:


-> Maintains the connection with the database.

 Command:


-> Executes a Query Statement( Select Statement), Non-Query Statement(insert /update/delete) or stored procedure/function at back-end.

DataReader:


->It acts as a buffer, which holds the data, after execution of a query statement at back-end.

DataAdapter:


-> Executes a query statement at back-end.

Parameter:


-> Sends a parameter (argument) value to a back-end stored procedure/function.

Dataset:


->Acts as a buffer which holds multiple tables at a time.

DataTable:


->Acts as a buffer, which holds a single table (collection of rows and columns)

DataRow:


->Acts as a buffer, which holds a single row.

DataColumn:


Acts as a buffer, which holds single column.

Note:


All the above classes needs to create Objects of these classes.