Intersoft Community - WebGrid Enterprise - Webgrid with XML data source

Webgrid with XML data source

jasonw43 — Mon, 15 Nov 2010 16:43:22 GMT

Yep, see it now. Thanks for that.

Webgrid with XML data source

Glayaar — Fri, 12 Nov 2010 02:21:34 GMT

Based on my test, it seems XMLDataSource only accept allow data as attribute. In this scenario, you could applu a transform file to translate the text node into an attribute. Attached is the transformation file I used to thest this scenario and here is the XMLDataSource snippet:

<asp:XmlDataSource ID="XmlDataSource1" runat="server" 
    DataFile="CustomerData.xml" XPath="Rows/Row" 
    TransformFile="CustomerTransform.xsl"></asp:XmlDataSource>

Webgrid with XML data source

jasonw43 — Wed, 10 Nov 2010 22:37:28 GMT

Sorry, file didn't seem to come across. Here it is.

Webgrid with XML data source

jasonw43 — Wed, 10 Nov 2010 22:36:37 GMT

I am trying to use the Webgrid to display XML output from an ERP system called Syspro. The XML output differs to the catalog example that comes with the software.

I can get the catalog example to work, but not the attached XML. I would really appreciate some thoughts on how to setup the web grid to get it to display the Customer and the name fields in the XML string.

Thanks,

Jason.