arrorkincaro
New Member
I have bunch of these XML files that I would like to read and store the data in a SQL table. What is the best way to read/parse the XML files? I am working with ASP.NET 4.0 and SQL Server 2008. I am very good with C#/VB and asp.net but have not had much experience with XML. Basically these are multiple choice questions and there answers. Any help will be greatly appreciated. Thank you.\[code\]<assessmentItem xsi:schemaLocation="http://www.imsglobal.org/xsd/imsqti_v2p0 imsqti_v2p0.xsd" identifier="choice" adaptive="false" timeDependent="false" title="001157" xmlns="http://www.imsglobal.org/xsd/imsqti_v2p0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <responseDeclaration identifier="RESPONSE" cardinality="single" baseType="identifier"> <correctResponse> <value>A</value> </correctResponse> </responseDeclaration> <outcomeDeclaration identifier="SCORE" cardinality="single" baseType="integer"> <defaultValue> <value>0</value> </defaultValue> </outcomeDeclaration> <stylesheet href="http://stackoverflow.com/questions/10671036/stylesheet/scip.css" type="text/css" /> <itemBody> <span class="class1"> <b>Nick had eight marbles. He found four more.<br /> <br /> </b> </span> <div class="class2"> <span class="class1"> <b> <img src="http://stackoverflow.com/questions/10671036/images/41047.jpg" alt="" /> </b> </span> </div> <span class="class1"> <b>How many marbles does Nick have now?</b> </span> <choiceInteraction responseIdentifier="RESPONSE" shuffle="false" maxChoices="1"> <simpleChoice identifier="A"> <span class="class1">12</span> <rubricBlock> <span class="class1" > <b>Correct</b> </span> </rubricBlock> </simpleChoice> <simpleChoice identifier="B"> <span class="class1">8</span> <rubricBlock> <span class="class1" >Chose a number from the stem</span> </rubricBlock> </simpleChoice> <simpleChoice identifier="C"> <span class="class1">4</span> <rubricBlock> <span class="class1" >Subtracted</span> </rubricBlock> </simpleChoice> </choiceInteraction> </itemBody> <responseProcessing template="http://www.imsglobal.org/question/qti_v2p0/rptemplates/match_correct" /></assessmentItem>\[/code\]