protected bool CreateDB(string Query) { if (!File.Exists(dbFileName)) { SQLiteConnection.CreateFile(dbFileName); } try { Connection = new SQLiteConnection("Data Source=" + dbFileName + ";Version=3;"); Connection.Open(); Command.Connection = Connection; Command.CommandText = Query; Command.ExecuteNonQuery(); } catch (SQLiteException ex) { ErrorMsg = ex.Message; return(false); } return(true); }
private void fnRecreate() { if (DB != null) { DB.Close(); DB.Dispose(); } if (System.IO.File.Exists(tDB.Text + ".db")) { System.IO.File.Delete(tDB.Text + ".db"); } SQLiteConnection.CreateFile(tDB.Text + ".db"); SQLiteConnection.CompressFile(tDB.Text + ".db"); DB = new SQLiteConnection("Data source=" + tDB.Text + ".db"); DB.Open(); using (SQLiteCommand DBc = DB.CreateCommand()) { DBc.CommandText = "CREATE TABLE 'dickbutt' (" + "'id' unsigned bigint(20), " + "'hash' varchar(32), " + "'tags' text)"; DBc.ExecuteNonQuery(); } }
// Creates an empty database file void createNewDatabase() { SQLiteConnection.CreateFile("MyDatabase.sqlite"); }