private void button1_Click(object sender, EventArgs e) { bool check = false; string name = textBox1.Text; string credits = textBox3.Text; string lectureH = textBox4.Text; string practiceH = textBox5.Text; string receiptH = textBox6.Text; string semester = comboBox2.Text; string Year = comboBox4.Text; string department = Department_combo.Text; string unit = Unit_combo.Text; string PrereqiD = PreReqID.Text; try { if (name != null && credits != null && lectureH != null && practiceH != null && receiptH != null && Year != null && semester != null && department != null && unit != null) { if (Int32.Parse(lectureH) > 0 & Int32.Parse(practiceH) > 0 & Int32.Parse(receiptH) > 0) // & Int32.Parse(Year) > 0) { check = db.InsertCourse(name, credits, lectureH, practiceH, receiptH, semester, Year, department, unit, PrereqiD); } } if (check) { MessageBox.Show("The course" + " " + name + " has been added successfully"); ClearAll(); } else { MessageBox.Show("Error occured!"); } } catch (Exception exp) { MessageBox.Show("Could not insert"); } finally { if (db.isconnected == true) { db.CloseConnection(); } } }