Connecting and Accessing Data through ADO.NET

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.

About the Author

Presently working in the capacity of the Technical Director of Birbals, an e-consulting firm based in India dedicated in providing innovative and effective web, Hospitality and consultancy services to public, private and non-profit organizations. Successfully founded Birbals and other IT companies like Ebirbals and SeoBirbals.