Executes update statement built using the supplied SQL statement and seperate update value and filter parameters
Declaration Syntax| C# | Visual Basic |
public long ExecuteUpdate( string Sql, IDictionary Params, IDictionary FilterParams )
Public Function ExecuteUpdate ( _ Sql As String, _ Params As IDictionary, _ FilterParams As IDictionary _ ) As Long
Parameters- Sql (String)
-
The SQL statement, update and filter parameter collections
- Params (IDictionary)
-
Column value parameters collection
- FilterParams (IDictionary)
-
Filter value parameters collection
Return Value
Returns the number of rows affected
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); ListDictionary Params = new ListDictionary(); ListDictionary FilterParams = new ListDictionary(); Params["productname"] = ProductName.Value; FilterParams["productid"] = ProductID.Value; Data.ExecuteUpdate("product", Params, FilterParams); // When using separate column value and filter parameters it is only // necessary to specify the table name in statement text Data.Close();