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.181-beta
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