Datagrid - populate with subset of an XML file

[Andy]

Hi,
I want to fill a datagrid with results from a team.
I am looking to fill datagrids with queries similar to "The most
recent 5 results", or "All youth team results".
It shouldn't be that hard but is escaping me at present. I can do
this till the cows come home in SQL, but I'm new to working with XML
files.
e.g. XML file...
(I hope this XML file comes out OK, I've had CRLF problems before, so
have put it in a code block)

<code>

<games>
<game>
<team>youth</team>
<date>12/12/04</date>
<result>2:0</result>
</game>
<game>
<team>mens</team>
<date>10/02/04</date>
<result>1:1</result>
</game>
</games>

</code>


Many thanks for any help or pointers