XML > Dataset. Please, I need help. Thank You.

[Shapper]

Hello,

I have a XML file that includes the node <item>:
....
<title>...</title>
<url>...</url>
<item>
<title>title 01</title>
<description>description 01</description>
</item>
<item>
<title>title 02</title>
<description>description 02</description>
</item>
....
How to get all title and description values into a dataset or
datareader?

Thank You,
Miguel

[Craig Deelsnyder]

Shapper wrote:

Hello,

I have a XML file that includes the node <item>:
...
<title>...</title>
<url>...</url>
<item>
<title>title 01</title>
<description>description 01</description>
</item>
<item>
<title>title 02</title>
<description>description 02</description>
</item>
...
How to get all title and description values into a dataset or datareader?

Thank You,
Miguel

For a dataset, if you don't have a schema to give to it, you can tell it
to infer a schema (assuming your xml does follow the format a dataset
normally 'uses'):

http://samples.gotdotnet.com/quickst...apXMLData.aspx

if you had the schema:

http://samples.gotdotnet.com/quickst...etXMLData.aspx

a general primer on the subject:

http://samples.gotdotnet.com/quickst...MLDataSet.aspx

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[Prakash.NET]

Use dataset.readxml

"Shapper" wrote:

Hello,

I have a XML file that includes the node <item>:
....
<title>...</title>
<url>...</url>
<item>
<title>title 01</title>
<description>description 01</description>
</item>
<item>
<title>title 02</title>
<description>description 02</description>
</item>
....
How to get all title and description values into a dataset or
datareader?

Thank You,
Miguel

[Shapper]

Hello,

I know dataset.readxml gets all the data from the xml file and places it
in the dataset. The problem is I don't want to take all data from the
XML file.
I only want to take the data which is inside the <item> nodes.

You can see in my XML file example I have some nodes, for example,
<title> and <url> which I don't want to place in the dataset.

I can't understand how to do this.

Can someone help me out?

Thanks,
Miguel

"Prakash.NET" <Pr********@discussions.microsoft.com> wrote in message
news:Pr********@discussions.microsoft.com:

Use dataset.readxml

"Shapper" wrote:

Hello,

I have a XML file that includes the node <item>:
....
<title>...</title>
<url>...</url>
<item>
<title>title 01</title>
<description>description 01</description>
</item>
<item>
<title>title 02</title>
<description>description 02</description>
</item>
....
How to get all title and description values into a dataset or
datareader?

Thank You,
Miguel

[Prakash.NET]

Hi,

DataSet.Reaxml has a overload called DataSet.ReadXml(XmlReader).
This XmlReader can be a XmlNodeReader. Use this node reader to read the
specific node in the xml file and pass it to ReadXML. I am sorry. I don't
have the time to write the code for you.[If this answer helps you, please
click "Yes" in "Was this post helpful to you?" link]

Prakash.NET

"Shapper" wrote:

Hello,

I know dataset.readxml gets all the data from the xml file and places it
in the dataset. The problem is I don't want to take all data from the
XML file.
I only want to take the data which is inside the <item> nodes.

You can see in my XML file example I have some nodes, for example,
<title> and <url> which I don't want to place in the dataset.

I can't understand how to do this.

Can someone help me out?

Thanks,
Miguel

"Prakash.NET" <Pr********@discussions.microsoft.com> wrote in message
news:Pr********@discussions.microsoft.com:

Use dataset.readxml

"Shapper" wrote:

Hello,

I have a XML file that includes the node <item>:
....
<title>...</title>
<url>...</url>
<item>
<title>title 01</title>
<description>description 01</description>
</item>
<item>
<title>title 02</title>
<description>description 02</description>
</item>
....
How to get all title and description values into a dataset or
datareader?

Thank You,
Miguel