public DB_MAIN() { if (postgres != null) postgres = null; postgres = this; gen_dataset(); if (Settings.get_setting("db_type").ToString() == "psql") DB_PSQL.Start_PSQL(); else if (Settings.get_setting("db_type").ToString() == "xml") DB_XML.Start_XML(); }
//init and connect to db //TODO: Make DB info readable from config file #region Initialization public DB_MAIN() { if (postgres != null) { postgres = null; } postgres = this; gen_dataset(); if (Settings.get_setting("db_type").ToString() == "psql") { DB_PSQL.Start_PSQL(); } else if (Settings.get_setting("db_type").ToString() == "xml") { DB_XML.Start_XML(); } }
private void MainWindow_Load(object sender, EventArgs e) { check_config(); database = new DB_MAIN(); //Setting up events database.db_dataset.Tables[table].RowChanged += db_changed; database.db_dataset.Tables[table].RowDeleted += db_changed; name_combo.SelectedIndexChanged += selected_changed; name_combo.TextUpdate += text_changed; name_combo.AutoCompleteSource = AutoCompleteSource.ListItems; name_combo.AutoCompleteMode = AutoCompleteMode.SuggestAppend; //Init grid client_grid.DataSource = database.db_dataset.Tables[table]; client_grid.Columns["id"].Visible = false; client_grid.Columns["name"].HeaderText = "Name"; client_grid.Columns["phone_number"].HeaderText = "Phone #"; client_grid.Columns["street_address"].HeaderText = "Address"; client_grid.Columns["postal_code"].HeaderText = "Postal"; client_grid.Columns["city"].HeaderText = "City"; client_grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; client_grid.ClearSelection(); client_grid.Sort(client_grid.Columns["name"], ListSortDirection.Ascending); client_grid.CellClick += client_grid_changed; viewToolStripMenuItem.DropDownOpening += viewToolStripMenuItem_Click; update_textbox(); }