private List<Observation> queryObservation(string dataSetID, string DataBase, string insertDateStrg) { List<Observation> observations = new List<Observation>(); string mySelectQuery = "select obsid, data, deleted, newest"; mySelectQuery += " from explorer.observation"; mySelectQuery += " where datasetid = " + dataSetID; mySelectQuery += " and insertdate = '" + insertDateStrg + "';"; DB2Connection connect = new DB2Connection(DataBase); DB2Command myCommand = new DB2Command(mySelectQuery, connect); connect.Open(); DB2DataReader myReader = myCommand.ExecuteReader(); while (myReader.Read()) { Observation observation = new Observation(); observation.obsid = myReader.GetInt64(0); observation.data = new XmlDocument(); observation.data.LoadXml(myReader.GetString(1)); observation.deleted = myReader.GetChar(2); observation.newest = myReader.GetChar(3); observations.Add(observation); } myReader.Close(); connect.Close(); return observations; }