private void AddACompany_Load(object sender, EventArgs e) { connectionDB.ConnectionMySql(); string sqlQuery = "SELECT name FROM sector"; connectionDB.PutQueryIntoComboBox(sqlQuery, comboBoxSector, "name"); // Use method to add query into the comboBoxSector }
private void Form1_Load(object sender, EventArgs e) { this.Height = Screen.PrimaryScreen.WorkingArea.Height; this.Width = Screen.PrimaryScreen.WorkingArea.Width; dataGridViewList.DataSource = bindingSourceList; try { connectionDB.ConnectionMySql(); dataGridViewList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //dataGridViewList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; comboBoxChooseList.Items.Clear(); string sqlCommand = "SELECT TABLE_NAME as available FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbepm' AND TABLE_NAME LIKE 'list%'"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxChooseList, "available"); comboBoxSector.Items.Clear(); comboBoxSector.Items.Add("All companies"); sqlCommand = "SELECT name FROM sector ORDER BY name"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxSector, "name"); comboBoxCompany.Items.Clear(); sqlCommand = "SELECT DISTINCT name from company ORDER BY name"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxCompany, "name"); comboBoxSignature.Items.Clear(); sqlCommand = "SELECT name FROM user"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxSignature, "name"); comboBoxSignature.Text = Properties.Settings.Default.Signature; comboBoxEmail.Visible = false; } catch (Exception er) { MessageBox.Show(er.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ViewList_Load(object sender, EventArgs e) { dataGridViewList.DataSource = bindingSourceList; try { connectionDB.ConnectionMySql(); comboBoxList.Items.Clear(); dataGridViewList.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; string sqlCommand = "SELECT TABLE_NAME as available FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbepm' AND TABLE_NAME LIKE 'list%'"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxList, "available"); // Use method to add the query to the comboBoxList } catch (Exception er) { MessageBox.Show(er.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void DeleteACompanyForm_Load(object sender, EventArgs e) { connectionMySql connectionDB = new connectionMySql(); connectionDB.ConnectionMySql(); comboBoxCompany.Items.Clear(); comboBoxEmail.Items.Clear(); string sqlQuery = "SELECT DISTINCT name FROM company"; connectionDB.PutQueryIntoComboBox(sqlQuery, comboBoxCompany, "name"); }
private void comboBoxCompany_SelectedIndexChanged(object sender, EventArgs e) { connectionMySql connectionDB = new connectionMySql(); connectionDB.ConnectionMySql(); comboBoxEmail.Items.Clear(); comboBoxEmail.Text = ""; string sqlQuery = "SELECT email FROM company WHERE name='" + comboBoxCompany.Text + "'"; connectionDB.PutQueryIntoComboBox(sqlQuery, comboBoxEmail, "email"); comboBoxEmail.Text = comboBoxEmail.Items[0].ToString(); }
private void CompanyListForm_Load(object sender, EventArgs e) { connectionDB.ConnectionMySql(); dataGridViewCompanies.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; comboBoxSector.Items.Clear(); comboBoxSector.Items.Add("All companies"); comboBoxCompany.Items.Clear(); comboBoxEmail.Items.Clear(); ds.Clear(); try { string sqlQuery = "SELECT DISTINCT name FROM company"; connectionDB.PutQueryIntoComboBox(sqlQuery, comboBoxCompany, "name"); string sqlCommand = "SELECT name FROM sector"; connectionDB.PutQueryIntoComboBox(sqlCommand, comboBoxSector, "name"); sqlCommand = "SELECT * FROM company ORDER BY name"; dataAdapter = new MySqlDataAdapter(sqlCommand, connectionDB.getMyconnectionString()); // 3. fill in insert, update, and delete commands MySqlCommandBuilder cmdBldr = new MySqlCommandBuilder(dataAdapter); dataAdapter.Fill(ds, "bddmontijotest"); dataGridViewCompanies.DataSource = ds; dataGridViewCompanies.DataMember = "bddmontijotest"; } catch (Exception) { throw; } }
private void buttonDelete_Click(object sender, EventArgs e) { connectionMySql connectionDB = new connectionMySql(); connectionDB.ConnectionMySql(); try { if (comboBoxCompany.Text != null && comboBoxEmail.Text != null) { connectionDB.deleteCompany(comboBoxCompany.Text, comboBoxEmail.Text); } MessageBox.Show("Company deleted"); DeleteACompanyForm_Load(null, null); comboBoxCompany.Text = null; comboBoxEmail.Text = null; } catch { MessageBox.Show("Error : Can't delete from Database"); } }