satya repaka

satya repaka

  • NA
  • 47
  • 12.8k

Conversion of dataset to xml format

Oct 28 2015 8:22 AM
Hi,
 
I am getting the data in dataset i.e only one record but that one record should display in below format. I want the dataset data in below format. Kindly help me as early as possible.
 
Here action data, Org data, persData are the custom tags.
 Other tags came from column names of the table.
 
  <actionData>
     <OfferDate>01102014</OfferDate>
     <ActionType>C1</ActionType>
     <ReasonforAction>  </ReasonforAction>
     <EmployeeID>55655655</EmployeeID>
     <Position>99999999</Position>
  </actionData>
  <orgData>
     <PersonnelArea>3308</PersonnelArea>
     <EmployeeGroup>9</EmployeeGroup>
     <EmployeeSubGroup></EmployeeSubGroup>
     <PersonnelArea_>BWSU</PersonnelArea_>
     <PayrollArea>99</PayrollArea>
     <Location></Location>
     <PayslipLocation>CDT</PayslipLocation>
  </orgData>
  <persData>
     <Title>1</Title>
     <LastName>Uattestsecond</LastName>
     <MiddleName></MiddleName>
     <FirstName>Kishor</FirstName>
     <Gender>1</Gender>
     <DOB>12091989</DOB>
     <Nationality>IN</Nationality>
     <Martial_Status>0</Martial_Status>
  </persData>

Answers (18)