Showing an extract of XML file in a datagrid

G

Guest

I'm trying to list a portion of an XML file onto a web page in a datagrid. Showing the whole XML file is no problem, but I'm having trouble working out how to show a specific extract. I'm sure this is simple really

For the sake of the post I've crated a very simple XML file for discussion

<?xml version="1.0" encoding="UTF-8"?><games><game><date>17/05/2004</date><team>1st team</team><result>2:0</result></game><game><date>16/05/2004</date><team>Youth</team><result>8:9</result></game></games

Basically I don't know how to perform queries such as.
a) Select all results for the youth tea
b) Select the last 3 results (by date) of the youth tea

Any help would be most appreciated

Many thanks in advance
And
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,233
Members
46,820
Latest member
GilbertoA5

Latest Threads

Top