public static void ReadDatabaseSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM DatabaseSettings"; oleDb.ExecuteFill("DatabaseSettings"); DataConfig.localDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"].ToString(); DataConfig.typeDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"].ToString(); DataConfig.typeConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"].ToString(); DataConfig.serverConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"].ToString(); oleDb.Dispose(); Utilits.Console.Log("Настройки соединения с базой данных успешно загружены."); }catch (Exception ex) { oleDb.Error(); MessageBox.Show("[ReadDatabaseSettings]: " + ex.ToString(), "Ошибка"); Application.Exit(); } DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; }
public static bool SaveSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [autoUpdate], [showConsole], [period] FROM Settings"; oleDb.oleDbCommandUpdate.CommandText = "UPDATE Settings SET " + "[autoUpdate] = @autoUpdate, " + "[showConsole] = @showConsole, " + "[period] = @period " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@autoUpdate", OleDbType.VarChar, 255, "autoUpdate"); oleDb.oleDbCommandUpdate.Parameters.Add("@showConsole", OleDbType.VarChar, 255, "showConsole"); oleDb.oleDbCommandUpdate.Parameters.Add("@period", OleDbType.VarChar, 255, "period"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); oleDb.ExecuteFill("Settings"); oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"] = DataConfig.autoUpdate.ToString(); oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"] = DataConfig.showConsole.ToString(); oleDb.dataSet.Tables["Settings"].Rows[0]["period"] = DataConfig.period; if (oleDb.ExecuteUpdate("Settings")) { oleDb.Dispose(); Utilits.Console.Log("Сохранение настроек программы прошло успешно."); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(true); } else { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Настройки программы не сохранены.", false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] " + ex.Message.ToString(), false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }
void disposeDb() { if (oleDb != null) { oleDb.Dispose(); } if (sqlServer != null) { sqlServer.Dispose(); } }
public static bool SaveDatabaseSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [name], [localDatabase], [typeDatabase], [typeConnection], [serverConnection] FROM DatabaseSettings"; oleDb.oleDbCommandUpdate.CommandText = "UPDATE DatabaseSettings SET " + "[name] = @name, " + "[localDatabase] = @localDatabase, " + "[typeDatabase] = @typeDatabase, " + "[typeConnection] = @typeConnection, " + "[serverConnection] = @serverConnection " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandUpdate.Parameters.Add("@localDatabase", OleDbType.VarChar, 255, "localDatabase"); oleDb.oleDbCommandUpdate.Parameters.Add("@typeDatabase", OleDbType.VarChar, 255, "typeDatabase"); oleDb.oleDbCommandUpdate.Parameters.Add("@typeConnection", OleDbType.VarChar, 255, "typeConnection"); oleDb.oleDbCommandUpdate.Parameters.Add("@serverConnection", OleDbType.VarChar, 255, "serverConnection"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); oleDb.ExecuteFill("DatabaseSettings"); oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"] = DataConfig.localDatabase; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"] = DataConfig.typeDatabase; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"] = DataConfig.typeConnection; oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"] = DataConfig.serverConnection; oleDb.ExecuteUpdate("DatabaseSettings"); oleDb.Dispose(); Utilits.Console.Log("Сохранение настроек соединения с базой данных прошло успешно."); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(true); }catch (Exception ex) { oleDb.Error(); Utilits.Console.Log("[ОШИБКА] Сохранение настроек соединения с базой данных. " + ex.Message.ToString(), false, true); DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; return(false); } }
void FormUsersEditFormClosed(object sender, FormClosedEventArgs e) { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null) { oleDb.Dispose(); } if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null) { sqlServer.Dispose(); } Utilits.Console.Log(Text + ": закрыт."); DataForms.FClient.messageInStatus("..."); Dispose(); }
void FormPurchasePlanJournalFormClosed(object sender, FormClosedEventArgs e) { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null) { oleDb.Dispose(); } if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null) { sqlServer.Dispose(); } DataForms.FClient.messageInStatus("..."); Utilits.Console.Log(this.Text + ": закрыт"); Dispose(); DataForms.FPurchasePlanJournal = null; }
/* ================================================================================================= * РАЗДЕЛ: СОБЫТИЙ * ================================================================================================= */ void FormSelectUserFormClosed(object sender, FormClosedEventArgs e) { if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null) { oleDb.Dispose(); } if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null) { sqlServer.Dispose(); } if (DataConfig.programClose) { Application.Exit(); } }
public static void ReadSettings() { DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345"; OleDb oleDb; oleDb = new OleDb(DataConfig.configFile); try{ oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Settings"; oleDb.ExecuteFill("Settings"); if (oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"].ToString() == "True") { DataConfig.autoUpdate = true; } else { DataConfig.autoUpdate = false; } if (oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"].ToString() == "True") { DataConfig.showConsole = true; } else { DataConfig.showConsole = false; } DataConfig.period = oleDb.dataSet.Tables["Settings"].Rows[0]["period"].ToString(); oleDb.Dispose(); Utilits.Console.Log("[Настройки]: Настройки программы успешно загружены."); }catch (Exception ex) { oleDb.Error(); MessageBox.Show("[Настройки]: " + ex.ToString(), "Ошибка"); Application.Exit(); } DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; DataConfig.oledbConnectLineEnd = ""; DataConfig.oledbConnectPass = ""; }
void reportOleDb() { OleDb oleDb = null; try{ oleDb = new OleDb(DataConfig.localDatabase); oleDb.dataSet.Clear(); oleDb.oleDbCommandSelect.CommandText = getCommandSelectOleDb(); /* * oleDb.oleDbCommandSelect.CommandText = "SELECT " + * "OrderNomenclature.name " + * "FROM OrderNomenclature, Orders "+ * "WHERE (OrderNomenclature.counteragentName = '" + counteragentTextBox.Text + "') "+ * "AND (Orders.docCounteragent = '" + counteragentTextBox.Text + "') "+ * "AND (OrderNomenclature.docOrder = Orders.docNumber) " + * "AND (Orders.docDate BETWEEN #" + * dateTimePicker1.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "# AND #" + * dateTimePicker2.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "#) "; */ if (oleDb.ExecuteFill("OrderNomenclature")) { if (oleDb.dataSet.Tables.Count > 0) { dataGridView1.DataSource = oleDb.dataSet; dataGridView1.DataMember = oleDb.dataSet.Tables[0].TableName; settingsColumns(); } } }catch (Exception ex) { if (oleDb != null) { oleDb.Dispose(); } Utilits.Console.Log("[ОШИБКА]: " + ex.Message, false, true); } }
public void Dispose() { if (oleDbConnection != null) { if (oleDbDataReader != null) { oleDbDataReader.Close(); } oleDbConnection.Close(); oleDbCommand.Dispose(); oleDbConnection.Dispose(); } if (sqlConnection != null) { if (sqlDataReader != null) { sqlDataReader.Close(); } sqlConnection.Close(); sqlCommand.Dispose(); sqlConnection.Dispose(); } if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } if (sqlServer != null) { sqlServer.Dispose(); } if (sqlQuery != null) { sqlQuery.Dispose(); } }
void createOrdersOleDb() { Double sum = 0; Double amount = 0; Double price = 0; Double vat = 0; Double total = 0; OleDb oleDb = null; QueryOleDb oleDbQuery = null; OrderDoc orderDoc; try{ oleDb = new OleDb(DataConfig.localDatabase); foreach (Price plist in priceList) // Обход прайсов { sum = 0; amount = 0; price = 0; vat = 0; total = 0; /* Создание основной информации документа заказ */ orderDoc = new OrderDoc(); orderDoc.docDate = DateTime.Today.Date; orderDoc.docNumber = createDocNumber(); orderDoc.docName = "Заказ"; orderDoc.docCounteragent = plist.counteragentName; orderDoc.docAutor = DataConfig.userName; orderDoc.docSum = 0; orderDoc.docVat = 0; orderDoc.docTotal = 0; orderDoc.docPurchasePlan = docPPNumber; oleDb = new OleDb(DataConfig.localDatabase); oleDb.oleDbCommandSelect.CommandText = "SELECT " + "id, nomenclatureID, nomenclatureName, units, amount, " + "name, price, manufacturer, remainder, term, discount1, discount2, discount3, discount4, code, series, article, " + "counteragentName, counteragentPricelist, " + "docPurchasePlan, docOrder " + "FROM OrderNomenclature WHERE (docPurchasePlan = '" + docPPNumber + "' AND counteragentName = '" + plist.counteragentName + "')"; oleDb.oleDbCommandUpdate.CommandText = "UPDATE OrderNomenclature SET " + "nomenclatureID = @nomenclatureID, nomenclatureName = @nomenclatureName, units = @units, amount = @amount, " + "name = @name, price = @price, manufacturer = @manufacturer, remainder = @remainder, term = @term, " + "discount1 = @discount1, discount2 = @discount2, discount3 = @discount3, discount4 = @discount4, " + "code = @code, series = @series, article = @article, " + "counteragentName = @counteragentName, counteragentPricelist = @counteragentPricelist, " + "docPurchasePlan = @docPurchasePlan, docOrder = @docOrder " + "WHERE ([id] = @id)"; oleDb.oleDbCommandUpdate.Parameters.Add("@nomenclatureID", OleDbType.Integer, 10, "nomenclatureID"); oleDb.oleDbCommandUpdate.Parameters.Add("@nomenclatureName", OleDbType.VarChar, 255, "nomenclatureName"); oleDb.oleDbCommandUpdate.Parameters.Add("@units", OleDbType.VarChar, 255, "units"); oleDb.oleDbCommandUpdate.Parameters.Add("@amount", OleDbType.Double, 15, "amount"); oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name"); oleDb.oleDbCommandUpdate.Parameters.Add("@price", OleDbType.Double, 15, "price"); oleDb.oleDbCommandUpdate.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer"); oleDb.oleDbCommandUpdate.Parameters.Add("@remainder", OleDbType.Double, 15, "remainder"); oleDb.oleDbCommandUpdate.Parameters.Add("@term", OleDbType.Date, 15, "term"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount1", OleDbType.Double, 15, "discount1"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount2", OleDbType.Double, 15, "discount2"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount3", OleDbType.Double, 15, "discount3"); oleDb.oleDbCommandUpdate.Parameters.Add("@discount4", OleDbType.Double, 15, "discount4"); oleDb.oleDbCommandUpdate.Parameters.Add("@code", OleDbType.VarChar, 255, "code"); oleDb.oleDbCommandUpdate.Parameters.Add("@series", OleDbType.VarChar, 255, "series"); oleDb.oleDbCommandUpdate.Parameters.Add("@article", OleDbType.VarChar, 255, "article"); oleDb.oleDbCommandUpdate.Parameters.Add("@counteragentName", OleDbType.VarChar, 255, "counteragentName"); oleDb.oleDbCommandUpdate.Parameters.Add("@counteragentPricelist", OleDbType.VarChar, 255, "counteragentPricelist"); oleDb.oleDbCommandUpdate.Parameters.Add("@docPurchasePlan", OleDbType.VarChar, 255, "docPurchasePlan"); oleDb.oleDbCommandUpdate.Parameters.Add("@docOrder", OleDbType.VarChar, 255, "docOrder"); oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id"); if (oleDb.ExecuteFill("OrderNomenclature")) // получаем перечень номенклатуры ПЗ { if (oleDb.dataSet.Tables["OrderNomenclature"].Rows.Count <= 0) { continue; // пропускаем (нет номенклатуры по данному контрагенту) } foreach (DataRow row in oleDb.dataSet.Tables["OrderNomenclature"].Rows) { /* Привязываем к документу */ row["docOrder"] = orderDoc.docNumber; /* Вычисления */ price = (Double)row["price"]; amount = (Double)row["amount"]; sum += (price * amount); } /* Итоги вычислений */ sum = Math.Round(sum, 2); vat = sum * DataConstants.ConstFirmVAT / 100; vat = Math.Round(vat, 2); total = sum + vat; total = Math.Round(total, 2); orderDoc.docSum = sum; orderDoc.docVat = vat; orderDoc.docTotal = total; /* Создаём новый заказ */ oleDbQuery = new QueryOleDb(DataConfig.localDatabase); oleDbQuery.SetCommand("INSERT INTO Orders " + "(docDate, docNumber, docName, docCounteragent, " + "docAutor, docSum, docVat, docTotal, docPurchasePlan) " + "VALUES ('" + orderDoc.docDate + "', " + "'" + orderDoc.docNumber + "', " + "'" + orderDoc.docName + "', " + "'" + orderDoc.docCounteragent + "', " + "'" + orderDoc.docAutor + "', " + "" + Conversion.DoubleToString(orderDoc.docSum) + ", " + "" + Conversion.DoubleToString(orderDoc.docVat) + ", " + "" + Conversion.DoubleToString(orderDoc.docTotal) + ", " + "'" + orderDoc.docPurchasePlan + "')"); if (oleDbQuery.Execute()) { /* Обновляем журнал Заказов */ DataForms.FClient.updateHistory("Orders"); Utilits.Console.Log("Ввод на основании: создан Заказ №" + orderDoc.docNumber + " для План закупок №" + docPPNumber); /* Обновление номенклатуры ПЗ (добавляем номер документа Заказ) */ if (oleDb.ExecuteUpdate("OrderNomenclature")) { Utilits.Console.Log("Ввод на основании: План заказов №" + docPPNumber + " обновлён."); } else { if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } Utilits.Console.Log("[ОШИБКА] Ввод на основании: План закупок №" + docPPNumber + " не удалось одновить! Заказ №" + orderDoc.docNumber, false, true); MessageBox.Show("Не удалось обновить План закупок №" + docPPNumber + " Создание заказов прервано!", "Сообщение"); return; } } else { if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } Utilits.Console.Log("[ОШИБКА] Ввод на основании: Не удалось создать Заказ для План закупок №" + docPPNumber, false, true); MessageBox.Show("Не удалось создать Заказ для План закупок №" + docPPNumber, "Сообщение"); return; } } else { if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } Utilits.Console.Log("[ОШИБКА] Ввод на основании: Не удалось загрузить перечень номенклатуры из документа" + docPPNumber, false, true); MessageBox.Show("Не удалось загрузить перечень номенклатуры из документа" + docPPNumber + "" + Environment.NewLine + "Создание Заказов на основании Плана закупок невозможно!", "Сообщение"); return; } } }catch (Exception ex) { if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } Utilits.Console.Log("[ОШИБКА] Ввод на основании: " + ex.Message, false, true); } if (oleDb != null) { oleDb.Dispose(); } if (oleDbQuery != null) { oleDbQuery.Dispose(); } MessageBox.Show("План закупок №" + docPPNumber + " был успешно обработан!" + Environment.NewLine + "Заказы созданы в соответствии с выбранными прайс-листами и номенклатурой! ", "Сообщение"); }
public static bool Verification() { OleDb oleDb; oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Practice"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Practice"; if (!oleDb.ExecuteFill("Practice")) { return(false); } Forms.FMain.progressLoad(5); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Tests"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Tests"; if (!oleDb.ExecuteFill("Tests")) { return(false); } Forms.FMain.progressLoad(10); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "EngRusVocabulary"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM EngRusVocabulary"; if (!oleDb.ExecuteFill("EngRusVocabulary")) { return(false); } Forms.FMain.progressLoad(15); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "IrregularVerbs"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM IrregularVerbs"; if (!oleDb.ExecuteFill("IrregularVerbs")) { return(false); } Forms.FMain.progressLoad(20); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "ModalVerbs"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM ModalVerbs"; if (!oleDb.ExecuteFill("ModalVerbs")) { return(false); } Forms.FMain.progressLoad(30); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "RegularVerbs"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM RegularVerbs"; if (!oleDb.ExecuteFill("RegularVerbs")) { return(false); } Forms.FMain.progressLoad(40); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Pronouns"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Pronouns"; if (!oleDb.ExecuteFill("Pronouns")) { return(false); } Forms.FMain.progressLoad(45); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Articles"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Articles"; if (!oleDb.ExecuteFill("Articles")) { return(false); } Forms.FMain.progressLoad(50); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Nouns"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nouns"; if (!oleDb.ExecuteFill("Nouns")) { return(false); } Forms.FMain.progressLoad(55); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Adjective"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Adjective"; if (!oleDb.ExecuteFill("Adjective")) { return(false); } Forms.FMain.progressLoad(60); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Numeral"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Numeral"; if (!oleDb.ExecuteFill("Numeral")) { return(false); } Forms.FMain.progressLoad(65); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Adverb"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Adverb"; if (!oleDb.ExecuteFill("Adverb")) { return(false); } Forms.FMain.progressLoad(70); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Conditions"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Conditions"; if (!oleDb.ExecuteFill("Conditions")) { return(false); } Forms.FMain.progressLoad(75); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Preposition"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Preposition"; if (!oleDb.ExecuteFill("Preposition")) { return(false); } Forms.FMain.progressLoad(80); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Unions"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Unions"; if (!oleDb.ExecuteFill("Unions")) { return(false); } Forms.FMain.progressLoad(85); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Particles"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Particles"; if (!oleDb.ExecuteFill("Particles")) { return(false); } Forms.FMain.progressLoad(90); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "ModalWords"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM ModalWords"; if (!oleDb.ExecuteFill("ModalWords")) { return(false); } Forms.FMain.progressLoad(95); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "IntroductoryWords"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM IntroductoryWords"; if (!oleDb.ExecuteFill("IntroductoryWords")) { return(false); } Forms.FMain.progressLoad(98); oleDb.Dispose(); oleDb = new OleDb(Config.databaseFile); oleDb.dataSet.Clear(); oleDb.dataSet.DataSetName = "Interjections"; oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Interjections"; if (!oleDb.ExecuteFill("Interjections")) { return(false); } Forms.FMain.progressLoad(100); oleDb.Dispose(); return(true); }
public void Dispose() { oleDb.Dispose(); tables.Clear(); tables = null; }