How to use datarelations after reading xml

[Jef Patat]

All,

when I read this xml using DataSet.ReadXml I get a dataset with relations. How can I use this data inside when the relations have an autogenerated name? In the end I would like to put the 'Value' fields in a String[], how can I do this?

<?xml version="1.0" encoding="utf-8" ?>
<Types>
	<Type>
		<Type>Discrete</Type>
		<Name>bool</Name>
		<ID>1</ID>
		<Minimum>False</Minimum>
		<Maximum>True</Maximum>
		<Value>False</Value>
		<Value>True</Value>
	</Type>
</Types>

Thanks,
Jef

[rliq]

Jef,

Not sure I totally understand, lets start with this code (very hard-coded to your specific XML example) and see how we can improve it. Or, can you post what you have tried so far....

DataSet ds = new DataSet();
ds.ReadXml(@"C:\test.xml");

Int32 numRows = ds.Tables["Value"].Rows.Count;

String[] s = new String[numRows];

for (Int32 i = 0; i < numRows; i++)
    s[i] = ds.Tables["Value"].Rows[i][0].ToString();

[Jef Patat]

Ok, my example was maybe a bit too vague to explain my problem completely. Suppose the xml looks like this:

<Types>
	<Type>
		<Type>Discrete</Type>
		<Name>bool</Name>
		<ID>1</ID>
		<Minimum>False</Minimum>
		<Maximum>True</Maximum>
		<Value>False</Value>
		<Value>True</Value>
	</Type>
	<Type>
		<Type>Discrete</Type>
		<Name>Status</Name>
		<ID>2</ID>
		<Minimum>Not available</Minimum>
		<Maximum>Defined</Maximum>
		<Value>Not available</Value>
		<Value>Available</Value>
                        <Value>Not defined</Value>
                        <Value>Defined</Value>
	</Type>
</Types>

In the end I want to add this data to a class containing a String[] values. For the first object this array should contain False and True, for the second one not available, available, not defined and defined. Your example won't do the trick in this example. I will need to do something with the table relations but I don't know how.

thank you,
Jef