private void FormAlun_Turmas_Load()
{
if (!BDconnection.verifySGBDConnection())
{
return;
}
if (comboBoxT.Items.Count == 0)
{
return;
}
String turmaSelected = (String)comboBoxT.SelectedItem;
//MessageBox.Show(depSelected); //TROCAR AQU!!!
SqlCommand cmd = new SqlCommand("select * from SAA.ALUNOS_TURMA_Y (" + Int32.Parse(turmaSelected) + ") ", BDconnection.getConnection());
SqlDataReader reader = cmd.ExecuteReader();
listBox2.Items.Clear();
while (reader.Read())
{
relAlunosTurma B = new relAlunosTurma();
B.ID_turma = (int)reader["ID_turma"];
B.TNMEC = (int)reader["NMEC"];
B.Idade = (int)reader["Idade"];
B.nome_Prof = reader["Nome"].ToString();
B.Email = reader["Email"].ToString();
B.RegEstudo = reader["RegimeEstudo"].ToString();
listBox2.Items.Add(B);
}
BDconnection.getConnection().Close();
currentT = 0;
ShowTurma_Prof();
}
public void ShowTurma_Prof()
{
if (listBox2.Items.Count == 0 | currentT < 0)
{
return;
}
relAlunosTurma p = new relAlunosTurma();
p = (relAlunosTurma)listBox2.Items[currentT];
}