private void changeButton_Click(object sender, EventArgs e) { AddMedicineUse form = new AddMedicineUse(); string myQuery = "SELECT Название FROM Лекарства WHERE Код = " + Convert.ToInt32(dataGridView1.CurrentRow.Cells[2].Value); string s1 = GetStringValue(myQuery); form.SetBoxes(Convert.ToString(dataGridView1.CurrentRow.Cells[1].Value), s1, Convert.ToString(dataGridView1.CurrentRow.Cells[3].Value)); form.ShowDialog(); string s2 = form.GetUsage(); string s3 = form.GetMedicine(); myQuery = "SELECT Код FROM Лекарства WHERE [Название] = '" + s3 + "'"; s3 = GetStringValue(myQuery); string s4 = form.GetPeriod(); dataGridView1.CurrentRow.Cells[1].Value = s2; dataGridView1.CurrentRow.Cells[2].Value = s3; dataGridView1.CurrentRow.Cells[3].Value = s4; BindingSource bs = new BindingSource(ds, "НазначениеЛекарств"); dataGridView1.DataSource = bs; UpdateGrid(); }
private void AddButton_Click(object sender, EventArgs e) { AddMedicineUse form = new AddMedicineUse(); form.ShowDialog(); string medicine = form.GetMedicine(); string usage = form.GetUsage(); string period = form.GetPeriod(); LoadGrid(); oleDbConnection1.Open(); string myQuery = "SELECT Код FROM Лекарства WHERE [Название] = '" + medicine + "'"; OleDbCommand myCommand = new OleDbCommand(myQuery, oleDbConnection1); OleDbDataReader myReader; myReader = myCommand.ExecuteReader(); myReader.Close(); try { medicine = myCommand.ExecuteScalar().ToString(); } catch (Exception) { } oleDbConnection1.Close(); if (medicine != "" && usage != "" && period != "") { try { oleDbConnection1.Open(); oleDbDataAdapter1.InsertCommand.CommandText = "INSERT INTO [НазначениеЛекарств] (idНазначения, idЛекарств, Период) VALUES ('" + medicine + "', '" + usage + "', '" + period + "')"; oleDbDataAdapter1.InsertCommand.ExecuteNonQuery(); } catch (Exception) { }; } oleDbConnection1.Close(); UpdateGrid(); }