//редактирование аниме private void button11_Click(object sender, EventArgs e) { if (MessageBox.Show("Действительно редактировать аниме?", "Подтвердите редактирование", MessageBoxButtons.YesNo) == DialogResult.Yes) { try { //получаем ид редактируемого аниме и отправляем на редакцию connection.Open(); OleDbCommand command = new OleDbCommand(); command.Connection = connection; command.CommandText = "SELECT id FROM Anime_info WHERE Anime_info.name_an='" + dataGridView7[0, dataGridView7.CurrentRow.Index].Value.ToString() + "' AND Anime_info.tip_an='" + dataGridView7[1, dataGridView7.CurrentRow.Index].Value.ToString() + "'"; //AND collSer_an=" + dataGridView7[2, dataGridView7.CurrentRow.Index].Value.ToString() + " AND ogranich_an='" + dataGridView7[3, dataGridView7.CurrentRow.Index].Value.ToString() + "'"; if (read != "") { command.CommandText = "SELECT id FROM Anime_info WHERE Anime_info.name_an='" + dataGridView2[0, dataGridView2.CurrentRow.Index].Value.ToString() + "' "; } int idd = 0; OleDbDataReader reader = command.ExecuteReader(); while (reader.Read()) { idd = int.Parse(reader["id"].ToString()); } connection.Close(); frm5 = new Form4_newAnime(idd); frm5.Show(); read = ""; } catch (Exception ex) { MessageBox.Show("FAIL " + ex); connection.Close(); } } }
//окно добавления нового аниме private void button6_Click(object sender, EventArgs e) { frm5 = new Form4_newAnime(); frm5.Show(); }