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;
}