Connecting and Accessing Data through ADO.NET

By: Pawan Bangar

Accessing data has become a major programming task for modern software programming, both for standardalone applications and for web based applications. Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access.

ADO.NET is an improvement to Microsoft ActiveX Data Objects (ADO). It is a standards-based programming model for creating distributed data-sharing applications. ADO.NET offers several advantages over previous versions of ADO and over other data access components.

These benefits fall into the following categories:

Interoperability
Maintainability
Programmability
Performance.
Connecting to a database:
For performing and operation we need to connect to a database. This is done automatically through ADO connection, of which code is associated with VS.net Programming environment.

Connecting Database
sharp1.cs class xyz1 {
public static void main()
{
try
{
    System.Data.ADO.ADOConnection s;
    S=new System.Data.ADO.ADOConnection();
    System.Console.Writeline("C-Sharp);
}
catch(System.Exception e)
{
    System.console.Writeline(e.ToString());
}}}

Above program can be compiled through command line at DOS promot giving command line option as /r:System.Data.Dll

Because the code for ADO.Connection is available at this DLL. The above program consists of an object s resembling as System.ado.adoconnection .

Thus we are creating the object s by the statement:

System.Data.ADO.ADOConnection s;

From the output it is clear that the constructor has thrown no exceptionHealth Fitness Articles, as otherwise catch block would have been executed.

Computers
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 
 • 

» More on Computers