An Example<\/h4>\n\n\tbool DatabaseSqlite::InitialiseDatabase(void)\n\t{\n\t\tSystem::Data::SQLite::SQLiteConnection ^Connection1;\n\t\tString ^sTemp;\n\n\t\ttry\n\t\t{\n\n\t\t\t\/\/----- OPEN THE DATABASE CONNECTION -----\n\t\t\tConnection1 = gcnew System::Data::SQLite::SQLiteConnection(\"data source=\" + Environment::GetFolderPath(Environment::SpecialFolder::ApplicationData) + \"\\\\\" + Application::CompanyName + \"\\\\\" + Application::ProductName + \"\\\\mydatabasefile.db;Password=\" + SQLITE_DATABASE_FILE_PASSWORD);\n\t\t\tConnection1->Open();\n\n\t\t\tSystem::Data::SQLite::SQLiteCommand ^Command1 = gcnew System::Data::SQLite::SQLiteCommand(Connection1);\n\n\t\t\t\/\/----- CREATE MY TABLE IF NECESSARY -----\n\t\t\tsTemp = \"CREATE TABLE IF NOT EXISTS tblMyTableName ( \\\n\t\t\t\t\t\t\t\t\tId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, \\\n\t\t\t\t\t\t\t\t\tMyIntigerField INTEGER, \\\n\t\t\t\t\t\t\t\t\tMyNumericField NUMERIC, \\\n\t\t\t\t\t\t\t\t\tMyRealField REAL, \\\n\t\t\t\t\t\t\t\t\tMyTextField TEXT \\\n\t\t\t\t\t\t\t\t\t)\";\n\t\t\tCommand1->CommandText = sTemp;\n\t\t\tCommand1->ExecuteNonQuery();\n\n\t\t\treturn(true);\n\t\t}\n\t\tcatch (Exception ^e)\n\t\t{\n\t\t\tMessageBox::Show(L\"Error:\\n\" + e, L\"Error\", MessageBoxButtons::OK, MessageBoxIcon::Error);\n\t\t\treturn(false);\n\t\t}\n\t\tfinally\n\t\t{\n\t\t\t\/\/----- CLOSE THE DATABASE CONNECTION -----\n\t\t\ttry\n\t\t\t{\n\t\t\t\tif (Connection1 != nullptr)\n\t\t\t\t\tConnection1->Close();\n\t\t\t}\n\t\t\tcatch (Exception ^)\n\t\t\t{\n\t\t\t}\n\t\t}\n\t}\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Good Resources https:\/\/www.sqlite.org\/lang_createtable.html An Example bool DatabaseSqlite::InitialiseDatabase(void) { System::Data::SQLite::SQLiteConnection ^Connection1; String ^sTemp; try { \/\/—– OPEN THE DATABASE CONNECTION —– Connection1 = gcnew 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 = gcnew System::Data::SQLite::SQLiteCommand(Connection1); \/\/—– CREATE MY TABLE IF NECESSARY —– sTemp = “CREATE […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107],"tags":[],"class_list":["post-1242","post","type-post","status-publish","format-standard","hentry","category-tables"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/comments?post=1242"}],"version-history":[{"count":6,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1242\/revisions"}],"predecessor-version":[{"id":1647,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/posts\/1242\/revisions\/1647"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/media?parent=1242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/categories?post=1242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/visualcpp\/wp-json\/wp\/v2\/tags?post=1242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}