|
DataExtensionsUpdateData(SqlConnection, DataTable, String) Method
|
Updates the underlying data of the DataTable using SqlConnection, and
returns the number of rows successfully updated.
Namespace: GSF.DataAssembly: GSF.Core (in GSF.Core.dll) Version: 2.4.260-beta+76c7c6cf0c1396b9d31fa51bf4853b8ac963cce8
Syntaxpublic static int UpdateData(
this SqlConnection connection,
DataTable sourceData,
string sourceSql
)
<ExtensionAttribute>
Public Shared Function UpdateData (
connection As SqlConnection,
sourceData As DataTable,
sourceSql As String
) As Integer
public:
[ExtensionAttribute]
static int UpdateData(
SqlConnection^ connection,
DataTable^ sourceData,
String^ sourceSql
)
[<ExtensionAttribute>]
static member UpdateData :
connection : SqlConnection *
sourceData : DataTable *
sourceSql : string -> int GSF.Data.DataExtensions.UpdateData = function(connection, sourceData, sourceSql);
View SourceParameters
- 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
Int32The 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