Datatables and relations

[Jef Patat]

Hi all,

I'm trying to read an xml file that looks like this.

<?xml version="1.0" encoding="utf-16"?>
<TestApp xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="TestApp">
  <Application>
    <Name>146</Name>
    <Version>90</Version>
  </Application>
  <User>
    <Name>Test</Name>
    <RequiredLanguages>
      <Language>English</Language>
      <Language>French</Language>
    </RequiredLanguages>
  </User>
  <User>
    <Name>Test2</Name>
    <RequiredLanguages>
      <Language>Dutch</Language>
      <Language>English</Language>
    </RequiredLanguages>
  </User>
</TestApp>

When using DataSet.ReadXml I see some extra columns being added with names ending with _Id. I could write some custom code to play with these _Id's but I figure there must be a better way. Googling learned me a lot but not what I need in my case.

How can I, for example, easilly get the reguired languages for the second user out of the dataset? Please provide a brief code example. Thank you,

Jef