//para a listBox
public void showTurmasProf()
{
if (!BDconnection.verifySGBDConnection())
{
return;
}
if (comboBox1.Items.Count == 0)
{
return;
}
String profSelected = (String)comboBox1.SelectedItem;
//MessageBox.Show(depSelected);
SqlCommand cmd = new SqlCommand("select * from SAA.TURMAS_POR_PROFESSOR ('" + profSelected + "') ", BDconnection.getConnection());
SqlDataReader reader = cmd.ExecuteReader();
listBox1.Items.Clear();
while (reader.Read())
{
ProfTurma A = new ProfTurma();
A.ID_turma = (int)reader["ID_turma"];
A.TNMEC = (int)reader["TMEC"];
A.Nome = reader["Nome_Prof"].ToString();
A.Email = reader["Email"].ToString();
listBox1.Items.Add(A);
}
BDconnection.getConnection().Close();
currentProfTurma = 0;
ShowTurma_Prof();
}
public void ShowTurma_Prof()
{
if (listBox1.Items.Count == 0 | currentProfTurma < 0)
{
return;
}
ProfTurma p = new ProfTurma();
p = (ProfTurma)listBox1.Items[currentProfTurma];
}