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");
|