private void btnLogin_Click(object sender, EventArgs e) { if (cmbDatabase.SelectedIndex == 0) { MessageBox.Show("Pilih database!!"); return; } string username = txtUsername.Text; string password = txtPassword.Text; string server = txtServer.Text; FrmMain.jenisDatabase = cmbJenisDatabase.Text; if (cmbJenisDatabase.Text == "SQLSERVER") { koneksiSqlServer = new LibraryFramework.DatabaseSqlServer.Koneksi(username, password, server, cmbDatabase.Text); dataDatabaseSqlServer = new DataDatabaseSqlServer(koneksiSqlServer.Con); il.refreshSqlServer(dataDatabaseSqlServer.getTableName(), koneksiSqlServer); } else { koneksiMySql = new LibraryFramework.DatabaseMySql.Koneksi(username, password, server, cmbDatabase.Text); dataDatabaseMySql = new DataDatabaseMySql(koneksiMySql.Con); il.refreshMySql(dataDatabaseMySql.getTableName(cmbDatabase.Text), koneksiMySql, cmbDatabase.Text); } Close(); }
public void refreshSqlServer(DataTable dtb, LibraryFramework.DatabaseSqlServer.Koneksi kon) { lstTable.Items.Clear(); foreach (DataRow row in dtb.Rows) { lstTable.Items.Add(row["table_name"].ToString()); } this.konSqlServer = kon; dataDatabaseSqlServer = new DataDatabaseSqlServer(kon.Con); gvfSchema = new GridViewFunction(dgvSchema); lstTable.SelectedIndex = 0; }
private void btnSambungkan_Click(object sender, EventArgs e) { if (!CommonFunction.validasi(cmbJenisDatabase, txtServer, txtUsername, txtPassword)) { return; } string username = txtUsername.Text; string password = txtPassword.Text; string server = txtServer.Text; if (cmbJenisDatabase.Text == "SQLSERVER") { koneksiSqlServer = new LibraryFramework.DatabaseSqlServer.Koneksi(username, password, server, "master"); if (!koneksiSqlServer.Login()) { return; } dataDatabaseSqlServer = new DataDatabaseSqlServer(koneksiSqlServer.Con); CommonFunction.setCombo(cmbDatabase, dataDatabaseSqlServer.getDatabase(), "database_name", "database_name", 0, 0); } else { koneksiMySql = new LibraryFramework.DatabaseMySql.Koneksi(username, password, server, "test"); if (!koneksiMySql.Login()) { return; } dataDatabaseMySql = new DataDatabaseMySql(koneksiMySql.Con); CommonFunction.setCombo(cmbDatabase, dataDatabaseMySql.getDatabase(), "database", "database", 0, 0); } cmbJenisDatabase.Enabled = false; txtServer.Enabled = false; txtUsername.Enabled = false; txtPassword.Enabled = false; }