SQL Server

Table 6.1 summarizes the objects a Visual Basic application uses to manipulate SQL Server databases. The following sections describe these objects in detail.

Table 6.1. SQL Server Data Access Objects
Class Purpose
SqlConnection Connects the application to a SQL Server database
SqlCommand Represents a stored procedure or SQL statement that the program will execute on a SqlConnection
SqlParameter Represents a parameter used by a SqlCommand object
SqlDataAdapter Uses SqlCommand objects to move data between a database and DataSetobjects
SqlCommandBuilder Generates SqlCommand objects
SqlDataReader Allows the program to read a forward-only set of data
SqlTransaction Manages SQL transactions in the database


The SqlConnection ...

Get Visual Basic® .NET Database Programming now with O’Reilly online learning.

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