The SqlClient type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
 | Connect |
Opens a database connection.
|
| CopyDataToServer |
Transferring the specified tables from the instance of DataSet to the database.
Used SqlBulkCopy.
The fastest and most economical way to move large amounts of data in the database.
|
| CopyTableToServer |
Transferring the specified table to the database.
Used SqlBulkCopy.
The fastest and most economical way to move large amounts of data in the database.
|
| Disconnect |
Closes the database connection.
|
| Dispose |
Releases all resources used by the object.
If necessary, closing all opened connections to the database.
|
| Equals | (Inherited from Object.) |
| ExecuteNonQuery |
Executes a Transact-SQL statement against the connection and returns the number of rows affected.
This method is used in conjunction with the properties CommandType, CommandText and Parameters.
|
| ExecuteNonQuery(SqlCommand) |
Executes the specified SqlCommand and returns the number of rows affected.
|
| ExecuteNonQuery(String) |
Executes a Transact-SQL statement against the connection and returns the number of rows affected.
|
| ExecuteScalar |
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
This method is used in conjunction with the properties CommandType, CommandText and Parameters.
|
| ExecuteScalar(SqlCommand) |
Executes the specified SqlCommand, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
|
| ExecuteScalar(String) |
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
|
 | Finalize | (Inherited from Object.) |
| GetData |
Executes the query and returns DataSet.
This method is used in conjunction with the properties CommandType, CommandText and Parameters.
|
| GetData(SqlCommand) |
Executes the specified SqlCommand and returns DataSet.
|
| GetData(String) |
Executes the specified SQL-statement and returns DataSet.
|
| GetHashCode | (Inherited from Object.) |
| GetRow |
Executes the query and returns data row.
This method is used in conjunction with the properties CommandType, CommandText and Parameters.
|
| GetRow(SqlCommand) |
Executes the specified SqlCommand and returns строку данных.
|
| GetRow(String) |
Executes the query and returns data row.
|
| GetTable |
Executes the query and returns DataTable.
This method is used in conjunction with the properties CommandType, CommandText and Parameters.
|
| GetTable(SqlCommand) |
Executes the specified SqlCommand and returns DataTable.
|
| GetTable(String) |
Executes the query and returns DataTable.
|
| GetType | (Inherited from Object.) |
| MemberwiseClone | (Inherited from Object.) |
| ToString | (Inherited from Object.) |
See Also