public void leerTod() { Usuario usr; ag = AgenteBD.getAgente(); OleDbDataReader lector = ag.leer("SELECT * FROM Agenda;"); while (lector.Read()) { usr = new Usuario(lector.GetInt32(0), lector.GetString(1), lector.GetInt32(2)); lista.Add(usr); } lector.Close(); }
public void leer(Usuario usr) { ag = AgenteBD.getAgente(); int Id = usr.getId(); OleDbDataReader lector = ag.leer("SELECT * FROM Agenda WHERE Id='" + Id.ToString() + "';"); while (lector.Read()) { usr.setNom(lector.GetString(1)); usr.setNum(lector.GetInt32(2)); } lector.Close(); }