ADO.NET AND ITS OBJECTS

Ado.net and its Objects

Introduction:

The ado.net is a part of .net framework created for accessing the data from the database. It has some objects for various functions whereas here we will discuss about 6 main types of objects we use in ado.net.

Description:

When we use the asp.net,  there we use some controls for some operation or function if that controls related with accessing the database data we use ado.net.
Here we gonna see some of the main types of ado.net objects 

1.  sqlconnection
2.  sqlcommand
3.  sqldatareader
4.  sqldataadapter
5.  dataset 
6.  datatable

SQLCONNECTION

         The sqlconnection is the object in ado.net used to create the connection path to the required database, normally we can find this on sqrserver database connection field, where we use to open the sqlserver management tools like sqlserver 2008.

         Normally in windows authentication, the Sqlconnection or connection string will be like "Data Source=G-V-R\\SQLEXPRESS;Initial Catalog = RamAnand;Integrated Security=True"

whereas if u use server authentication. the Sqlconnection or connection string will be like 
"Data Source=G-V-R\\SQLEXPRESS;Initial Catalog = RamAnand;Uid=sa;Password=DBMS"

here data source is the name of my system, Initial Catalog is the database I want to access.

for other objects visit: http://aspfunlearning.blogspot.in/2013/11/objects-of-adonet.html

thank you, like and comment if any help needed!!!