public frmConnectionManager(frmMain frmMain, ref proGEDIA.Utilities.Database database) { this.frmMain = frmMain; this.database = database; InitializeComponent(); }
private void cbServerName_SelectedIndexChanged(object sender, EventArgs e) { proGEDIA.Utilities.Database item = (proGEDIA.Utilities.Database)cbServerName.SelectedItem; tbServerPort.Text = item.serverPort; tbServiceName.Text = item.serviceName; tbDatabaseName.Text = item.databaseName; tbDatabaseFile.Text = item.databaseFile; cbAuthentication.SelectedIndex = item.userAuth ? 0 : 1; tbUserName.Text = item.userName; tbUserPassword.Text = item.userPass; cbRememberPassword.Checked = item.rememberPassword; }
public void Add(proGEDIA.Utilities.Database set) { foreach (var item in database.Select((value, i) => new { i, value })) { if (item.value.serverType == set.serverType && item.value.serverName == set.serverName && item.value.serverPort == set.serverPort) { database.RemoveAt(item.i); break; } } database.Add(set); }
public frmDataSelector(proGEDIA.Utilities.Database database, string db_name, ref DatabaseBackup backup_settings) { this.database = database; this.db_name = db_name; this.backup_settings = backup_settings; InitializeComponent(); for (int i = 0; i < dgvTableList.Columns.Count; i++) { dgvTableList.Columns[i].HeaderCell.Style.Alignment = DataGridViewContentAlignment.BottomCenter; } dgvTableList.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; dgvTableList.AllowUserToResizeRows = false; this.MinimumSize = this.Size; }
private void loadDatabases(proGEDIA.Utilities.Database db, ComboBox cb) { cb.Items.Clear(); switch (db.serverType.ToLower()) { case "mssql": if (db_source.mssqlCon != null && db_source.mssqlCon.State == ConnectionState.Open) { db_source.mssqlCon.Close(); } if (db_source.mssqlCon == null) { db_source.mssqlCon = new SqlConnection(); } db_source.mssqlCon.ConnectionString = db.GetConnectionString(); try { db_source.mssqlCon.Open(); } catch (Exception ex) { MessageBox.Show("Could not connect to database.\r\n" + ex.Message); return; } SqlCommand mssqlCom = db_source.mssqlCon.CreateCommand(); mssqlCom.CommandText = "SELECT name FROM sys.databases WHERE name NOT IN('master', 'tempdb', 'model', 'msdb') ORDER BY name"; try { SqlDataReader mssqlReader = mssqlCom.ExecuteReader(); while (mssqlReader.Read()) { cb.Items.Add(mssqlReader[0].ToString()); } mssqlReader.Close(); } catch (Exception ex) { MessageBox.Show("Could not get database list.\r\n" + ex.Message); } break; case "mysql": if (db_source.mysqlCon != null && db_source.mysqlCon.State == ConnectionState.Open) { db_source.mysqlCon.Close(); } if (db_source.mysqlCon == null) { db_source.mysqlCon = new MySqlConnection(); } db_source.mysqlCon.ConnectionString = db.GetConnectionString(); try { db_source.mysqlCon.Open(); } catch (Exception ex) { MessageBox.Show("Could not connect to database.\r\n" + ex.Message); return; } MySqlCommand mysqlCom = db_source.mysqlCon.CreateCommand(); mysqlCom.CommandText = "SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT LIKE '%schema' ORDER BY schema_name"; try { MySqlDataReader mysqlReader = mysqlCom.ExecuteReader(); while (mysqlReader.Read()) { cb.Items.Add(mysqlReader[0].ToString()); } mysqlReader.Close(); } catch (Exception ex) { MessageBox.Show("Could not get database list.\r\n" + ex.Message); } break; case "sqlite": if (db_source.sqliteCon != null && db_source.sqliteCon.State == ConnectionState.Open) { db_source.sqliteCon.Close(); } if (db_source.sqliteCon == null) { db_source.sqliteCon = new SQLiteConnection(); } db_source.sqliteCon.ConnectionString = db.GetConnectionString(); try { db_source.sqliteCon.Open(); } catch (Exception ex) { MessageBox.Show("Could not connect to database.\r\n" + ex.Message); return; } cb.Items.Add(db_source.serverName); cb.SelectedIndex = 0; break; } }