private void button5_Click(object sender, EventArgs e) { database db = new database("127.0.0.1", "root", "", "zarplatalab"); int id = Convert.ToInt32(comboBox1.SelectedValue); if (db.delete(id) == -1) { MessageBox.Show("error"); zagruzka(); } else { MessageBox.Show("ok"); zagruzka(); } }
public void zagruzka() { database db = new database("127.0.0.1", "root", "", "zarplatalab"); //comboBox1.; //comboBox1.Dispose(); comboBox1.DataSource = null; //comboBox1.Items.Clear(); comboBox1.DataSource = db.getTableInfo("SELECT zarplata.id, `name` FROM `zarplata` join `info` on `fio_id` = info.id"); comboBox1.DisplayMember = "name"; comboBox1.ValueMember = "id"; comboBox2.DataSource = db.getTableInfo("SELECT id, surname FROM info"); comboBox2.DisplayMember = "surname"; comboBox2.ValueMember = "id"; }