private void UpdateStudentData() { studentDate = DbService.DataBaseShowStudentData(signInUser); tableRowContentList[0].Text = studentDate.StudyFiled; tableRowContentList[1].Text = studentDate.Degree.ToString(); tableRowContentList[2].Text = studentDate.Semestr.ToString(); tableRowContentList[3].Text = studentDate.IndexNumber.ToString(); }
public StudentDataView DataBaseShowStudentData(User user) { command = new MySqlCommand($"CALL wyswietl_dane_studenta('{user.UserID}')", this.conection); reader = command.ExecuteReader(); StudentDataView studentData = new StudentDataView(); if (reader.HasRows) { while (reader.Read()) { studentData.StudyFiled = reader.GetValue(0).ToString(); studentData.Degree = int.Parse(reader.GetValue(1).ToString()); studentData.Semestr = int.Parse(reader.GetValue(2).ToString()); studentData.IndexNumber = int.Parse(reader.GetValue(3).ToString()); } } reader.Close(); return(studentData); }