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";
}
