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;
Snew 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.