private void button4_Click(object sender, EventArgs e) { if (TProdyct.Text.Length != 0 && TEDIzmerenia.Text.Length != 0) { int idprodyct = getProdyct(TProdyct.SelectedItem.ToString()); int idediz = getEdizmeren(TEDIzmerenia.SelectedItem.ToString()); string quest = $"UPDATE СоставБлюд SET ID_продукт = '{idprodyct}', Количество = '{TKol.Value}', Eд = '{idediz}' WHERE ID_зап = {idsostav}"; db.connect.Open(); OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect); dataAdapter.ExecuteNonQuery(); db.connect.Close(); DGSostav(idblydo); Form_Add w = new Form_Add(); w.Show(); } else { using (Form_Add_PoleNo form = new Form_Add_PoleNo()) { form.ShowDialog(); this.OnLoad(e); } } }
private void button1_Click(object sender, EventArgs e) { if (TProdyct.Text.Length != 0 && TEDIzmerenia.Text.Length != 0) { int idprodyct = getProdyct(TProdyct.SelectedItem.ToString()); int idediz = getEdizmeren(TEDIzmerenia.SelectedItem.ToString()); string quest = "INSERT INTO СоставБлюд (ID_блюд, ID_продукт, Количество, Eд, Рецепт) VALUES('" + idblydo + "','" + idprodyct + "','" + TKol.Value + "','" + idediz + "','" + TRecept.Text + "')"; db.connect.Open(); OleDbCommand dataAdapter = new OleDbCommand(quest, db.connect); dataAdapter.ExecuteNonQuery(); db.connect.Close(); DGSostav(idblydo); Form_Add formadd = new Form_Add(); formadd.ShowDialog(); } else { using (Form_Add_PoleNo form = new Form_Add_PoleNo()) { form.ShowDialog(); this.OnLoad(e); } } }