private void TutorWindow_Load(object sender, EventArgs e) { //uzupełniamy combo z przedmiotami: SqlConnection connect = this.tutorConnection.con; connect.Open(); string commandSubjects = "SELECT sub.subject_name " + "FROM dbo.Subjects sub " + "INNER JOIN dbo.SubjectToTutors stt ON " + "sub.id = stt.subject_id " + "INNER JOIN dbo.Tutors ON " + "dbo.Tutors.id = stt.tutor_id " + "where dbo.Tutors.username = '******'"; SqlDataAdapter sda1 = new SqlDataAdapter(commandSubjects, connect); DataTable dt = new DataTable(); sda1.Fill(dt); foreach (DataRow row in dt.Rows) { comboBoxSubjects.Items.Add(row["subject_name"]); } connect.Close(); //uzupelnic datagrid jego ocenami + przedmiotami /*connect.Open(); * string commandMarks = "select m.mark_value[wartosc], " + * "m.student_id[index number], sub.subject_name[subject's name], " + * "concat(t.t_name, ' ', t.surname)[tutor], m.id[mark's id] " + * "from Marks m inner join Subjects sub on sub.id = m.subject_id " + * "left join SubjectToTutors stt on sub.id = stt.subject_id " + * "left join Tutors t on t.id = stt.tutor_id " + * "where t.username = '******'"; * SqlDataAdapter sda2 = new SqlDataAdapter(commandMarks, connect); * DataTable dt_marks = new DataTable(); * sda2.Fill(dt_marks); * dataGridView1.DataSource = dt_marks; * connect.Close();*/ UczelniaEntities db = new UczelniaEntities(); var query = from vm in db.View_Marks where vm.username == this.UsernameLabel.Text select new { vm.subject_name, vm.student_id, vm.mark_value }; var dataTable = query.ToList(); dataGridView1.DataSource = dataTable; //(nullowe wartosci tym bardziej wyswietlic left join lub riht) }
private void searchStudent(object sender, EventArgs e) { UczelniaEntities db = new UczelniaEntities(); int buff = Convert.ToInt32(this.textBoxStudentIndex.Text); var query = from vm in db.View_Marks where vm.username == this.UsernameLabel.Text && vm.student_id == buff select new { vm.subject_name, vm.student_id, vm.mark_value }; var dataTable = query.ToList(); dataGridView1.DataSource = dataTable; }
private void LoadTableToGrid(object sender, EventArgs e) { try { button1.Text = "Dodaj"; context = new UczelniaEntities(); if (comboBox1.Text == "tutors") { dataGridView1.DataSource = context.Tutors.ToList(); } else if (comboBox1.Text == "administrators") { dataGridView1.DataSource = context.Administrators.ToList(); } else if (comboBox1.Text == "students") { dataGridView1.DataSource = context.Students.ToList(); } else if (comboBox1.Text == "marks") { dataGridView1.DataSource = context.Marks.ToList(); } else if (comboBox1.Text == "subjects") { dataGridView1.DataSource = context.Subjects.ToList(); } else if (comboBox1.Text == "faculties") { dataGridView1.DataSource = context.Faculties.ToList(); } else if (comboBox1.Text == "studenttosubjects") { button1.Text = "Dodaj Stud<->Subject"; dataGridView1.DataSource = context.StudentToSubjects.ToList(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }