private void CheckAttendance_Load(object sender, EventArgs e)
{
string query = "select * from attendance where ID = '" + idee + "' ";
model.FeeCheck fd = new model.FeeCheck();
dataGridView1.DataSource = fd.datagrid(query);
}
private void ResultsStd_Load(object sender, EventArgs e)
{
string query = "select * from Result where ID = '" + identity + "' ";
model.FeeCheck fc = new model.FeeCheck();
dataGridView1.DataSource = fc.datagrid(query);
}
private void Attendance_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string query = "select * from attendance";
dataGridView1.DataSource = fc.datagrid(query);
}
private void StudentDetails_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string query = "select * from info where Role = '" + "Student" + "' ";
dataGridView1.DataSource = fc.datagrid(query);
}
private void FeesRecord_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string admin = "Admin";
string query = "select info.Name , fees.Jan , fees.Feb , fees.Mar , fees.Apr , fees.May , fees.Jun , fees.Jul , fees.Aug , fees.Sep , fees.Oct , fees.Nov , fees.Dec from info inner join fees on info.ID = fees.ID where fees.Role = '" + admin + "' ";
dataGridView1.DataSource = fc.datagrid(query);
}
private void FeeSubmit_Load(object sender, EventArgs e)
{
string query = "select * from info";
dataGridView1.DataSource = f.datagrid(query);
}