Creating Tables

An Example //***************************************** //***************************************** //********** INITIALISE DATABASE ********** //***************************************** //***************************************** bool InitialiseDatabase() { System.Data.SQLite.SQLiteConnection Connection1 = null; String sTemp; try { //—– OPEN THE DATABASE CONNECTION —– Connection1 = new System.Data.SQLite.SQLiteConnection(“data source=” + Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + “\\” + Application.CompanyName + “\\” + Application.ProductName + “\\mydatabasefile.db;Password=” + SQLITE_DATABASE_FILE_PASSWORD); Connection1.Open(); System.Data.SQLite.SQLiteCommand Command1 = new System.Data.SQLite.SQLiteCommand(Connection1); //—– CREATE MY […]

Read More