Kendo Grid Remote XML Data

Question

I have a WCF that returns the data from a remote Mysql database, the return is a simple XML, I believe because it is a simple XML is not populating my Kendo grid.

I would like an example to assemble my return XML and meet the requirements of the Kendo grid, as provided in the example of Kendo grid: https://demos.telerik.com/kendo-ui/service/Northwind.svc/Orders

Answer 1

Just create a Dataset, read the XML file in question and add the datagrid

DataSet xml = new DataSet();

xml.ReadXml("XML");

GridView.DataSource = xml.Tables[0];