: Connecting and Accessing Data through ADO.NET by: Pawan Bangar Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access. Accessing data has become a major programming task

Posted in: #Computers-And-Internet #Data #Adonet #S #Programming #Systemdataadoadoconnection #Offers #Data-Access #Database

Connecting and Accessing Data through ADO.NET

by: Pawan Bangar

Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access.
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 exception, as otherwise catch block would have been executed.