private void btnClear_Click(object sender, EventArgs e)
{
/* clearing the fields*/
state();
gpNumbertxbx.Clear();
SbgpNumbertxbx.Clear();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
con.Open();
/* Generating the GroupID and the SubGroupID*/
string GroupID = academicyrcmbx.Text + "." + programmecmbox.Text + "." + gpNumbertxbx.Text;
string SubGroupID = academicyrcmbx.Text + "." + programmecmbox.Text + "." + gpNumbertxbx.Text + "." + SbgpNumbertxbx.Text;
if (ValidateChildren(ValidationConstraints.Enabled) &&
academicyrcmbx.Text == "" || programmecmbox.Text == "" || gpNumbertxbx.Text == "" || SbgpNumbertxbx.Text == "")
{
MessageBox.Show("Please fill out the Empty Field(s)",
"Unable to Submit", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
}
else
{
/* Inserting data into the database*/
cmd = new SqlCommand("insert into Student_Management (AcademicYearSemester,Programme,GroupNumber,SubGroupNumber,GroupID,SubGroupID)values('" + academicyrcmbx.Text + "','" + programmecmbox.Text + "','" + gpNumbertxbx.Text + "','" + SbgpNumbertxbx.Text + "','" + GroupID + "','" + SubGroupID + "')", con);
cmd.ExecuteNonQuery();
gpNumbertxbx.Clear();
SbgpNumbertxbx.Clear();
con.Close();
Showdata();
}
con.Close();
}