private void button1_Click(object sender, EventArgs e)
{
string q = "select * from student_record where std_batchcode='" + comboBox1.SelectedValue.ToString() + "'";
viewclass vc = new viewclass(q);
dataGridView1.DataSource = vc.showrecord();
}
private void button1_Click(object sender, EventArgs e)
{
q = "SELECT student_record.std_USN, student_record.std_name, student_record.std_batchcode, student_record.std_sem, student_record.std_sec, score.score, subjects.sub_name, set_exam.set_exam_date, subjects.sub_id FROM score INNER JOIN student_record ON score.stu_fk_id = student_record.std_USN and student_record.std_batchcode='" + comboBox1.SelectedValue.ToString() + "' INNER JOIN set_exam ON student_record.std_USN = set_exam.stu_id_fk INNER JOIN subjects ON score.exam_fk_id = subjects.sub_id AND set_exam.exam_id_fk = subjects.sub_id and subjects.sub_name='" + comboBox2.SelectedValue.ToString() + "'";
viewclass vc = new viewclass(q);
dataGridView1.DataSource = vc.showrecord();
}
private void button2_Click(object sender, EventArgs e)
{
insertclass ic = new insertclass();
ic.insert_setexam(System.DateTime.Now.ToShortDateString(), textBox1.Text, comboBox2.SelectedValue.ToString());
string q = "select * from set_exam";
viewclass vc = new viewclass(q);
dataGridView2.DataSource = vc.showrecord();
q = "select * from student_record where std_batchcode='" + comboBox1.SelectedValue.ToString() + "'";
viewclass vc2 = new viewclass(q);
dataGridView1.DataSource = vc2.showrecord();
}
private void setexam_Load(object sender, EventArgs e)
{
string q = "select * from student_record";
viewclass vc = new viewclass(q);
dataGridView1.DataSource = vc.showrecord();
SqlDataAdapter dadpter = new SqlDataAdapter("Select distinct std_batchcode from student_record", "Data Source=DESKTOP-2K3QFUN\\SARKARSQL;Initial Catalog=quizapp;Persist Security Info=True;User ID=sa;Password=qwerty1234");
DataSet dset = new DataSet();
dadpter.Fill(dset);
comboBox1.DataSource = dset.Tables[0];
comboBox1.DisplayMember = "std_batchcode"; //to display roll no.in combobox
comboBox1.ValueMember = "std_batchcode";
SqlDataAdapter dadpter2 = new SqlDataAdapter("select * from subjects", "Data Source=DESKTOP-2K3QFUN\\SARKARSQL;Initial Catalog=quizapp;Persist Security Info=True;User ID=sa;Password=qwerty1234");
DataSet dset2 = new DataSet();
dadpter2.Fill(dset2);
comboBox2.DataSource = dset2.Tables[0];
comboBox2.DisplayMember = "sub_name"; //to display roll no.in combobox
comboBox2.ValueMember = "sub_id";
}
