//редактирование аниме
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();
}