StringReader loStream = new StringReader(lcXML); XmlTextReader loXmlTextReader = new XmlTextReader(loStream); loDataSet.ReadXml((loXmlTextReader,XmlReadMode.ReadSchema); loStream.Close(); loXmlTextReader.Close();>I've changed added XmlReadMode.ReadSchema, but I am still getting the same error.
>>>= 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> >>> >>>