private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.Hide();
StudentAttendance bck = new StudentAttendance();
bck.Show();
}
private void btnadd_Click(object sender, EventArgs e)
{
if (Class1.stuId != -1)
{
SqlConnection newcon1 = new SqlConnection(con);
newcon1.Open();
string qu = "update StudentAttendance set AttendanceId='" + Convert.ToInt32(cmbAttendancedate.ValueMember) + "',StudentId='" + Convert.ToInt32(cmbStdreg.ValueMember) + "',AttendanceStatus='" + Convert.ToInt32(cmbAttendanceStatus.ValueMember) + "' where AttendanceId='" + Class1.atId + "' AND StudentId='" + Class1.stuId + "'";
SqlCommand newcom = new SqlCommand(qu, newcon1);
newcom.ExecuteNonQuery();
newcon1.Close();
Class1.stuId = -1;
}
else
{
SqlConnection newcon = new SqlConnection(con);
newcon.Open();
string qu = "insert into StudentAttendance(AttendanceId,StudentId,AttendanceStatus) values('" + Convert.ToInt32(cmbAttendancedate.SelectedValue) + "','" + Convert.ToInt32(cmbStdreg.SelectedValue) + "','" + Convert.ToInt32(cmbAttendanceStatus.SelectedValue) + "')";
SqlCommand newcom = new SqlCommand(qu, newcon);
newcom.ExecuteNonQuery();
newcon.Close();
}
this.Hide();
StudentAttendance bck = new StudentAttendance();
bck.Show();
}
