Search:       

Thursday, 8 January 2009       

 
Home / Computers

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.

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.

Article Source: http://www.dailynewarticles.com




More Articles from Computers Category:
Find The Best Deals And Discounts In Computer Sales
Get Great Prices and Bargains In Computer Sales
Choosing The Best Computer Printer Ink Kit
Computer Printer Ink Getting More Affordable
How Digital Cameras Work
Is It Wise To Buy Refurbished Merchandise?
Benefits of Using a Dedicated Server
Ask Whois - Find the Truth About Websites
Some Essentials You Need To Know To Choose The Right Printer
How To Choose A Printer That Will Do The Job For You
A Look At Bluetooth Security
Top PC Hardware Accessories to Boost your Gaming Performance
Bluetooth Profiles Explained
Bluetooth Wireless Operation
Finding Hip Hop Mix Podcasts

 


Main Menu
Home
Most Popular Articles
Top Authors
Submit Articles
Submission Guidelines
Link to Us
Bookmark
Contact Us

Partners
Blue Articles

 

 

- Privacy Policy -