Working with the Main ADO.NET Objects
The previous section discussed the ADO.NET architecture and the main objects that build the ADO.NET programming. This section gets into more detail on these objects, so that you understand both the role of each in the construction of a data-driven ASP.NET application and how each object is linked to the others.
Connecting to a Data Source Using the Connection Object
The first ADO.NET object that we will analyze is the Connection object. The function of this object is to make way for data, so it can flow from a data source to an application and vice versa. (No other ADO.NET object can work with data from a remote data source except through a Connection object.)
There are two different versions of the Connection ...