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();
}
}