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