private void PopulateStudentProfilePage(String studentNo) throws Exception {
try (IDatabaseConnection connection = DatabaseConnectionService.createDatabaseConnection()) {
try (IStatementExecutor stmtExecutor =
DatabaseConnectionService.createStatementExecutor(connection)) {
String student = String.format("SELECT * FROM Students WHERE studentNo ='%s' ", studentNo);
try (IQueryResultSet resultSet = stmtExecutor.executeQuery(student)) {
resultSet.moveToFirstRow();
SetRowValuesToTextboxControls(resultSet);
}
}
}
}
