Mapping an xml schema to a different dataset schema

[Philip Poole]

Hello everyone,

I have just started to use Xml in .net so excuse me if this is a simple
question.

I have an Xml docuement that contains data in the following format: -

<SearchResult xmlns="http://tempuri.org/XMLFile1.xsd">
<QueryInformation>
<ActualQueryString />
<TotalResults />
<ResultsPerPage />
<SearchTime />
<StoppedWords />
<TheasurusWords />
<StemmedWords />
<SortMethod />
<Messages />
</QueryInformation>
<Results id="0">
<Result>
<MediaId/>
<Text/>
<OriginalFilename/>
<title/>
<Keywords/>
<abstract/>
<UploadDate/>
<FileSize/>
<UploadedBy/>
<MediaType/>
<LastUpdatedDate/>
</Result>

Where result is repeated many times, I want to load this data into a
dataset, however I am only interested in storing the data inside the
<results> tag

Therefore the Columns of my table would be : -

MediaId
Text
OriginalFilename
title
Keywords
abstract
UploadDate
FileSize
UploadedBy
MediaType
LastUpdatedDate

I can create a schema for each of these structure but how can I map the one
structure to the other tell the dataset to ingornre all other tags and
atrributes!

Thankyou for your help in adavance

Philip