public void WritePollingPlaces(OracleCommand oCmd)
{
oCmd.CommandText = "select * from Table";
oCmd.CommandType = CommandType.Text;
OracleDataReader oDataReader = oCmd.ExecuteReader();
while (oDataReader.Read()) {
WriteStartElement("polling_location");
_oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
WriteStartElement("address");
if (oDataReader["location_name"] != DBNull.Value) {
_oXmlWriter.WriteElementString("location_name", oDataReader["location_name"].ToString());
}
_oXmlWriter.WriteElementString("line1", oDataReader["line1"].ToString());
_oXmlWriter.WriteElementString("city", oDataReader["city"].ToString());
_oXmlWriter.WriteElementString("state", oDataReader["state"].ToString());
_oXmlWriter.WriteElementString("zip", oDataReader["zip"].ToString());
WriteEndElement();
if (oDataReader["directions"] != DBNull.Value) {
_oXmlWriter.WriteElementString("directions", oDataReader["directions"].ToString());
}
if (oDataReader["polling_hours"] != DBNull.Value) {
_oXmlWriter.WriteElementString("polling_hours", oDataReader["polling_hours"].ToString());
}
WriteEndElement();
}
}