private void Results_Load(object sender, EventArgs e) { sdb.cn.Open(); st = new List <int>(); sdb.cmd.CommandText = "SELECT * FROM Results"; sdb.dr = sdb.cmd.ExecuteReader(); if (sdb.dr.HasRows) { while (sdb.dr.Read()) { //string text = sdb.dr["first_name"].ToString() + " " + sdb.dr["second_name"].ToString() + ", " + sdb.dr["group"].ToString(); st.Add(Convert.ToInt32(sdb.dr["ID"])); //listBox1.Items.Add(text); } } sdb.dr.Close(); sdb.cn.Close(); string request = "SELECT Students.second_name, Students.first_name, Students.group, Courses.course, Results.right_answers, Results.time_end FROM Students INNER JOIN (Courses INNER JOIN Results ON Courses.ID = Results.course_id) ON Students.ID = Results.student_id;"; result_query_table = sdb.query_table_return(request); dataGridView1.DataSource = result_query_table; dataGridView1.Columns[0].HeaderText = "Фамилия"; dataGridView1.Columns[1].HeaderText = "Имя"; dataGridView1.Columns[2].HeaderText = "Группа"; dataGridView1.Columns[3].HeaderText = "Курс"; dataGridView1.Columns[4].HeaderText = "Результат, %"; dataGridView1.Columns[5].HeaderText = "Дата прохождения"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
private void load_dgv1() { result_query_table = sdb.query_table_return("SELECT Answers.question_num, Answers.answer_num, Answers.is_right_answer FROM (Courses INNER JOIN Results ON Courses.ID = Results.course_id) INNER JOIN Answers ON Results.ID = Answers.result_id WHERE (((Results.student_id)=" + st[listBox1.SelectedIndex] + ") AND ((Results.course_id)=" + cs[listBox2.SelectedIndex] + "));"); dataGridView1.DataSource = result_query_table; dataGridView1.Columns[0].HeaderText = "Номер вопроса"; dataGridView1.Columns[1].HeaderText = "Номер ответа"; dataGridView1.Columns[2].HeaderText = "Верность"; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (dataGridView1.RowCount > 0) { sdb.cn.Open(); sdb.cmd.CommandText = "SELECT Results.right_answers FROM (Courses INNER JOIN Results ON Courses.ID = Results.course_id) INNER JOIN Answers ON Results.ID = Answers.result_id WHERE (((Results.student_id)=" + st[listBox1.SelectedIndex] + ") AND ((Results.course_id)=" + cs[listBox2.SelectedIndex] + "));"; label4.Text = Convert.ToInt32(sdb.cmd.ExecuteScalar()).ToString() + " %"; sdb.cn.Close(); } }