Navigate a DataSet/DataTable

[Carl Lindmark]

Hello,

I am having trouble understanding how to navigate a DataSet table... - maybe
someone can steer me in the right direction?

Say you've read an XML document into a DataSet ("myDataSet") and then filled
a DataTable by doing: myDataSet.Tables["situation"];
and the XML looks this way:
....
<situation>
<objectID>123</objectId>
<validityPeriod>
<start>2004-10-16T06:00:00+02:00</start>
<end>2004-10-18T15:00:00+02:00</end>
</validityPeriod>
....
</situation>
....

Now, the DataTable is filled nicely and I can access the "objectId" value
easily, but I just don't understand how I can go from "situation" to
"validityPeriod" and then on to "start" and "end".

I THINK I managed to get to the "start" and "end" values directly, by using
"GetChildRows" somehow - but the way I did that, I couldn't make sure that
the "start" and "end" I found were actually children of "validityPeriod",
which I have to be sure of.

Could anyone help me navigate this DataTable?
Thanks in advance!

Sincerely,
Carl Lindmark

[Dmytro Lapshyn [MVP]]

Hello Carl,

The GetChildRows is the way to go, and as far as I remember the DataSet XML
reading logic *will* infer a child validityPeriod table from the XML
structure you have.
You can simply check that by setting a breakpoint where you retrieve child
rows, adding a variable containing a reference to the child row to the Watch
window and drilling down it's Table property.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Carl Lindmark" <RepliesInNewsGroupOnly@Thanks> wrote in message
news:es**************@TK2MSFTNGP12.phx.gbl...

Hello,

I am having trouble understanding how to navigate a DataSet table... -
maybe
someone can steer me in the right direction?

Say you've read an XML document into a DataSet ("myDataSet") and then
filled
a DataTable by doing: myDataSet.Tables["situation"];
and the XML looks this way:
...
<situation>
<objectID>123</objectId>
<validityPeriod>
<start>2004-10-16T06:00:00+02:00</start>
<end>2004-10-18T15:00:00+02:00</end>
</validityPeriod>
...
</situation>
...

Now, the DataTable is filled nicely and I can access the "objectId" value
easily, but I just don't understand how I can go from "situation" to
"validityPeriod" and then on to "start" and "end".

I THINK I managed to get to the "start" and "end" values directly, by
using
"GetChildRows" somehow - but the way I did that, I couldn't make sure that
the "start" and "end" I found were actually children of "validityPeriod",
which I have to be sure of.

Could anyone help me navigate this DataTable?
Thanks in advance!

Sincerely,
Carl Lindmark

[Carl Lindmark]

Hi Dmytro,

Thank you very much for your pointers!
I had not realized that the "validityPeriod" XML tag would be a TABLE - I
thought it would just be a sub ROW... But now I'm beginning to understand
how these datasets and datatables work. Thank you very much!

/Carl

"Dmytro Lapshyn [MVP]" <x-****@no-spam-please.hotpop.com> skrev i
meddelandet news:uu**************@TK2MSFTNGP10.phx.gbl...

Hello Carl,

The GetChildRows is the way to go, and as far as I remember the DataSet XML reading logic *will* infer a child validityPeriod table from the XML
structure you have.
You can simply check that by setting a breakpoint where you retrieve child
rows, adding a variable containing a reference to the child row to the Watch window and drilling down it's Table property.

--
Sincerely,
Dmytro Lapshyn [Visual Developer - Visual C# MVP]
"Carl Lindmark" <RepliesInNewsGroupOnly@Thanks> wrote in message
news:es**************@TK2MSFTNGP12.phx.gbl...

Hello,

I am having trouble understanding how to navigate a DataSet table... -
maybe
someone can steer me in the right direction?

Say you've read an XML document into a DataSet ("myDataSet") and then
filled
a DataTable by doing: myDataSet.Tables["situation"];
and the XML looks this way:
...
<situation>
<objectID>123</objectId>
<validityPeriod>
<start>2004-10-16T06:00:00+02:00</start>
<end>2004-10-18T15:00:00+02:00</end>
</validityPeriod>
...
</situation>
...

Now, the DataTable is filled nicely and I can access the "objectId" value easily, but I just don't understand how I can go from "situation" to
"validityPeriod" and then on to "start" and "end".

I THINK I managed to get to the "start" and "end" values directly, by
using
"GetChildRows" somehow - but the way I did that, I couldn't make sure that the "start" and "end" I found were actually children of "validityPeriod", which I have to be sure of.

Could anyone help me navigate this DataTable?
Thanks in advance!

Sincerely,
Carl Lindmark