SqlBulkCopy::WriteToServer Method
Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.
Assembly: System.Data (in System.Data.dll)
| Name | Description | |
|---|---|---|
![]() | WriteToServer(array<DataRow^>^) | Copies all rows from the supplied DataRow array to a destination table specified by the DestinationTableName property of the SqlBulkCopy object. |
![]() | WriteToServer(DataTable^) | Copies all rows in the supplied DataTable to a destination table specified by the DestinationTableName property of the SqlBulkCopy object. |
![]() | WriteToServer(DataTable^, DataRowState) | Copies only rows that match the supplied row state in the supplied DataTable to a destination table specified by the DestinationTableName property of the SqlBulkCopy object. |
![]() | WriteToServer(DbDataReader^) | Copies all rows from the supplied DbDataReader array to a destination table specified by the DestinationTableName property of the SqlBulkCopy object. |
![]() | WriteToServer(IDataReader^) | Copies all rows in the supplied IDataReader to a destination table specified by the DestinationTableName property of the SqlBulkCopy object. |
If multiple active result sets (MARS) is disabled, WriteToServer makes the connection busy. If MARS is enabled, you can interleave calls to WriteToServer with other commands in the same connection.
