Get XML from Database RSS

• • Reply
  

  kouts1

  Member

  52 Points

  43 Posts

  Get XML from Database

  Feb 24, 2012 02:05 PM|LINK

  Hi guys!

   

  I have a problem where I am not sure how to go about this.

  I need to pull data from an sqldatasource, populate a gridview and then be able to export the data into an xml file:

  I need this xml schema output:

  <qphem>

  <qpe_case>

  <qpe_visit>

  <case_id>EM12345623TC2</case_id>

  <encounter_patient_class>IMP</encounter_patient_class>

  <admission_date>07/10/2011</admission_date>

  <admission_time>10:34</admission_time>

  <discharge_date>07/15/2011</discharge_date>

  <discharge_time>10:10</discharge_time>

  </qpe_visit>

  <qpe_patient>

  <facility_patient_id>HEM5643221TC2</facility_patient_id>

  <birthdate>8/5/1970</birthdate>

  </qpe_patient>

  <qpe_assessment>

  <ed_arrival_date>07/10/2011</ed_arrival_date>

  <ed_arrival_time>08:23</ed_arrival_time>

  <ed_patient_class>EMER</ed_patient_class>

  <admit_decision_date>07/11/2011</admit_decision_date>

  <admit_decision_time>12:54</admit_decision_time>

  <departure_date>07/12/2011</departure_date>

  <departure_time>15:21</departure_time>

  </qpe_assessment>

  <qpe_location>

  <location_code>1104-9</location_code>

  <location_code>1145-2</location_code>

  <location_code>112823003</location_code>

  </qpe_location>

  <qpe_principal_snomed_diagnosis>

  <principal_snomed_diag_code>1386000</principal_snomed_diag_code>

  <principal_snomed_problem_status>55589000</principal_snomed_problem_status>

  <principal_snomed_diag_date>07/10/2011</principal_snomed_diag_date>

  <principal_snomed_diag_time>10:10</principal_snomed_diag_time>

  </qpe_principal_snomed_diagnosis>

  </qpe_case>

  </qphem>

   

  -----------------------

  any help would be appreciated!

  Thanks!

• • Reply
  

  dinakaran

  Member

  625 Points

  216 Posts

  Re: Get XML from Database

  Feb 24, 2012 03:06 PM|LINK

  hi,

  follow this code snippet

  XmlDocument xmldoc = new XmlDocument();
  
   //Create a new node
  
              XmlElement itemelement = null;
   XmlElement xmlsub = null;
  
  itemelement = xmldoc.CreateElement("root");
   xmlstid = xmldoc.CreateElement("sub");
                  xmlstid.InnerText = "mess";
  
  
  
  itemelement.AppendChild(xmlstid);
  xmldoc.DocumentElement.AppendChild(itemelement);
  xmldoc.Save(filepath);

  i hope it helps you.

  • Marked as answer by decker dong - msft on Mar 01, 2012 01:56 AM
• • Reply
  

  kouts1

  Member

  52 Points

  43 Posts

  Re: Get XML from Database

  Feb 24, 2012 03:59 PM|LINK

  Great!

  But how would I use that code after I populated a gridview or Dataset?

   

  Thanks!

• • Reply
  

  dinakaran

  Member

  625 Points

  216 Posts

  Re: Get XML from Database

  Feb 25, 2012 02:38 AM|LINK

  Hi,

  You need to read the data from data set each row and column values using foreach 

  and then you have generate xml based on your requirement.

  • Marked as answer by kouts1 on Feb 27, 2012 03:11 PM