473,499 Members | 1,619 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Looking for Advice

I am looking for pointers to good beginner books, tutorials or other
resources to help me understand how to really use XML data. I program mostly
in VB (I have several applications in VB6 but am just starting to convert to
VB.NET). Most of my database backends are SQL Server 2000 with a few still
Access. I want to educate myself so that I can code (and understand)
processes like reading an XML file and adding the contained information to
appropriate tables. I also want to do the reverse, create valid XML from
tables/queries.

An example of what I am trying to accomplish is as follows (sample XML file
at end)

The XML file consists of sets of <Shows> elements which, in turn, each
contain specific information about the show and one or more <PerfSched>
elements. The <PerfSched> elements contain the information about each units
scheduled performance. For each occurrence of <Shows> I want to add a record
to a "Shows" table with the contained values. Also, for each occurrence of
<PerfSched> I want to add a record to a "Performance" table.

In the examples I've found via google, most of the processes appear to
"walk" through the nodes serially. I can see how to pull the values from the
current node so that I can add them to the table but when I get to the first
<PerfSched> tag that is at the end of the <Shows> elements I am not clear on
exactly what to do next? Should I skip to the next <Shows> element (how?)
until I process all of them and then go back to process the <PerfSched>
elements or should I process those child elements as they occur. If the
latter, how do I go "back up" when I reach the next parent node <Shows>.

A big part of my problem is uncertainty how to navigate around in the DOM so
pointers to material that clarifies that would be a gig help.

Thanks for any and all advice.

Wayne
============ XML File ===============
<?xml version="1.0" ?>
<NewDataSet>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<ShowName>Denver SA Prelims Rnd 1</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>1</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:00:00.0000000-06:00</PerfTime>
<UnitID>10</UnitID>
<Nickname>Arapahoe HS WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:08:00.0000000-06:00</PerfTime>
<UnitID>606</UnitID>
<Nickname>Loveland HS CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:16:00.0000000-06:00</PerfTime>
<UnitID>1944</UnitID>
<Nickname>Arvada West</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:24:00.0000000-06:00</PerfTime>
<UnitID>1790</UnitID>
<Nickname>Santa Monica</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<ShowName>Denver SA Prelims Rnd 2</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>2</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:00:00.0000000-06:00</PerfTime>
<UnitID>1942</UnitID>
<Nickname>Mt. Crest HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:08:00.0000000-06:00</PerfTime>
<UnitID>297</UnitID>
<Nickname>Tahlequah WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:16:00.0000000-06:00</PerfTime>
<UnitID>98</UnitID>
<Nickname>Bear Creek CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:24:00.0000000-06:00</PerfTime>
<UnitID>1510</UnitID>
<Nickname>Broomfield HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:32:00.0000000-06:00</PerfTime>
<UnitID>231</UnitID>
<Nickname>Vista HS</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<ShowName>Denver IO/SO Prelims</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>0</Round>
<Eqp1Judge>CAMPBELL J</Eqp1Judge>
<Mov1Judge>OLIVIERO G</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>COSTANZA C</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:00:00.0000000-06:00</PerfTime>
<UnitID>1564</UnitID>
<Nickname>Revolution WG</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:09:00.0000000-06:00</PerfTime>
<UnitID>1890</UnitID>
<Nickname>Stampede</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:18:00.0000000-06:00</PerfTime>
<UnitID>421</UnitID>
<Nickname>Alchemy</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:27:00.0000000-06:00</PerfTime>
<UnitID>0</UnitID>
<Nickname>*BREAK</Nickname>
<Class />
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:45:00.0000000-06:00</PerfTime>
<UnitID>1050</UnitID>
<Nickname>Dakota Ridge</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:54:00.0000000-06:00</PerfTime>
<UnitID>782</UnitID>
<Nickname>Arvada HS Reds</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T12:03:00.0000000-06:00</PerfTime>
<UnitID>1911</UnitID>
<Nickname>Mountain Crest</Nickname>
<Class>SO</Class>
</PerfSched>
</CGShows>
</NewDataSet>

Nov 12 '05 #1
4 1817
It seems to me ...

The example XML you showed was generated as a DataSet.
You can save and read DataSets to/from XML in just one method call.
You don't need to walk the DOM of the XML file and add a record to a shows
table, and another record to a Performance table. That sort of thing is
done automatically.

Where did you get the DataSet?
When you save a DataSet from memory to an XML stream or file, it is also
possible to save the schema. If you have access to the schema, then you can
create your own DataSet that conforms to that schema and slurp in that XML
file.

Then you have the Shows table and the Performances table and so on.

If I were you I would not follow the examples that show reading XML
serially, going from one node to the next. Acquaint yourself with ADO.NET
DataSets, as well as XML Serialization, which does these things for you
automatically.

To learn more, In addition to the XML Developer Center on MSDN
http://msdn.microsoft.com/xml/

....I recommend www.topxml.com

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:eC****************@TK2MSFTNGP09.phx.gbl...
I am looking for pointers to good beginner books, tutorials or other
resources to help me understand how to really use XML data. I program mostly in VB (I have several applications in VB6 but am just starting to convert to VB.NET). Most of my database backends are SQL Server 2000 with a few still
Access. I want to educate myself so that I can code (and understand)
processes like reading an XML file and adding the contained information to
appropriate tables. I also want to do the reverse, create valid XML from
tables/queries.

An example of what I am trying to accomplish is as follows (sample XML file at end)

The XML file consists of sets of <Shows> elements which, in turn, each
contain specific information about the show and one or more <PerfSched>
elements. The <PerfSched> elements contain the information about each units scheduled performance. For each occurrence of <Shows> I want to add a record to a "Shows" table with the contained values. Also, for each occurrence of
<PerfSched> I want to add a record to a "Performance" table.

In the examples I've found via google, most of the processes appear to
"walk" through the nodes serially. I can see how to pull the values from the current node so that I can add them to the table but when I get to the first <PerfSched> tag that is at the end of the <Shows> elements I am not clear on exactly what to do next? Should I skip to the next <Shows> element (how?)
until I process all of them and then go back to process the <PerfSched>
elements or should I process those child elements as they occur. If the
latter, how do I go "back up" when I reach the next parent node <Shows>.

A big part of my problem is uncertainty how to navigate around in the DOM so pointers to material that clarifies that would be a gig help.

Thanks for any and all advice.

Wayne
============ XML File ===============
<?xml version="1.0" ?>
<NewDataSet>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<ShowName>Denver SA Prelims Rnd 1</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>1</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:00:00.0000000-06:00</PerfTime>
<UnitID>10</UnitID>
<Nickname>Arapahoe HS WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:08:00.0000000-06:00</PerfTime>
<UnitID>606</UnitID>
<Nickname>Loveland HS CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:16:00.0000000-06:00</PerfTime>
<UnitID>1944</UnitID>
<Nickname>Arvada West</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:24:00.0000000-06:00</PerfTime>
<UnitID>1790</UnitID>
<Nickname>Santa Monica</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<ShowName>Denver SA Prelims Rnd 2</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>2</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:00:00.0000000-06:00</PerfTime>
<UnitID>1942</UnitID>
<Nickname>Mt. Crest HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:08:00.0000000-06:00</PerfTime>
<UnitID>297</UnitID>
<Nickname>Tahlequah WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:16:00.0000000-06:00</PerfTime>
<UnitID>98</UnitID>
<Nickname>Bear Creek CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:24:00.0000000-06:00</PerfTime>
<UnitID>1510</UnitID>
<Nickname>Broomfield HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:32:00.0000000-06:00</PerfTime>
<UnitID>231</UnitID>
<Nickname>Vista HS</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<ShowName>Denver IO/SO Prelims</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>0</Round>
<Eqp1Judge>CAMPBELL J</Eqp1Judge>
<Mov1Judge>OLIVIERO G</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>COSTANZA C</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:00:00.0000000-06:00</PerfTime>
<UnitID>1564</UnitID>
<Nickname>Revolution WG</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:09:00.0000000-06:00</PerfTime>
<UnitID>1890</UnitID>
<Nickname>Stampede</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:18:00.0000000-06:00</PerfTime>
<UnitID>421</UnitID>
<Nickname>Alchemy</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:27:00.0000000-06:00</PerfTime>
<UnitID>0</UnitID>
<Nickname>*BREAK</Nickname>
<Class />
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:45:00.0000000-06:00</PerfTime>
<UnitID>1050</UnitID>
<Nickname>Dakota Ridge</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:54:00.0000000-06:00</PerfTime>
<UnitID>782</UnitID>
<Nickname>Arvada HS Reds</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T12:03:00.0000000-06:00</PerfTime>
<UnitID>1911</UnitID>
<Nickname>Mountain Crest</Nickname>
<Class>SO</Class>
</PerfSched>
</CGShows>
</NewDataSet>

Nov 12 '05 #2
The problem is that although the XML was created in .NET, the application
that is reading it is not .NET - it is plain old VB6/ADO.

Wayne

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uA**************@TK2MSFTNGP10.phx.gbl...
It seems to me ...

The example XML you showed was generated as a DataSet.
You can save and read DataSets to/from XML in just one method call.
You don't need to walk the DOM of the XML file and add a record to a shows
table, and another record to a Performance table. That sort of thing is
done automatically.

Where did you get the DataSet?
When you save a DataSet from memory to an XML stream or file, it is also
possible to save the schema. If you have access to the schema, then you can create your own DataSet that conforms to that schema and slurp in that XML
file.

Then you have the Shows table and the Performances table and so on.

If I were you I would not follow the examples that show reading XML
serially, going from one node to the next. Acquaint yourself with ADO.NET
DataSets, as well as XML Serialization, which does these things for you
automatically.

To learn more, In addition to the XML Developer Center on MSDN
http://msdn.microsoft.com/xml/

...I recommend www.topxml.com

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:eC****************@TK2MSFTNGP09.phx.gbl...
I am looking for pointers to good beginner books, tutorials or other
resources to help me understand how to really use XML data. I program mostly
in VB (I have several applications in VB6 but am just starting to convert to
VB.NET). Most of my database backends are SQL Server 2000 with a few
still Access. I want to educate myself so that I can code (and understand)
processes like reading an XML file and adding the contained information to appropriate tables. I also want to do the reverse, create valid XML from
tables/queries.

An example of what I am trying to accomplish is as follows (sample XML

file
at end)

The XML file consists of sets of <Shows> elements which, in turn, each
contain specific information about the show and one or more <PerfSched>
elements. The <PerfSched> elements contain the information about each

units
scheduled performance. For each occurrence of <Shows> I want to add a

record
to a "Shows" table with the contained values. Also, for each occurrence of <PerfSched> I want to add a record to a "Performance" table.

In the examples I've found via google, most of the processes appear to
"walk" through the nodes serially. I can see how to pull the values from

the
current node so that I can add them to the table but when I get to the

first
<PerfSched> tag that is at the end of the <Shows> elements I am not clear on
exactly what to do next? Should I skip to the next <Shows> element
(how?) until I process all of them and then go back to process the <PerfSched>
elements or should I process those child elements as they occur. If the
latter, how do I go "back up" when I reach the next parent node <Shows>.

A big part of my problem is uncertainty how to navigate around in the

DOM so
pointers to material that clarifies that would be a gig help.

Thanks for any and all advice.

Wayne
============ XML File ===============
<?xml version="1.0" ?>
<NewDataSet>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<ShowName>Denver SA Prelims Rnd 1</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>1</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:00:00.0000000-06:00</PerfTime>
<UnitID>10</UnitID>
<Nickname>Arapahoe HS WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:08:00.0000000-06:00</PerfTime>
<UnitID>606</UnitID>
<Nickname>Loveland HS CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:16:00.0000000-06:00</PerfTime>
<UnitID>1944</UnitID>
<Nickname>Arvada West</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:24:00.0000000-06:00</PerfTime>
<UnitID>1790</UnitID>
<Nickname>Santa Monica</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<ShowName>Denver SA Prelims Rnd 2</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>2</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:00:00.0000000-06:00</PerfTime>
<UnitID>1942</UnitID>
<Nickname>Mt. Crest HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:08:00.0000000-06:00</PerfTime>
<UnitID>297</UnitID>
<Nickname>Tahlequah WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:16:00.0000000-06:00</PerfTime>
<UnitID>98</UnitID>
<Nickname>Bear Creek CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:24:00.0000000-06:00</PerfTime>
<UnitID>1510</UnitID>
<Nickname>Broomfield HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:32:00.0000000-06:00</PerfTime>
<UnitID>231</UnitID>
<Nickname>Vista HS</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<ShowName>Denver IO/SO Prelims</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>0</Round>
<Eqp1Judge>CAMPBELL J</Eqp1Judge>
<Mov1Judge>OLIVIERO G</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>COSTANZA C</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:00:00.0000000-06:00</PerfTime>
<UnitID>1564</UnitID>
<Nickname>Revolution WG</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:09:00.0000000-06:00</PerfTime>
<UnitID>1890</UnitID>
<Nickname>Stampede</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:18:00.0000000-06:00</PerfTime>
<UnitID>421</UnitID>
<Nickname>Alchemy</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:27:00.0000000-06:00</PerfTime>
<UnitID>0</UnitID>
<Nickname>*BREAK</Nickname>
<Class />
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:45:00.0000000-06:00</PerfTime>
<UnitID>1050</UnitID>
<Nickname>Dakota Ridge</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:54:00.0000000-06:00</PerfTime>
<UnitID>782</UnitID>
<Nickname>Arvada HS Reds</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T12:03:00.0000000-06:00</PerfTime>
<UnitID>1911</UnitID>
<Nickname>Mountain Crest</Nickname>
<Class>SO</Class>
</PerfSched>
</CGShows>
</NewDataSet>


Nov 12 '05 #3
Ahh, my misunderstanding.
I think this group is mostly focused around programming XML in .NET.

I am not as familiar with MSXML but
believe you can do selectNodes(...) on an element, selecting by Xpath.
Then you will get all nodes in the doc of a particular name (eg, all Shows,
then all performances).
This may or may not be what you want.

topxml.com has more examples and tutorials.

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
The problem is that although the XML was created in .NET, the application
that is reading it is not .NET - it is plain old VB6/ADO.

Wayne

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uA**************@TK2MSFTNGP10.phx.gbl...
It seems to me ...

The example XML you showed was generated as a DataSet.
You can save and read DataSets to/from XML in just one method call.
You don't need to walk the DOM of the XML file and add a record to a shows
table, and another record to a Performance table. That sort of thing is
done automatically.

Where did you get the DataSet?
When you save a DataSet from memory to an XML stream or file, it is also
possible to save the schema. If you have access to the schema, then you can
create your own DataSet that conforms to that schema and slurp in that XML file.

Then you have the Shows table and the Performances table and so on.

If I were you I would not follow the examples that show reading XML
serially, going from one node to the next. Acquaint yourself with ADO.NET DataSets, as well as XML Serialization, which does these things for you
automatically.

To learn more, In addition to the XML Developer Center on MSDN
http://msdn.microsoft.com/xml/

...I recommend www.topxml.com

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:eC****************@TK2MSFTNGP09.phx.gbl...
I am looking for pointers to good beginner books, tutorials or other
resources to help me understand how to really use XML data. I program

mostly
in VB (I have several applications in VB6 but am just starting to convert
to
VB.NET). Most of my database backends are SQL Server 2000 with a few

still Access. I want to educate myself so that I can code (and understand)
processes like reading an XML file and adding the contained information to
appropriate tables. I also want to do the reverse, create valid XML
from tables/queries.

An example of what I am trying to accomplish is as follows (sample XML file
at end)

The XML file consists of sets of <Shows> elements which, in turn, each
contain specific information about the show and one or more <PerfSched> elements. The <PerfSched> elements contain the information about each

units
scheduled performance. For each occurrence of <Shows> I want to add a

record
to a "Shows" table with the contained values. Also, for each occurrence of <PerfSched> I want to add a record to a "Performance" table.

In the examples I've found via google, most of the processes appear
to "walk" through the nodes serially. I can see how to pull the values from the
current node so that I can add them to the table but when I get to the

first
<PerfSched> tag that is at the end of the <Shows> elements I am not

clear
on
exactly what to do next? Should I skip to the next <Shows> element

(how?) until I process all of them and then go back to process the

<PerfSched> elements or should I process those child elements as they occur. If the latter, how do I go "back up" when I reach the next parent node <Shows>.
A big part of my problem is uncertainty how to navigate around in the

DOM
so
pointers to material that clarifies that would be a gig help.

Thanks for any and all advice.

Wayne
============ XML File ===============
<?xml version="1.0" ?>
<NewDataSet>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<ShowName>Denver SA Prelims Rnd 1</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>1</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:00:00.0000000-06:00</PerfTime>
<UnitID>10</UnitID>
<Nickname>Arapahoe HS WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:08:00.0000000-06:00</PerfTime>
<UnitID>606</UnitID>
<Nickname>Loveland HS CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:16:00.0000000-06:00</PerfTime>
<UnitID>1944</UnitID>
<Nickname>Arvada West</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>1</SeqNbr>
<PerfTime>2004-07-24T09:24:00.0000000-06:00</PerfTime>
<UnitID>1790</UnitID>
<Nickname>Santa Monica</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<ShowName>Denver SA Prelims Rnd 2</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>2</Round>
<Eqp1Judge>ADAMO S</Eqp1Judge>
<Mov1Judge>ADAMS R</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>BERTELLE S</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:00:00.0000000-06:00</PerfTime>
<UnitID>1942</UnitID>
<Nickname>Mt. Crest HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:08:00.0000000-06:00</PerfTime>
<UnitID>297</UnitID>
<Nickname>Tahlequah WG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:16:00.0000000-06:00</PerfTime>
<UnitID>98</UnitID>
<Nickname>Bear Creek CG</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:24:00.0000000-06:00</PerfTime>
<UnitID>1510</UnitID>
<Nickname>Broomfield HS</Nickname>
<Class>SA</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>2</SeqNbr>
<PerfTime>2004-07-24T10:32:00.0000000-06:00</PerfTime>
<UnitID>231</UnitID>
<Nickname>Vista HS</Nickname>
<Class>SA</Class>
</PerfSched>
</CGShows>
<Shows>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<ShowName>Denver IO/SO Prelims</ShowName>
<ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
<Type>SC</Type>
<PorF>P</PorF>
<Round>0</Round>
<Eqp1Judge>CAMPBELL J</Eqp1Judge>
<Mov1Judge>OLIVIERO G</Mov1Judge>
<Ens1Judge>BEENS E</Ens1Judge>
<GE1Judge>ANDERSON M</GE1Judge>
<GE2Judge>COSTANZA C</GE2Judge>
<TaPJudge>ARGY T</TaPJudge>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:00:00.0000000-06:00</PerfTime>
<UnitID>1564</UnitID>
<Nickname>Revolution WG</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:09:00.0000000-06:00</PerfTime>
<UnitID>1890</UnitID>
<Nickname>Stampede</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:18:00.0000000-06:00</PerfTime>
<UnitID>421</UnitID>
<Nickname>Alchemy</Nickname>
<Class>IO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:27:00.0000000-06:00</PerfTime>
<UnitID>0</UnitID>
<Nickname>*BREAK</Nickname>
<Class />
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:45:00.0000000-06:00</PerfTime>
<UnitID>1050</UnitID>
<Nickname>Dakota Ridge</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T11:54:00.0000000-06:00</PerfTime>
<UnitID>782</UnitID>
<Nickname>Arvada HS Reds</Nickname>
<Class>SO</Class>
</PerfSched>
<PerfSched>
<RegionalID>Denver</RegionalID>
<SeqNbr>3</SeqNbr>
<PerfTime>2004-07-24T12:03:00.0000000-06:00</PerfTime>
<UnitID>1911</UnitID>
<Nickname>Mountain Crest</Nickname>
<Class>SO</Class>
</PerfSched>
</CGShows>
</NewDataSet>



Nov 12 '05 #4
Thanks for the pointer. I'll check it out.

Wayne

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...
Ahh, my misunderstanding.
I think this group is mostly focused around programming XML in .NET.

I am not as familiar with MSXML but
believe you can do selectNodes(...) on an element, selecting by Xpath.
Then you will get all nodes in the doc of a particular name (eg, all Shows, then all performances).
This may or may not be what you want.

topxml.com has more examples and tutorials.

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
The problem is that although the XML was created in .NET, the application
that is reading it is not .NET - it is plain old VB6/ADO.

Wayne

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uA**************@TK2MSFTNGP10.phx.gbl...
It seems to me ...

The example XML you showed was generated as a DataSet.
You can save and read DataSets to/from XML in just one method call.
You don't need to walk the DOM of the XML file and add a record to a shows table, and another record to a Performance table. That sort of thing is done automatically.

Where did you get the DataSet?
When you save a DataSet from memory to an XML stream or file, it is also possible to save the schema. If you have access to the schema, then you can
create your own DataSet that conforms to that schema and slurp in that XML file.

Then you have the Shows table and the Performances table and so on.

If I were you I would not follow the examples that show reading XML
serially, going from one node to the next. Acquaint yourself with ADO.NET DataSets, as well as XML Serialization, which does these things for
you automatically.

To learn more, In addition to the XML Developer Center on MSDN
http://msdn.microsoft.com/xml/

...I recommend www.topxml.com

-D

"Wayne Wengert" <wa***************@wengert.com> wrote in message
news:eC****************@TK2MSFTNGP09.phx.gbl...
> I am looking for pointers to good beginner books, tutorials or other
> resources to help me understand how to really use XML data. I program mostly
> in VB (I have several applications in VB6 but am just starting to

convert
to
> VB.NET). Most of my database backends are SQL Server 2000 with a few

still
> Access. I want to educate myself so that I can code (and understand)
> processes like reading an XML file and adding the contained information
to
> appropriate tables. I also want to do the reverse, create valid XML

from > tables/queries.
>
> An example of what I am trying to accomplish is as follows (sample XML file
> at end)
>
> The XML file consists of sets of <Shows> elements which, in turn, each > contain specific information about the show and one or more <PerfSched> > elements. The <PerfSched> elements contain the information about each units
> scheduled performance. For each occurrence of <Shows> I want to add a record
> to a "Shows" table with the contained values. Also, for each occurrence
of
> <PerfSched> I want to add a record to a "Performance" table.
>
> In the examples I've found via google, most of the processes appear

to > "walk" through the nodes serially. I can see how to pull the values from the
> current node so that I can add them to the table but when I get to the first
> <PerfSched> tag that is at the end of the <Shows> elements I am not

clear
on
> exactly what to do next? Should I skip to the next <Shows> element

(how?)
> until I process all of them and then go back to process the <PerfSched> > elements or should I process those child elements as they occur. If the > latter, how do I go "back up" when I reach the next parent node <Shows>. >
> A big part of my problem is uncertainty how to navigate around in

the DOM
so
> pointers to material that clarifies that would be a gig help.
>
> Thanks for any and all advice.
>
> Wayne
>
>
> ============ XML File ===============
> <?xml version="1.0" ?>
> <NewDataSet>
> <Shows>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>1</SeqNbr>
> <ShowName>Denver SA Prelims Rnd 1</ShowName>
> <ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
> <Type>SC</Type>
> <PorF>P</PorF>
> <Round>1</Round>
> <Eqp1Judge>ADAMO S</Eqp1Judge>
> <Mov1Judge>ADAMS R</Mov1Judge>
> <Ens1Judge>BEENS E</Ens1Judge>
> <GE1Judge>ANDERSON M</GE1Judge>
> <GE2Judge>BERTELLE S</GE2Judge>
> <TaPJudge>ARGY T</TaPJudge>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>1</SeqNbr>
> <PerfTime>2004-07-24T09:00:00.0000000-06:00</PerfTime>
> <UnitID>10</UnitID>
> <Nickname>Arapahoe HS WG</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>1</SeqNbr>
> <PerfTime>2004-07-24T09:08:00.0000000-06:00</PerfTime>
> <UnitID>606</UnitID>
> <Nickname>Loveland HS CG</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>1</SeqNbr>
> <PerfTime>2004-07-24T09:16:00.0000000-06:00</PerfTime>
> <UnitID>1944</UnitID>
> <Nickname>Arvada West</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>1</SeqNbr>
> <PerfTime>2004-07-24T09:24:00.0000000-06:00</PerfTime>
> <UnitID>1790</UnitID>
> <Nickname>Santa Monica</Nickname>
> <Class>SA</Class>
> </PerfSched>
> </CGShows>
> <Shows>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <ShowName>Denver SA Prelims Rnd 2</ShowName>
> <ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
> <Type>SC</Type>
> <PorF>P</PorF>
> <Round>2</Round>
> <Eqp1Judge>ADAMO S</Eqp1Judge>
> <Mov1Judge>ADAMS R</Mov1Judge>
> <Ens1Judge>BEENS E</Ens1Judge>
> <GE1Judge>ANDERSON M</GE1Judge>
> <GE2Judge>BERTELLE S</GE2Judge>
> <TaPJudge>ARGY T</TaPJudge>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <PerfTime>2004-07-24T10:00:00.0000000-06:00</PerfTime>
> <UnitID>1942</UnitID>
> <Nickname>Mt. Crest HS</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <PerfTime>2004-07-24T10:08:00.0000000-06:00</PerfTime>
> <UnitID>297</UnitID>
> <Nickname>Tahlequah WG</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <PerfTime>2004-07-24T10:16:00.0000000-06:00</PerfTime>
> <UnitID>98</UnitID>
> <Nickname>Bear Creek CG</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <PerfTime>2004-07-24T10:24:00.0000000-06:00</PerfTime>
> <UnitID>1510</UnitID>
> <Nickname>Broomfield HS</Nickname>
> <Class>SA</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>2</SeqNbr>
> <PerfTime>2004-07-24T10:32:00.0000000-06:00</PerfTime>
> <UnitID>231</UnitID>
> <Nickname>Vista HS</Nickname>
> <Class>SA</Class>
> </PerfSched>
> </CGShows>
> <Shows>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <ShowName>Denver IO/SO Prelims</ShowName>
> <ShowDate>2004-07-24T00:00:00.0000000-06:00</ShowDate>
> <Type>SC</Type>
> <PorF>P</PorF>
> <Round>0</Round>
> <Eqp1Judge>CAMPBELL J</Eqp1Judge>
> <Mov1Judge>OLIVIERO G</Mov1Judge>
> <Ens1Judge>BEENS E</Ens1Judge>
> <GE1Judge>ANDERSON M</GE1Judge>
> <GE2Judge>COSTANZA C</GE2Judge>
> <TaPJudge>ARGY T</TaPJudge>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:00:00.0000000-06:00</PerfTime>
> <UnitID>1564</UnitID>
> <Nickname>Revolution WG</Nickname>
> <Class>IO</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:09:00.0000000-06:00</PerfTime>
> <UnitID>1890</UnitID>
> <Nickname>Stampede</Nickname>
> <Class>IO</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:18:00.0000000-06:00</PerfTime>
> <UnitID>421</UnitID>
> <Nickname>Alchemy</Nickname>
> <Class>IO</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:27:00.0000000-06:00</PerfTime>
> <UnitID>0</UnitID>
> <Nickname>*BREAK</Nickname>
> <Class />
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:45:00.0000000-06:00</PerfTime>
> <UnitID>1050</UnitID>
> <Nickname>Dakota Ridge</Nickname>
> <Class>SO</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T11:54:00.0000000-06:00</PerfTime>
> <UnitID>782</UnitID>
> <Nickname>Arvada HS Reds</Nickname>
> <Class>SO</Class>
> </PerfSched>
> <PerfSched>
> <RegionalID>Denver</RegionalID>
> <SeqNbr>3</SeqNbr>
> <PerfTime>2004-07-24T12:03:00.0000000-06:00</PerfTime>
> <UnitID>1911</UnitID>
> <Nickname>Mountain Crest</Nickname>
> <Class>SO</Class>
> </PerfSched>
> </CGShows>
> </NewDataSet>
>
>
>



Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics
14
2557
College kid, looking for advice.
by: Jason Daly | last post by:
I'm a freshman at college as a computer science major. I'm not sure it has what I want. Does anyone know if a major commonly exists in web design (focusing in server side languages)? I want to...
ASP / Active Server Pages
2
2331
Looking for an XML (database-based) Query Reporting Tool/advice
by: Alex | last post by:
Subject: Looking for an XML (database-based) Query Reporting Tool/advice First off, let me apologize if this thread is somewhat off topic... PLEASE REPLY TO: xml@solex-bi.com I am looking...
.NET Framework
4
1910
Looking for advice, reading list
by: pcunix | last post by:
I'm looking for general advice, pointers to web pages, books, whatever. I have a moderately successful web site. The major complaint that I get, time after time, is "It's UUUGLY" As I have...
HTML / CSS
29
3709
Looking for ways to generate unique ids for a user's PC
by: Lauren Wilson | last post by:
Does anyone know how the following info is extracted from the user's computer by a Front Page form? HTTP User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107...
Microsoft Access / VBA
3
1355
Advice on Looking up
by: bradsalmon | last post by:
Hi all, Sorry for the long post, but I don't know how else to explain this one. Just after some advice really as I'm finding it difficult to update a database. Currently this is running in...
Microsoft Access / VBA
1
1721
off topic: looking for advice on Blog servers
by: jm | last post by:
Sorry for the off-topic post, but I would love to hear the advice of the members of this forum. We are looking to implement an internal blog server. It needs to run on MS platforms. So far, I'm...
C# / C Sharp
13
3082
Looking for best practice advice on data access for SMALL web sites - not enterprise
by: Alan Silver | last post by:
Hello, MSDN (amongst other places) is full of helpful advice on ways to do data access, but they all seem geared to wards enterprise applications. Maybe I'm in a minority, but I don't have those...
ASP.NET
3
1572
transforming a book for online use -- looking for linking advice
by: provowallis | last post by:
I'm new to this board so I hope this reqest isn't out of line, but I'm looking for some general advice about creating links in online books. If the link target didn't involve PIs I don't think I'd...
.NET Framework
1
3150
Looking for a little Advice
by: Shawn Northrop | last post by:
I am trying to create an interface for clients to send newsletters through mailing lists. for the past few weeks I have been exploring options though i still feel a bit lost. First I tried to...
Content Management Systems
0
7014
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
7180
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
1
6905
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
5485
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
4609
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp
0
3103
Windows Forms - .Net 8.0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
Visual Basic .NET
0
1429
transfer the data from one system to another through ip address
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
C# / C Sharp
1
667
muto222
How to add payments to a PHP MySQL app.
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
PHP
0
311
bsmnconsultancy
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
General

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us