private void GetDateBtn_Click(object sender, EventArgs e) { //check if the records exist if yes load them for editing if not create each record for each student // and load for edit AttendanceRecTableTableAdapter ada = new AttendanceRecTableTableAdapter(); DataTable dt = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text); if (dt.Rows.Count > 0) { // we have records we can edit DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; } else { // create record for each student here // get class students list StudentTableTableAdapter student_adaptor = new StudentTableTableAdapter(); DataTable dt_students = student_adaptor.GetDataByClassID((int)metroComboBox1.SelectedValue); foreach (DataRow row in dt_students.Rows) { // insert new rec for student ada.InsertQuery((int)row[0], (int)metroComboBox1.SelectedValue, dateTimePicker1.Text, "", row[1].ToString(), metroComboBox1.Text); } DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; } // TODO: This line of code loads data into the 'dataSet1.AttendanceRecTable' table. You can move, or remove it, as needed. this.attendanceRecTableTableAdapter.Fill(this.dataSet1.AttendanceRecTable); }
private void metroButton2_Click(object sender, EventArgs e) { AttendanceRecTableTableAdapter ada = new AttendanceRecTableTableAdapter(); foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value != null) { // update status ada.UpdateQueryStatus("", row.Cells[0].Value.ToString(), (int)metroComboBox1.SelectedValue, dateTimePicker1.Text); } } DataTable dt_new = ada.GetDataBy((int)metroComboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; }