public List <Obc> ZobrazObce() { using (Connection) { using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = Connection; cmd.CommandText = "SELECT NAZEV FROM SEM_OBEC WHERE VIDIBLE=1 "; List <Obc> vystup = new List <Obc>(); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Obc tmp = new Obc(); tmp.Nazev = (string)reader.GetValue(0); vystup.Add(tmp); } reader.Close(); return(vystup); } } }
public List <Obc> ZobrazVsechnyObce() { using (Connection) { using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = Connection; cmd.CommandText = "SELECT nazev, vidible FROM SEM_OBEC"; List <Obc> vystup = new List <Obc>(); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Obc tmp = new Obc(); tmp.Nazev = (string)reader.GetValue(0); tmp.Visibility = (Decimal)reader.GetValue(1); vystup.Add(tmp); } reader.Close(); return(vystup); } } }