Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: DumpOrder package returns XML as string?

  1. 11-27-2009, 11:12 AM #1
    smoreo is offline Member
    Join Date
    Nov 2009
    Location
    Brooklyn, NY
    Posts
    36

    Question DumpOrder package returns XML as string?

    I run the following code in a windows form

    Result = svc.DoItUsernamePwd(EMail.Text, Password.Text, InputXml.Text.Trim())

    and i receive a string that looks like XML, but cannot be read into a dataset usinf

    DS.readXML(result)

    i receive the following error

    "Illegal characters in path."

    the text that was returned (result) is the following

    -------------------------------------------------------------------------
    <?xml version="1.0" encoding="utf-8"?>
    <AspDotNetStorefrontImportResult Version="" DateTime="11/27/2009 2:10:21 PM">
    <Get Table="Orders" Name="NewOrders" XmlPackage="DumpOrderlist.xml.config" IDColumn="OrderNumber" DefaultWhereClause="" OrderBy="OrderDate asc">
    <Criteria IsNew="1" />
    <Order OrderNumber="100002" ShowCardNumber="">
    <OrderNumber>100002</OrderNumber>
    <OrderGUID>08d1ae23-42de-4708-93cc-8ba950492c11</OrderGUID>
    <IsNew>1</IsNew>
    <ShippingMethod>Ground</ShippingMethod>
    <ReadyToShip>0</ReadyToShip>
    <IsPrinted>1</IsPrinted>
    </Order>
    <Order OrderNumber="100005" ShowCardNumber="">
    <OrderNumber>100005</OrderNumber>
    <OrderGUID>039cc6a5-5d7e-4a6f-a1dd-a97434eaf4f0</OrderGUID>
    <IsNew>1</IsNew>
    <ShippingMethod>Ground</ShippingMethod>
    <ReadyToShip>0</ReadyToShip>
    <IsPrinted>0</IsPrinted>
    </Order>
    </Get>
    </AspDotNetStorefrontImportResult>
    -------------------------------------------------------------------------

    I basicalley need an easy way to load this into a dataset and have the dataset take on the schema of the XML file dynamically.

    Any ideas?
  2. 12-29-2009, 07:59 AM #2
    swheeler is offline Junior Member
    Join Date
    Oct 2008
    Posts
    17

    Default

    Your output is readable. Try pasting it into Notepad and saving it with an .XML extension. Google 'XML Notepad' to find a version of Notepad that you can download and use specifically for reading XML format. Transformation of your XML data to a different XML format can be accomplished with XSLT style sheets.