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.
| 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 ...
Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
