|
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.248-beta+a497a19de709fd99e2448886199a2c8824265ddf
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