DBSelect

Function to select values in the database.

Syntax:

List<List<string>> Select(string connString, string selString);
Select query in the database.

List<List<string>> Select(string provider, string connString, string selString);
Select query 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 selString: A String parameter containing the select query.

Return:

Returns a List<List<String>> containing the result query of the database.

Example:

In this example, the object "SelectQuery" will store the values returned by the Select query.

List<List<string>> SelectQuery = SVDBConnection.Select("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Acces.accdb","SELECT value, timestamp FROM Test WHERE ID=100");