public int eliminaAlumno(Alumno a) { try { return(AlumnoCommands.eliminaAlumno(a)); } catch (Exception e) { Console.WriteLine(e.Message); MessageBox.Show(e.Message); return(-1); } }
public void buscaAlumno(int folio, System.Windows.Forms.TextBox[] cartilla) { try { cmd = AlumnoCommands.buscaAlumno(folio); //cmd = new SqlCommand(String.Format("SELECT * FROM alumno WHERE alumno.folio = '{0}'", folio), Connect()); dr = cmd.ExecuteReader(); String[] param = { "folio", "nombre", "sexo", "mail", "semestre", "programa" }; dr.Read(); for (int i = 0; i < 5; i++) { cartilla[i].Text = dr[param[i]].ToString(); Console.WriteLine(dr[param[i]].ToString()); } Console.WriteLine(dr[param[5]].ToString()); switch (dr[param[5]].ToString()) { case "1": cartilla[5].Text = "computacion"; break; case "2": cartilla[5].Text = "telecom"; break; case "3": cartilla[5].Text = "mecatronica"; break; case "4": cartilla[5].Text = "negocios"; break; case "5": cartilla[5].Text = "industrial"; break; } dr.Close(); } catch (Exception e) { Console.WriteLine(e.Message); MessageBox.Show(e.Message); } }