Click or drag to resize

DataExtensionsUpdateData(SqlConnection, DataTable, String) Method

Updates the underlying data of the DataTable using SqlConnection, and returns the number of rows successfully updated.

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.240-beta+897dce54fc8a4a27d3c8972aabbe9a3d48c9c170
Syntax
public static int UpdateData(
	this SqlConnection connection,
	DataTable sourceData,
	string sourceSql
)
View Source

Parameters

connection  SqlConnection
The SqlConnection to use for updating the underlying data source.
sourceData  DataTable
The DataTable used to update the underlying data source.
sourceSql  String
The SQL statement used initially to populate the DataTable.

Return Value

Int32
The number of rows successfully updated from the DataTable.

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type SqlConnection. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
See Also