|
Article:
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. This article was posted on April '16
|
