Selecting one column from an XML table

[David Brower]

Hi Folks,
I have a ADO.NET Dataset in the following format:

<Dyelots>
<Batch>
<batch_id>38084</batch_id>
<shade_name>03880</shade_name>
<article>2994120</article>
....
</Batch>
<Dyelots>

Presently this data is loaded into a data grid from which screen a
series of reports can be run using the string from DataSet.GetXML as
the criteria for each report. Now, because, in total, each batch row
has about 25 columns and there can be any number of batch rows in a
table the size of the XML string sent across the network can be very
large. What I would like to do is to reduce the amount of traffic by
stripping out the batch_id column and sending only that (since that is
the only column that the reports actually use to base the criteria
on).

I'm not sure if I'm expressing myself very well here. But if anyone
has ideas or advice on this issue I'd be very grateful.

Thank you,
David Brower

[Alex K]

Look into XmlDataDocument. Nice stuff there

"David Brower" wrote:

Hi Folks,
I have a ADO.NET Dataset in the following format:

<Dyelots>
<Batch>
<batch_id>38084</batch_id>
<shade_name>03880</shade_name>
<article>2994120</article>
....
</Batch>
<Dyelots>

Presently this data is loaded into a data grid from which screen a
series of reports can be run using the string from DataSet.GetXML as
the criteria for each report. Now, because, in total, each batch row
has about 25 columns and there can be any number of batch rows in a
table the size of the XML string sent across the network can be very
large. What I would like to do is to reduce the amount of traffic by
stripping out the batch_id column and sending only that (since that is
the only column that the reports actually use to base the criteria
on).

I'm not sure if I'm expressing myself very well here. But if anyone
has ideas or advice on this issue I'd be very grateful.

Thank you,
David Brower