XMLXMLWebXMLASP.NET7.1.1XMLadvanceapp\intro.aspxIntro.aspxhtmlcentertitle/title/centerheadlinkrel=stylesheethref=intro.css/headbodycenterformaction=intro.aspxmethod=postrunat=serverh2/h2asp:adrotatorAdvertisementFile=intro.xmlBorderColor=blackBorderWidth=1runat=server//form/center/body/htmlintro.xmlAdvertisementsAdImageUrl./hp1.gif/ImageUrlNavigateUrl://:adrotatorAdvertisementFile=intro.xmlBorderColor=blackBorderWidth=1runat=server/intro.xmlF5AdRotatorxmlImageUrlNavigateUrlAlternateTextKeywordImpressions7.1.2XMLdatasetCommonLanguageRuntimeAPIAPISQLServer,OLEDB,XML3Connections,Commands,andDataSetsConnectionSQLServerXMLCommanddeleteselect,updateDatasetSQLSystem.DataSystem.Data.SQL%@ImportNamespace=System.Data%%@ImportNamespace=System.Data.SQL%SQLSQLSelectSELECT*fromStudentWHEREstuname=‘’SelectSELECT*fromStudentS,DeptDWHERES.dept=D.deptInsertINSERTintoStudentVALUES(''21’’)DeleteDELETEfromStudentWHEREname=’’;UpdateUPDATEStudentSETage=21WHEREname=’’;SQLDataSetCommandDataSetteststudentDimmyConnectionAsNewSQLConnection(server=localhost;uid=sa;pwd=;database=test)DimmyCommandAsNewSQLDataSetCommand(select*fromstudent,myConnection)DimdsAsNewDataSet()myCommand.FillDataSet(ds,student)XML?.aseparateserverprocess,administratorSQL,SQLXML,XMLftpXML-schemaelementrdbmsSQLxmlstreamXML(oraclexsqlservlet)7.1.3XMLXMLSchemasXMLSchemaW3CDTDsDTDXMLXMLDTDXMLDTDDTDXMLDTDsXMLSGMLXMLSGMLXMLSGMLXMLXMLDTDXMLSchemasschemaXMLschemaDTDSchemasstringintegerdecimalelementname=quantitytype=positive-integer/elementname=amounttype=decimal/Schemadecimalvaluevalueunit=Celsius42/valueelementname=valuecomplexTypebase=&single;decimal&single;derivedBy=&single;extension&single;attributename=&single;unit&single;type=&single;string&single;//complexType/elementtimevaluemeasurementmeasurementtime2000-10-0812:00:00GMTtime/valueunit=Celsius42/valueschemaelementname=&single;measurement&single;type=&single;measurement&single;/complexTypename=&single;measurement&single;elementname=&single;time&single;type=&single;time&single;/elementname=&single;value&single;type=&single;value&single;//complexTypeschemaDTD!ELEMENTmeasurement(time,value)!ELEMENTtime(#PCDATA)!ELEMENTvalue(#PCDATA)!ATTLISTvalue(unit)JavaJavaC++XMLSchemaDTDDTD(1)(*)(+)DTDXMLSchemaminOccursmaxOccurselementref=optionalElementminOccurs=0/elementref=twoOrMoreElementsminOccurs=2maxOccurs=unbounded/elementref=exactlyOneElement/minOccursmaxOccurs1choiceallchoiceallDTDxsd:choiceelementref=EitherThis/elementref=OrThat//xsd:choicexsd:allelementref=Ying/elementref=Yang//xsd:all/XMLSchemaSchemaXMLxsd:schematargetNamespace=&single;:xsd=&single;:units=&single;:elementname=&single;units&single;type=&single;units:Units&single;/xsd:elementname=&single;measurement&single;type=&single;measurement&single;/complexTypename=&single;measurement&single;elementname=&single;time&single;type=&single;time&single;/elementname=&single;value&single;type=&single;value&single;//complexTypeXMLSchemaXMLXMLXMLmeta-informationXMLDTDDTDXMLApacheProjectIBMalphaworksSchemaxmlDataSetReadXmlXMLschemaDatadata1.aspxadvanceapp\data1.aspx%@ImportNamespace=System.IO%%@ImportNamespace=System.Data%htmlheadtitleXML/title/headscriptlanguage=VBrunat=serverSubPage_Load(SrcAsObject,EAsEventArgs)DimDSAsNewDataSetDimFSAsFileStreamDimReaderAsStreamReaderFS=NewFileStream(Server.MapPath(data1.xml),FileMode.Open,FileAccess.Read)Reader=NewStreamReader(FS)DS.ReadXml(Reader)FS.Close()DimSourceAsDataViewSource=newDataView(ds.Tables(0))MySpan.InnerHtml=Source.Table.TableNameMyDataGrid.DataSource=SourceMyDataGrid.DataBind()EndSub/scriptbodycenterh3fontface=VerdanaXMLspanrunat=serverid=MySpan//font/h3ASP:DataGridid=MyDataGridrunat=server//center/body/htmlxmladvanceapp\data1.aspxdata1.xmlcenterrootschemaid=DocumentElementtargetNamespace=xmlns=:xdo=urn:schemas-microsoft-com:xml-xdoxdo:DataSetName=DocumentElementelementname=studentcomplexTypecontent=elementOnlyallelementname=nametype=string/elementelementname=agetype=int/elementelementname=sextype=string/elementelementname=gradetype=string/element/all/complexType/element/schemaDocumentElementstudentnamejimmy/nameage20/agesexboy/sexgradefreshman/grade/studentstudentnameMary/nameage20/agesexgirl/sexgradesophomore/grade/studentstudentnameTom/nameage19/agesexboy/sexgradefre