public void WriteLocalities(OracleCommand oCmd)
{
oCmd.CommandText = "select * from Table";
oCmd.CommandType = CommandType.Text;
OracleDataReader oDataReader = oCmd.ExecuteReader();
while (oDataReader.Read()) {
WriteStartElement("locality");
_oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
_oXmlWriter.WriteElementString("name", oDataReader["name"].ToString());
_oXmlWriter.WriteElementString("state_id", oDataReader["state_id"].ToString());
_oXmlWriter.WriteElementString("type", oDataReader["type"].ToString());
WriteEndElement();
}
}