I have a XML file in the format below
i need tp parse them and retrieve values from them and store it in database
can anyone give an idea abt how to start the application
is the system.xml namespace is enough to accomplish my task or i need to go in for any parse
i am new to XML so plz help me on this regard.
the following xml when run in application gives the following error
" The XML editor tried to convert this DTD to XSD so it can provide validation and intellisense while you type, but it could not create a valid XSD schema. Perhaps this DTD uses constructs that do not map to XSD. You may be able to get more information about the problem by using the Create Schema command. "
what is wrong with the following dtd
if i need to use this xml efficiently do i need to convert them into XSD
give an idea about what to refer first in order to start off with the application
<?xmlversion="1.0"encoding="iso-8859-1"?>
<!DOCTYPEpinnacle_line_feed[
<!ELEMENTPinnacleFeedTime(#PCDATA)>
<!ELEMENTdescription(#PCDATA)>
<!ELEMENTevent(event_datetimeGMT,gamenumber,sporttype,league,description?,(participants|periods|total)+)>
<!ELEMENTvisiting_home_draw(#PCDATA)>
]>
<line_feed>
<FeedTime>1177485702000</FeedTime>
<events>
<event>
<event_datetimeGMT>2007-04-25 17:10</event_datetimeGMT>
<gamenumber>101979285</gamenumber>
<sporttype>Baseball</sporttype>
<league>Alt Runlines</league>
<participants>
<participant>
<participant_name>Colorado Rockies</participant_name>
<contestantnum>901</contestantnum>
<rotnum>901</rotnum>
<visiting_home_draw>Visiting</visiting_home_draw>
<pitcher>J. Fogg</pitcher>
</participant>

</participants>
<periods>
<period>
<periodnumber>0</periodnumber>
<period_description>Game</period_description>
<periodcutoff_datetimeGMT>2007-04-25 17:10</periodcutoff_datetimeGMT>
<period_status>I</period_status>
<moneyline>
<moneyline_visiting>null</moneyline_visiting>
<moneyline_home>null</moneyline_home>
</moneyline>

</period>
</periods>
</event>
</events>
</line_feed>