private void button3_Click(object sender, EventArgs e) { String dt = AddSotr.Text; String ti = AddVrem.Text; String ui = Mesto.Text; String zi = AddRab.Text; datacon db = new datacon(); MySqlCommand command = new MySqlCommand("INSERT INTO `rab`(sotrudnik, vremya, mesto, vidrab) values (@dt, @ti, @ui, @zi)", db.GetConnection()); command.Parameters.Add("@dt", MySqlDbType.VarChar).Value = dt; command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti; command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui; command.Parameters.Add("@zi", MySqlDbType.VarChar).Value = zi; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Ошибка"); } db.closeConnection(); button1.PerformClick(); }
private void button2_Click(object sender, EventArgs e) { if (checkBox1.Checked == true) { String ti = name.Text; String ui = pass.Text; datacon db = new datacon(); MySqlCommand command = new MySqlCommand("INSERT INTO `admins`(login, password) values (@ti, @ui)", db.GetConnection()); command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti; command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Пользователь добавлен"); } else { MessageBox.Show("Ошибка"); } db.closeConnection(); } else { String ti = name.Text; String ui = pass.Text; datacon db = new datacon(); MySqlCommand command = new MySqlCommand("INSERT INTO `user`(login, password) values (@ti, @ui)", db.GetConnection()); command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti; command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Пользователь добавлен"); } else { MessageBox.Show("Ошибка"); } db.closeConnection(); } }