SQL Server Data Provider

This section will show you how to use the SQL Server Data Provider, including all the classes that are part of it.

Introduction to the SQL Server Data Provider

The SQL Server Data Provider is a set of classes that enable you to access data and metadata within an instance of SQL Server. All operations require an open connection to the database. After you have established a connection, you can perform various operations such as executing stored procedures and retrieving rows of data. The following is a description of each of the classes that make up the SQL Server Data Provider.

Using the SqlConnection Class

As with all data sources that require an active connection, the connection is the heart of the provider. You cannot ...

Get Microsoft® Visual C#® .NET 2003 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.