O'Reilly logo

Visual Basic® .NET Database Programming by Rod Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

SqlConnection

The SqlConnection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required