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