>>StringReader loStream = new StringReader(lcXML); >>XmlTextReader loXmlTextReader = new XmlTextReader(loStream); >> >>loDataSet.ReadXml((loXmlTextReader,XmlReadMode.ReadSchema); >> >>loStream.Close(); >>loXmlTextReader.Close(); >> >>>>
>>>>>= CURSORTOXML("cResult","lcXMLResult",1,0,0,"1") >>>>>>>>>>
>>>>>// create staff object >>>>>int lnStaffID; >>>>>string lcStaffXML; >>>>>Staff oStaff = new Staff(); >>>>>DataSet dsStaff = new DataSet(); >>>>> >>>>>lnStaffID = Convert.ToInt32(Request.QueryString.Get("id")); >>>>>// get the XML string of the unchanged data >>>>>lcStaffXML = oStaff.GetRecord(lnStaffID); >>>>>// read xml string into a dataset >>>>>dsStaff.ReadXml(lcStaffXML); >>>>>>>>>>
>>>>><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> >>>>><VFPData> >>>>> <xsd:schema id="VFPData" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> >>>>> <xsd:element name="VFPData" msdata:IsDataSet="true"> >>>>> <xsd:complexType> >>>>> <xsd:choice maxOccurs="unbounded"> >>>>> <xsd:element name="cresult"> >>>>> <xsd:complexType> >>>>> <xsd:sequence> >>>>> <xsd:element name="id"> >>>>> <xsd:simpleType> >>>>> <xsd:restriction base="xsd:decimal"> >>>>> <xsd:totalDigits value="7"/> >>>>> <xsd:fractionDigits value="0"/> >>>>> </xsd:restriction> >>>>> </xsd:simpleType> >>>>> </xsd:element> >>>>> <xsd:element name="name"> >>>>> <xsd:simpleType> >>>>> <xsd:restriction base="xsd:string"> >>>>> <xsd:maxLength value="20"/> >>>>> </xsd:restriction> >>>>> </xsd:simpleType> >>>>> </xsd:element> >>>>> <xsd:element name="info"> >>>>> <xsd:simpleType> >>>>> <xsd:restriction base="xsd:string"> >>>>> <xsd:maxLength value="20"/> >>>>> </xsd:restriction> >>>>> </xsd:simpleType> >>>>> </xsd:element> >>>>> <xsd:element name="in" type="xsd:boolean"/> >>>>> </xsd:sequence> >>>>> </xsd:complexType> >>>>> </xsd:element> >>>>> </xsd:choice> >>>>> </xsd:complexType> >>>>> </xsd:element> >>>>> </xsd:schema> >>>>> <cresult> >>>>> <id>23</id> >>>>> <name>John Smith</name> >>>>> <info>CSICU</info> >>>>> <in>true</in> >>>>> </cresult> >>>>></VFPData> >>>>> >>>>>