private void RemarkForm_Load(object sender, EventArgs e) { duombaze = new UserDB(); int studentid = 0; List <Student> studentlist = duombaze.GetStudent(); List <Grade> gradelist = duombaze.GetGrade(); int gradetest = 0; foreach (Student student in studentlist) { if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname) { studentid = student.Id; } } foreach (Grade grade in gradelist) { if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento { gradetest = grade.Gradenumber; GradeControl gg = new GradeControl(grade); flowLayoutPanel1.Controls.Add(gg); } } }
private void RemarkForm_Load(object sender, EventArgs e) { duombaze = new UserDB(); int studentid = 0; List <Student> studentlist = duombaze.GetStudent(); List <Grade> gradelist = duombaze.GetGrade(); int gradetest = 0; foreach (Student student in studentlist) { if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname) { studentid = student.Id; } } foreach (Grade grade in gradelist) { if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento { gradetest = grade.Gradenumber; GradeControl gg = new GradeControl(grade); flowLayoutPanel1.Controls.Add(gg); } } Console.WriteLine(gradetest); /* var select = "SELECT * FROM grade"; * conn = new SqlConnection(@"Server=.;Database=AcademicDB;Trusted_Connection=true;"); * var dataAdapter = new SqlDataAdapter(select, conn); * var commandBuilder = new SqlCommandBuilder(dataAdapter); * var ds = new DataSet(); * dataAdapter.Fill(ds); * dataGridView1.ReadOnly = true; * dataGridView1.DataSource = ds.Tables[0]; */ }