>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> >>>> >>>>