C# Class LitDev.LDDataBase

Public Methods

Method	Description
AddListView ( Primitive width, Primitive height ) : Primitive	Add a ListView to view database query results. This is a read only display of query results.
Command ( Primitive database, Primitive command ) : Primitive	Perform an SQLite, MySQL, SqlServer. OleDb or Odbc command (not a query) on a database. If this database is viewed in a dataview then unsaved user changes will be lost when the dataview is updated following this operation.
ConnectMySQL ( Primitive server, Primitive user, Primitive password, Primitive database ) : Primitive	Connect to a MySQL database. This must be called before any SQL methods. The MySQL service must be running and database with credentials already created, if in doubt use SQLite.
ConnectOdbc ( Primitive driver, Primitive server, Primitive port, Primitive user, Primitive password, Primitive option, Primitive database ) : Primitive	Connect to an Odbc driver connected database. This must be called before any SQL methods. The Odbc service must be running and database with credentials already created, if in doubt use SQLite.
ConnectOleDb ( Primitive provider, Primitive server, Primitive database ) : Primitive	Connect to an Access OleDb database. This must be called before any SQL methods. The Access OleDb service must be running and database with credentials already created, if in doubt use SQLite.
ConnectSQLite ( Primitive fileName ) : Primitive	Create or open an SQLite database. This must be called before any SQL methods. When a table is created it must have first column as "Id INTEGER PRIMARY KEY".
ConnectSqlServer ( Primitive server, Primitive database ) : Primitive	Connect to a SqlServer database. This must be called before any SQL methods. The SqlServer service must be running and database with credentials already created, if in doubt use SQLite.
EditTable ( Primitive database, Primitive table, Primitive dataview ) : Primitive	Display a database table for editing in a LDControls.DataView control. Using this method the database is bound to the dataview conrol, reflecting the database.
Query ( Primitive database, Primitive query, Primitive listview, Primitive getRecords ) : Primitive	Perform an SQLite, MySQL, SqlServer, OleDb or Odbc Query (not a command) on a database.
SaveTable ( Primitive database, Primitive dataview ) : Primitive	Commit any changes made in a LDControls.DataView to the database.

Private Methods

Method	Description
AddDataBase ( Primitive fileName ) : Primitive
AddDataView ( Primitive width, Primitive height ) : Primitive
ConnectDataBase ( Primitive server, Primitive user, Primitive password, Primitive database ) : Primitive
Data2Grid ( string shapeName, DataTable dataTable ) : void
ExtractDll ( ) : void
GetDataBase ( string name, bool bShowErrors = true ) : DataBase
GetDataTable ( DataBase dataBase, string query, DataTable dataTable ) : DataTable
NextID ( ) : int
UpdateDataTable ( DataBase dataBase, System.Windows.Forms.DataGridView dataView ) : void
UpdateDataTableBySQL ( DataBase dataBase, System.Windows.Forms.DataGridView dataView ) : void

Method Details

AddListView() public static method

Add a ListView to view database query results. This is a read only display of query results.

public static AddListView ( Primitive width, Primitive height ) : Primitive
width	Primitive	The width of the ListView.
height	Primitive	The height of the ListView.
return	Primitive

Command() public static method

Perform an SQLite, MySQL, SqlServer. OleDb or Odbc command (not a query) on a database. If this database is viewed in a dataview then unsaved user changes will be lost when the dataview is updated following this operation.

public static Command ( Primitive database, Primitive command ) : Primitive
database	Primitive	The existing database label (see ConnectSQLite, ConnectMySQL, ConnectSqlServer, ConnectOleDb or ConnectOdbc).
command	Primitive	The SQL Command.
return	Primitive

ConnectMySQL() public static method

Connect to a MySQL database. This must be called before any SQL methods. The MySQL service must be running and database with credentials already created, if in doubt use SQLite.

public static ConnectMySQL ( Primitive server, Primitive user, Primitive password, Primitive database ) : Primitive
server	Primitive	The MySQL server (e.g. "localhost").
user	Primitive	The MySQL user name.
password	Primitive	The MySQL user password.
database	Primitive	The MySQL database name.
return	Primitive

ConnectOdbc() public static method

Connect to an Odbc driver connected database. This must be called before any SQL methods. The Odbc service must be running and database with credentials already created, if in doubt use SQLite.

public static ConnectOdbc ( Primitive driver, Primitive server, Primitive port, Primitive user, Primitive password, Primitive option, Primitive database ) : Primitive
driver	Primitive	The Odbc driver (e.g. "{MySQL ODBC 3.51 Driver}").
server	Primitive	The Odbc server (e.g. "localhost").
port	Primitive	The Odbc port number.
user	Primitive	The Odbc user name.
password	Primitive	The Odbc user password.
option	Primitive	The Odbc option number to control the Odbc connection (e.g. 0 or 3).
database	Primitive	The Odbc database name.
return	Primitive

ConnectOleDb() public static method

Connect to an Access OleDb database. This must be called before any SQL methods. The Access OleDb service must be running and database with credentials already created, if in doubt use SQLite.

public static ConnectOleDb ( Primitive provider, Primitive server, Primitive database ) : Primitive
provider	Primitive	The OleDb provider (e.g. "SQLOLEDB").
server	Primitive	The OleDb server (e.g. "localhost").
database	Primitive	The OleDb database name.
return	Primitive

ConnectSQLite() public static method

Create or open an SQLite database. This must be called before any SQL methods. When a table is created it must have first column as "Id INTEGER PRIMARY KEY".

public static ConnectSQLite ( Primitive fileName ) : Primitive
fileName	Primitive	The full path to the SQLite database file (usually with extension db).
return	Primitive

ConnectSqlServer() public static method

Connect to a SqlServer database. This must be called before any SQL methods. The SqlServer service must be running and database with credentials already created, if in doubt use SQLite.

public static ConnectSqlServer ( Primitive server, Primitive database ) : Primitive
server	Primitive	The SqlServer server (e.g. "(local)\SQLEXPRESS").
database	Primitive	The SqlServer database name.
return	Primitive

EditTable() public static method

Display a database table for editing in a LDControls.DataView control. Using this method the database is bound to the dataview conrol, reflecting the database.

public static EditTable ( Primitive database, Primitive table, Primitive dataview ) : Primitive
database	Primitive	The existing database label (see ConnectSQLite, ConnectMySQL, ConnectSqlServer, ConnectOleDb or ConnectOdbc).
table	Primitive	The table name to view and edit.
dataview	Primitive	A DataView control.
return	Primitive

Query() public static method

Perform an SQLite, MySQL, SqlServer, OleDb or Odbc Query (not a command) on a database.

public static Query ( Primitive database, Primitive query, Primitive listview, Primitive getRecords ) : Primitive
database	Primitive	The existing database label (see ConnectSQLite, ConnectMySQL, ConnectSqlServer, ConnectOleDb or ConnectOdbc).
query	Primitive	The SQL Query. /// Example "SELECT * FROM myTable;".
listview	Primitive	A ListView to populate with the query result or "" for none.
getRecords	Primitive	Optionally return an array of results ("True" or "False"). /// Remember large multi-dimensional arrays in Small Basic are slow.
return	Primitive

SaveTable() public static method

Commit any changes made in a LDControls.DataView to the database.

public static SaveTable ( Primitive database, Primitive dataview ) : Primitive
database	Primitive	The existing database label (see ConnectSQLite, ConnectMySQL, ConnectSqlServer, ConnectOleDb or ConnectOdbc).
dataview	Primitive	A DataView control.
return	Primitive