This documentation is archived and is not being maintained.
System.Data.SqlClient Namespace
.NET Framework 1.1
The System.Data.SqlClient namespace is the .NET Framework Data Provider for SQL Server.
The .NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space. Using the SqlDataAdapter, you can fill a memory-resident DataSet, which you can use to query and update the database.
For information on how to use this namespace, see the SqlDataAdapter, the SqlDataReader, the SqlCommand, and the SqlConnection classes. For conceptual information about using this namespace when programming with the .NET Framework, see "Accessing Data with ADO.NET".
Classes
| Class | Description |
|---|---|
| SqlClientPermission | Enables the .NET Framework Data Provider for SQL Server to help ensure that a user has a security level adequate to access a data source. |
| SqlClientPermissionAttribute | Associates a security action with a custom security attribute. |
| SqlCommand | Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited. |
| SqlCommandBuilder | Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited. |
| SqlConnection | Represents an open connection to a SQL Server database. This class cannot be inherited. |
| SqlDataAdapter | Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited. |
| SqlDataReader | Provides a means of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited. |
| SqlError | Collects information relevant to a warning or error returned by SQL Server. This class cannot be inherited. |
| SqlErrorCollection | Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited. |
| SqlException | The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited. |
| SqlInfoMessageEventArgs | Provides data for the InfoMessage event. This class cannot be inherited. |
| SqlParameter | Represents a parameter to a SqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited. |
| SqlParameterCollection | Represents a collection of parameters relevant to a SqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited. |
| SqlRowUpdatedEventArgs | Provides data for the RowUpdated event. This class cannot be inherited. |
| SqlRowUpdatingEventArgs | Provides data for the RowUpdating event. This class cannot be inherited. |
| SqlTransaction | Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited. |
Delegates
| Delegate | Description |
|---|---|
| SqlInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of a SqlConnection. |
| SqlRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of a SqlDataAdapter. |
| SqlRowUpdatingEventHandler | Represents the method that will handle the RowUpdating event of a SqlDataAdapter. |
See Also
Show: