private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
offeredsem = radioButton1.Text;
}
else if (radioButton2.Checked == true)
{
offeredsem = radioButton2.Text;
}
try
{
if ((textBox1.Text == string.Empty) || (textBox2.Text == string.Empty) || (textBox3.Text == string.Empty) || (offeredsem == string.Empty) || (numericUpDown1.Text == string.Empty) || (numericUpDown2.Text == string.Empty) || (numericUpDown3.Text == string.Empty) || (numericUpDown4.Text == string.Empty))
{
MessageBox.Show("Warning:Required empty field:!", "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
cn.Open();
cm = new MySqlCommand("insert into tblsubject ( code, name, year, sem, lechrs, tutorialhrs, labhrs, evalutionhrs) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + offeredsem + "','" + numericUpDown1.Text + "','" + numericUpDown2.Text + "','" + numericUpDown3.Text + "','" + numericUpDown4.Text + "')", cn);
cm.ExecuteNonQuery();
cn.Close();
MessageBox.Show("Record has been successfully saved.", "Lecturer Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
button2.Enabled = false;
this.Hide();
ManageSub f2 = new ManageSub();
f2.Show();
}
catch (Exception ex)
{
cn.Close();
MessageBox.Show("Warning:" + ex.Message, "Waring", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void button6_Click(object sender, EventArgs e)
{
ManageSub f3 = new ManageSub();
f3.Show();
}