private void button1_Click(object sender, EventArgs e)
{
try
{
if ((textBox1.Text == string.Empty) || (textBox2.Text == string.Empty) || (comboBox1.Text == string.Empty) || (comboBox2.Text == string.Empty) || (comboBox3.Text == string.Empty) || (comboBox4.Text == string.Empty) || (textBox7.Text == string.Empty) || (comboBox5.Text == string.Empty))
{
MessageBox.Show("Warning:Required empty field:!", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
cn.Open();
cm = new MySqlCommand("insert into tbllecturer ( id, name, faculty, department, building, center, rank, level) values('" + textBox1.Text + "','" + textBox2.Text + "','" + comboBox1.Text + "','" + comboBox2.Text + "','" + comboBox3.Text + "','" + comboBox4.Text + "','" + textBox7.Text + "','" + comboBox5.Text + "')", cn);
cm.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record has been successfully saved.", "Lecturer Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
ManageLec f2 = new ManageLec();
f2.Show();
}
catch (Exception ex)
{
cn.Close();
MessageBox.Show("Warning:" + ex.Message, "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button4_Click(object sender, EventArgs e)
{
ManageLec f3 = new ManageLec();
f3.Show();
}