How to import data from xml file into a dataset

Question

0.00/5 (No votes)

See more:

I want to import data from a xml file into a dataset
this is my xml file

XML

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Persons>
  <Person Personid="10">
    <firstname>hi</firstname>
    <lastname>bye</lastname>
    <Birthday>1980 </Birthday>
    <Phones>
      <Fax>04</Fax>
      <Mobile>05</Mobile>
      <House>01</House>
    </Phones>
    <Emails>
      <Email>Email@site.com</Email>
    </Emails>
    <Webs>
      <Web>web.com</Web>
    </Webs>
  </Person>
</Persons>

when I use this code
dataset1.readxml(FilePath);

I have these tables in my dataset
Person,Phones,Emails,Webs
But I want to have FIVE (more) tables for Fax,Mobile,House,Email,Web
that ARE connected to "Person" table (Fax,Mobile,House are connected to Phones , Email to Emails AND Web to Webs)
How can I import the data like this?

thanks

Posted 17-Sep-10 14:40pm

mhs377

Updated 17-Sep-10 14:41pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-09-17T23:06:00

You have not mentioned anything on how you got this XML and if the structure can be changed at source or not. So, here is an option:
1. Creat a XSL file and perform a XSLT on this source XML to get a new XML where all the desired data is at same level.
2. Use this new XML for importing into dataset.

Currently, the issue is the hierarchy in which data is stored. If you need all of them to be stored as a table in dataset then you need to have all the desired data at same level. (Currently, Fax, Mobile, etc are one level deep in the XML tree.)

mhs377 · Answer 2 · 2010-09-18T21:52:00

I use this code to create the xml file
dataset1.writexml(FilePath);
the xml file can be changed
when the xml file is like below it has these table:
Person,Phones,Emails,Webs,Fax,Mobile,House,Email,Web

{ Emails connects to Email},{ Webs connects to Web } AND { Phones connects to fax,house and mobile }

<pre lang="xml">"xml"><?xml version="1.0" encoding="UTF-8" standalone="no"?>
<Persons>
  <Person Personid="10">
    <firstname>hi</firstname>
    <lastname>bye</lastname>
    <Birthday>1980 </Birthday>
    <Phones>
      <Fax>044</Fax>
      <Mobile>055</Mobile>
      <House>011</House>
      <Fax>04</Fax>
      <Mobile>05</Mobile>
      <House>01</House>
    </Phones>
    <Emails>
      <Email>Email1@site.com</Email>
      <Email>Email2@site.com</Email>
    </Emails>
    <Webs>
      <Web>web1.com</Web>
      <Web>web2.com</Web>
    </Webs>
  </Person>
</Persons>

I want to always have these tables
is there any way?

How to import data from xml file into a dataset

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0