How to load (any) XML file into DataSet/DataGrid?

I've been searching the web about loading XML files into .NET datasets and haven't found the right info yet.

I know the DataSet class has a ReadXml method you can use for the task and there are a few other ways to do the job.

And now, here's the problem - I would like to load, ideally, any XML file into a dataset for display in a datagrid. To make things simple, lets start with the typical/standard .NET DataSet XML format (at least what I seem to observe from SQLBuddy and other .NET apps found on CodeProject.com)

How do I load that into a DataSet and make that show up in a DataGrid looking like this (where a comma denotes separation of table columns)

Extension,StationID,FirstName,LastName
606,950,Station,SIP606
668,953,Cuby,SIP

I wasn't able to do that simply using the ReadXml method of the DataSet and then assigning the DataSet to a DataGrid as the data source.

Am I missing something or is this not as trivial as I thought?

There was a CodeProject article with a title about working with XML and datasets but it only covered querying a SQL database to load data into the datagrid then save the data to XML. The demo app offered a open XML file feature but it failed to work, just like my own code. I assume it would open the XML, if it was in the "correct" format (by saving the SQL query results to XML file first). But what is the "correct" format to save the XML in before I can open it with DataSet.ReadXml?

Also since I'm a novice in this area, a sample snippet of how to load the XML into dataset and bind it to a datagrid, etc. for viewing in GUI app would be appreciated.Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

<NewDataSet>
  <Table>
    <Extension>606</Extension>
    <StationID>950</StationID>
    <FirstName>Station</FirstName>
    <LastName>SIP606</LastName>
  </Table>
  <Table>
    <Extension>668</Extension>
    <StationID>953</StationID>
    <FirstName>Cuby</FirstName>
    <LastName>SIP</LastName>
  </Table>
...
</NewDataSet>