 |
Further
Reading ...
|
|
Can Web Copy Writers Learn From Direct Mail Techniques
Would you send a million letters costing tens of thousands to print and mail, in a direct marketing campaign, without testing the letter content first? It's what many website owners do when they don't test and measure their own website copy and...
Microsoft CRM Data Conversion FAQ
Microsoft Business Solutions CRM data conversion deserves FAQ type of article, where IT people could get initial directions. Even if it seems as a trivial task, we would suggest you to think about these possible scenarios: objects mapping between...
How To Protect Your Ebooks And Software From Being Stolen!
There are many systems that can lock your software or document, allowing you to control access to that file. But the problem arises with assuming that this will stop all theft. A well thought out, thorough protection system can deter theft, but it...
Do you own your own name?
Do you own yourownname.com ? How about .net , .org or .biz ? Owning your own domain name is like owning your piece of real estate on the internet. http://www.quickregister.biz Hey, some domain have sold for millions of dollars. Here are some...
|
|
|
Connecting and Accessing Data through ADO.NET
|
 |
Written 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 - continued below ...
|
|
|
continued ...
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.
|
|
|
|
 |
|
|
| _Additional Resources ... |
|
Printers - My Pet Peeve
The Cost of Ink
This is my third article on the subject you can read my others on my web site www.caveatemptorus.com or at www.ezinearticles.com.
I believe in free enterprise and all that but some things are beyond the pale. Ever since the...
The Value of Forums
There are literally thousands of online forums that cover a wide range of topics. Forums provide individuals, who share a common interest, with a meeting place for open discussion, and a great gathering spot for "water cooler" talk. When used...
Virus Protection
One of the saddest things in the entire world is hearing the words, "I think I've been hit by a virus" or "my computer was destroyed by a virus, can you help me please?" Every time I hear these words I want to cry - well, actually I want to scream...
|
|
|
|
|
|
|
|
|
|
