Chapter 5. Connecting to Databases

0-13-101881-7_ch05 Chapter 5. Connecting to Databases</h2>
Team-Fly team-fly    

  
ADO.NET Programming in Visual Basic .NET
By Steve  Holzner, Bob  Howell

Table of Contents


The first step in working with a database in ADO .NET is to connect to the database using either the SQL Client or the OleDb Client classes and an OLE DB provider. This chapter is all about how you make that connection. As stated previously, there are two Connection classes, one for the SQL Client and one for the OleDb Client. Each class has roughly parallel sets of properties, methods , and events. The OleDbConnection class is slightly more interesting than the SqlConnection class because it supports more database providers. The SqlConnection class is SQL Server-specific, and because of this, many provider-specific settings are built into it. We will discuss both providers together, and where there are differences I will note them. There is a third set of classes for connecting using ODBC data sources. [1] These must be downloaded separately from Microsoft and are not part of Visual Studio. The ODBC classes are useful for connecting to older versions of databases not supported by OLEDB and also many of the older ISAM style databases such as dBase and Paradox.

[1] These are in beta as of the date of this writing.


Team-Fly team-fly    
Top


ADO. NET Programming in Visual Basic. NET
ADO.NET Programming in Visual Basic .NET (2nd Edition)
ISBN: 0131018817
EAN: 2147483647
Year: 2005
Pages: 123

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net