HOMEPAGE Online BusinessGadgets And GizmosSite PromotionSelf Improvement And MotivationTravel And LeisureLegalHome ImprovementAuto And TrucksReligionRecreation And SportsParentingHumorWritingMenFood And DrinkMarketingKids And TeensPolitics And GovernmentComputers And InternetHealthWomenRelationshipsHobbiesBusiness And FinanceMusic And MoviesEducationPets And AnimalsFamilyWeb Design And Development

Connecting and Accessing Data through ADO.NET

Acrticle from category Computers And Internet


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. Keywords: data, adonet, s, programming, systemdataadoadoconnection, offers, data access, database

Related articles:

» Integrating Microsoft Great Plains Accounting/ERP:
» eCommerce development for Microsoft Great Plains:
» Why Laptops are Different than Desktops
» Microsoft Great Plains eCommerce: overview for dev
» Avoiding the Spam Trap: Get Your Message Delivered
» Why You Should Use Turnkey Websites To Jumpstart Y