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];
*/
}
