User talk:Jaison.anto.k

Hai Friends I will tell what are the essential things of ADO.NET SQL Data Connection Object The Data Connection is a lifeline between the Data Provider (in this case, SQL Server) and your .NET application. SQL Data Command Object The SQL Data Command object allows you to perform commands and request data from a data source.

Using the Data Command's Parameter Collection When using stored procedures, you will often make use of input and output parameters. To populate or read from the parameters, you will need to add items to the Parameters collection.

Sql DataReader Object The SQL Data Reader is an object that allows you to read the data that is retrieved from a Data Command. It is refered to as a "fire-hose" connection, because you can only read in one direction (and can't jump back and forth through the Data Reader as you would an array or collection).

SqlDataAdapter Since DataSets are completely disconnected from their data source, a special adapter is needed to resolve any changes made to the DataSet back to the origina data source. The SqlDataAdapter knows how to resovlve Updates, Deletes and Inserts. Also shows the DataAdapter events that can be captured by your applications.