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