//Update Question in DB private void QuestionEditButton_Click(object sender, EventArgs e) { AccessConnection.Open(); OleDbDataReader AccessReader = null; OleDbCommand command = new OleDbCommand("UPDATE Questions SET Question=@Question WHERE Id_ques=@Id_ques", AccessConnection); command.Parameters.AddWithValue("Question", QuestionTextBoxEdit.Text); command.Parameters.AddWithValue("Id_ques", QuestionComboBoxID.Text); { try { command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } QuestionComboBoxID.Items.Clear(); QuestionTextBoxEdit.Clear(); OleDbCommand NewCommand = new OleDbCommand("SELECT Id_ques FROM Questions", AccessConnection); try { AccessReader = NewCommand.ExecuteReader(); while (AccessReader.Read()) { QuestionComboBoxID.Items.Add(Convert.ToString(AccessReader["Id_ques"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } AccessConnection.Close(); }
//Update form private void обновитьToolStripMenuItem_Click(object sender, EventArgs e) { AccessConnection.Open(); DBConnectionStatus.Text = "Обновление"; OleDbDataReader AccessReader = null; while (GeneralDGV.Rows.Count > 1) { for (int i = 0; i < GeneralDGV.Rows.Count - 1; i++) { GeneralDGV.Rows.Remove(GeneralDGV.Rows[i]); } } DeleteTeacherComboBox.Items.Clear(); EditTeacherComboBox.Items.Clear(); DeleteGroupComboBox.Items.Clear(); EditGroupComboBox.Items.Clear(); QuestionComboBoxID.Items.Clear(); QuestionTextBoxEdit.Clear(); AvgListBoxTeacherQuestion.Items.Clear(); AvgListBoxTeacher.Items.Clear(); AvgListBoxTeacherGroup.Items.Clear(); AvgTextBox.Clear(); //GeneralDGV filling { this.resultTableAdapter1.Fill(this.databaseTIDataSet1.Result); this.resultTableAdapter.Fill(this.databaseTIDataSet.Result); } //TeacherTab filling { OleDbCommand command = new OleDbCommand("SELECT Teacher FROM Teachers GROUP BY Teacher", AccessConnection); try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { EditTeacherComboBox.Items.Add(Convert.ToString(AccessReader["Teacher"])); DeleteTeacherComboBox.Items.Add(Convert.ToString(AccessReader["Teacher"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } //QuestionTab Filling { OleDbCommand command = new OleDbCommand("SELECT Id_ques FROM Questions", AccessConnection); try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { QuestionComboBoxID.Items.Add(Convert.ToString(AccessReader["Id_ques"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } //GroupTab Filling { OleDbCommand command = new OleDbCommand("SELECT GroupName FROM Groups GROUP BY GroupName", AccessConnection); { try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { EditGroupComboBox.Items.Add(Convert.ToString(AccessReader["GroupName"])); DeleteGroupComboBox.Items.Add(Convert.ToString(AccessReader["GroupName"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } } //AVG Filling { //GeneralAvg { OleDbCommand command = new OleDbCommand("SELECT ROUND(AVG(Mark),2) AS MarkAVG FROM Result", AccessConnection); { try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { AvgTextBox.Text = Convert.ToString(AccessReader["MarkAVG"]); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } } //TeacherAvg { OleDbCommand command = new OleDbCommand("SELECT Teacher, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY Teacher", AccessConnection); { try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { AvgListBoxTeacher.Items.Add(Convert.ToString(AccessReader["Teacher"]) + ": " + Convert.ToString(AccessReader["MarkAVG"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } } //TeacherGroupAvg { OleDbCommand command = new OleDbCommand("SELECT Teacher, GroupName, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY GroupName, Teacher", AccessConnection); { try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { AvgListBoxTeacherGroup.Items.Add(Convert.ToString(AccessReader["Teacher"]) + " - " + Convert.ToString(AccessReader["GroupName"]) + ": " + Convert.ToString(AccessReader["MarkAVG"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } } //QuestionAvg { OleDbCommand command = new OleDbCommand("SELECT Teacher, Id_ques, ROUND(AVG(Mark),2) AS MarkAVG FROM [Result] GROUP BY Teacher, Id_ques", AccessConnection); { try { AccessReader = command.ExecuteReader(); while (AccessReader.Read()) { AvgListBoxTeacherQuestion.Items.Add(Convert.ToString(AccessReader["Teacher"]) + " - Вопрос #" + Convert.ToString(AccessReader["Id_ques"]) + ": " + Convert.ToString(AccessReader["MarkAVG"])); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (AccessReader != null) { AccessReader.Close(); } } } } } AccessConnection.Close(); DBConnectionStatus.Text = "Подключено"; }