private void Guest_Load(object sender, EventArgs e) { SearchInCB(); Disease d = new Disease(); d.DiseaseLoadGuest(dataGridView1); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select NameDisease From Disease"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader["NameDisease"]); } reader.Close(); sqlConnection.Close(); /////////////////////////////////////////////////////////////////////// Forms f = new Forms(); f.FormGuestLoad(dataGridView2); cmd.CommandText = "Select FormName From Forms"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader1 = cmd.ExecuteReader(); while (reader1.Read()) { comboBox2.Items.Add(reader1["FormName"]); } reader1.Close(); sqlConnection.Close(); /////////////////////////////////////////////////////////////////////// Manufacturer man = new Manufacturer(); man.ManGuestLoad(dataGridView3); cmd.CommandText = "Select NameManufacturer From Manufacturer"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader2 = cmd.ExecuteReader(); while (reader2.Read()) { comboBox3.Items.Add(reader2["NameManufacturer"]); } reader2.Close(); sqlConnection.Close(); /////////////////////////////////////////////////////////////////////// Medicine med = new Medicine(); med.MedGuestLoad(dataGridView4); cmd.CommandText = "Select NameMedicine From Medicine"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader3 = cmd.ExecuteReader(); while (reader3.Read()) { comboBox4.Items.Add(reader3["NameMedicine"]); } reader3.Close(); sqlConnection.Close(); /////////////////////////////////////////////////////////////////////// cmd.CommandText = "Select NameSymptom From Symptom"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader4 = cmd.ExecuteReader(); while (reader4.Read()) { comboBox5.Items.Add(reader4["NameSymptom"]); } reader4.Close(); sqlConnection.Close(); ////////////////////////////////////////////////////////////// cmd.CommandText = "Select NameSymptom From Symptom"; cmd.Connection = sqlConnection; sqlConnection.Open(); SqlDataReader reader5 = cmd.ExecuteReader(); while (reader5.Read()) { comboBox7.Items.Add(reader5["NameSymptom"]); } reader5.Close(); sqlConnection.Close(); ///////////////////////////////////////////////////////////// sqlConnection.Open(); string query = "Select FormName, NameMedicine, NameManufacturer, Duration, Frequency, Age_From, Age_To, Healing, Dosage From((Forms inner join MedicineForms on Forms.ID_Form = MedicineForms.ID_Form)inner join Medicine on MedicineForms.ID_Medicine = Medicine.ID_Medicine) inner join Manufacturer on MedicineForms.ID_Manufacturer = Manufacturer.ID_Manufacturer "; List <string[]> data = new List <string[]>(); SqlCommand command = new SqlCommand(query, sqlConnection); SqlDataReader reader6 = command.ExecuteReader(); while (reader6.Read()) { data.Add(new string[9]); data[data.Count - 1][0] = reader6[0].ToString(); data[data.Count - 1][1] = reader6[1].ToString(); data[data.Count - 1][2] = reader6[2].ToString(); data[data.Count - 1][3] = reader6[3].ToString(); data[data.Count - 1][4] = reader6[4].ToString(); data[data.Count - 1][5] = reader6[5].ToString(); data[data.Count - 1][6] = reader6[6].ToString(); data[data.Count - 1][7] = reader6[7].ToString(); data[data.Count - 1][8] = reader6[8].ToString(); } foreach (string[] s in data) { dataGridView5.Rows.Add(s); } sqlConnection.Close(); //////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////// sqlConnection.Open(); string query2 = "select NameManufacturer, NameMedicine From (Manufacturer inner join MedManufacturer on Manufacturer.ID_Manufacturer = MedManufacturer.ID_Manufacturer) inner join Medicine on MedManufacturer.ID_Medicine = Medicine.ID_Medicine "; List <string[]> data2 = new List <string[]>(); SqlCommand command2 = new SqlCommand(query2, sqlConnection); SqlDataReader reader8 = command2.ExecuteReader(); while (reader8.Read()) { data2.Add(new string[2]); data2[data2.Count - 1][0] = reader8[0].ToString(); data2[data2.Count - 1][1] = reader8[1].ToString(); } foreach (string[] s in data2) { dataGridView7.Rows.Add(s); } sqlConnection.Close(); //////////////////////////////////////////////////////// sqlConnection.Open(); string query3 = "select NameSymptom From Symptom"; List <string[]> data3 = new List <string[]>(); SqlCommand command3 = new SqlCommand(query3, sqlConnection); SqlDataReader reader9 = command3.ExecuteReader(); while (reader9.Read()) { data3.Add(new string[1]); data3[data3.Count - 1][0] = reader9[0].ToString(); } foreach (string[] s in data3) { dataGridView8.Rows.Add(s); } sqlConnection.Close(); }
private void button1_Click(object sender, EventArgs e) { Medicine med = new Medicine(); med.InsertMedicine(textBox1, textBox2, mf.dataGridView4); }
private void MedicineForm_Load(object sender, EventArgs e) { Medicine med = new Medicine(); med.MedicineLoad(dataGridView4); }
private void button1_Click(object sender, EventArgs e) { Medicine med = new Medicine(); med.UpdateMedicine(comboBox1, textBox2, textBox1, mf.dataGridView4); }