private void butAdd_Click(object sender, EventArgs e) { string sql = "insert into MEDICAMENT values('" + textBoxIDMed.Text + "','" + textBoxName.Text + "')"; ConnectionDB.Insert(sql); Close(); }
private void button1_Click(object sender, EventArgs e) { int dis_id = int.Parse(ConnectionDB.SelectOne("select max(ID_disease) from disease")); dis_id++; string sql = "insert into disease values('" + dis_id + "','" + textBox1.Text + "')"; ConnectionDB.Insert(sql); Close(); }
private void butAdd_Click(object sender, EventArgs e) { int cat_id = int.Parse(ConnectionDB.SelectOne("select max(ID_symptom) from symptom")); cat_id++; string sql = "insert into category values('" + cat_id + "','" + textBoxName.Text + "')"; ConnectionDB.Insert(sql); Close(); }
private void button1_Click(object sender, EventArgs e) { int sym_id = int.Parse(ConnectionDB.Select("select max(ID_symptom) from symptom")); sym_id++; string sql = "insert into symptom values('" + sym_id + "','" + textBox1.Text + "')"; ConnectionDB.Insert(sql); Close(); }
private void butAdd_Click(object sender, EventArgs e) { // (1,3,'парацетамол','15/10/19',null) string cat_id = comboBoxIDCat.SelectedItem.ToString().Split(' ')[0]; string sym_id = comboBoxDis.SelectedItem.ToString().Split(' ')[0]; string dis_id = comboBoxSym.SelectedItem.ToString().Split(' ')[0]; int med_id = int.Parse(ConnectionDB.SelectOne("select max(ID_med) from medicament")); med_id++; string sql = "insert into MEDICAMENT values(" + med_id + "," + cat_id + ",'" + textBoxName.Text + "','" + dateTimePicker1.Value.ToString("dd/MM/yy") + "', null)"; string sql1 = "insert into medicament_disease values(" + med_id + "," + dis_id + ")"; string sql2 = "insert into MEDICAMENT values(" + med_id + "," + sym_id + ")"; ConnectionDB.Insert(sql); ConnectionDB.Insert(sql1); ConnectionDB.Insert(sql2); Close(); }