This topic has not yet been rated - Rate this topic

SqlBulkCopy.WriteToServer Method

.NET Framework 4.5

Copies all rows from a data source to a destination table specified by the DestinationTableName property of the SqlBulkCopy object.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

Overload List

	Name	Description
	WriteToServer(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(IDataReader)	Copies all rows in the supplied IDataReader 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.

Top

Remarks

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.

Reference

SqlBulkCopy Class

System.Data.SqlClient Namespace

Other Resources

Bulk Copy Operations in SQL Server (ADO.NET)

ADO.NET Managed Providers and DataSet Developer Center

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)