DBUpdate

Parent Previous Next

DBUpdate

Function to update the database.


Syntax:

Int Update(string connString, string updString);
Update the entries in the database.

Int Update(string provider, string connString, string updString);
Update the entries in the database.


Params:

String provider: A String parameter containing the provider name of the connection.
Exemple of providers: Odbc, OleDB, OracleClient or SqlClient

String connString: A String parameter containing the name of the connection.

String updString: A String parameter containing the update query.


Return:

Int: The number of rows affected.


Example:

In this example, the user will update "Test" table setting the value 2 to the "value" column.

  


SVDBConnection.Update("OleDB","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Acces.accdb","UPDATE Test SET value=2");