Hi, I´m trying to read an XML from a webservice to a datagrid, but I can´t fill the datagrid with the values. What I´m doing wrong?
The webservice returns:
<?xml version="1.0" encoding="UTF-8"?>
<ArrayOfTabela2 xmlns="http://tempuri.org/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<tabela2>
<codigo>F</codigo>
<descricao>Feminino</descricao>
</tabela2>
<tabela2>
<codigo>M</codigo>
<descricao>Masculino</descricao>
</tabela2>
</ArrayOfTabela2>
And the HTML5 file is the following:
<!DOCTYPE html>
<html>
<head>
<title></title>
<link href="styles/kendo.common.min.css" rel="stylesheet" />
<link href="styles/kendo.default.min.css" rel="stylesheet" />
<script src="js/jquery.min.js"></script>
<script src="js/kendo.all.min.js"></script>
</head>
<body>
<div id="grid"></div>
<script>
var dataSource = new kendo.data.DataSource({
transport: {
read: {
type: 'POST',
processData: false,
dataType: "xml",
url: "http://localhost:28301/Vacinacao.asmx/retornaDataTable?tabela=SEXO",
contentType: "text/xml"
}
},
schema: {
type: "xml",
data: "/ArrayOfTabela2/tabela2",
model: {
fields: {
codigo: "codigo/text()",
descricao: "descricao/text()"
}
}
}
});
dataSource.read();
$("#grid").kendoGrid({
dataSource: dataSource,
pageable: true
});
</script>
</body>
</html>
If I change the block bellow for a fixed data, it works fine.
transport: {
read: {
type: 'POST',
processData: false,
dataType: "xml",
url: "http://localhost:28301/Vacinacao.asmx/retornaDataTable?usuario=DES_VALE&senha=DES_VALE&tabela=SEXO",
contentType: "text/xml"
}
},
-------
data: '<?xml version="1.0" encoding="UTF-8"?><ArrayOfTabela2 xmlns="http://tempuri.org/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><tabela2><codigo>F</codigo><descricao>Feminino</descricao></tabela2><tabela2><codigo>M</codigo><descricao>Masculino</descricao></tabela2></ArrayOfTabela2>',
Thanks for any help!
Vitor
The webservice returns:
<?xml version="1.0" encoding="UTF-8"?>
<ArrayOfTabela2 xmlns="http://tempuri.org/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<tabela2>
<codigo>F</codigo>
<descricao>Feminino</descricao>
</tabela2>
<tabela2>
<codigo>M</codigo>
<descricao>Masculino</descricao>
</tabela2>
</ArrayOfTabela2>
And the HTML5 file is the following:
<!DOCTYPE html>
<html>
<head>
<title></title>
<link href="styles/kendo.common.min.css" rel="stylesheet" />
<link href="styles/kendo.default.min.css" rel="stylesheet" />
<script src="js/jquery.min.js"></script>
<script src="js/kendo.all.min.js"></script>
</head>
<body>
<div id="grid"></div>
<script>
var dataSource = new kendo.data.DataSource({
transport: {
read: {
type: 'POST',
processData: false,
dataType: "xml",
url: "http://localhost:28301/Vacinacao.asmx/retornaDataTable?tabela=SEXO",
contentType: "text/xml"
}
},
schema: {
type: "xml",
data: "/ArrayOfTabela2/tabela2",
model: {
fields: {
codigo: "codigo/text()",
descricao: "descricao/text()"
}
}
}
});
dataSource.read();
$("#grid").kendoGrid({
dataSource: dataSource,
pageable: true
});
</script>
</body>
</html>
If I change the block bellow for a fixed data, it works fine.
transport: {
read: {
type: 'POST',
processData: false,
dataType: "xml",
url: "http://localhost:28301/Vacinacao.asmx/retornaDataTable?usuario=DES_VALE&senha=DES_VALE&tabela=SEXO",
contentType: "text/xml"
}
},
-------
data: '<?xml version="1.0" encoding="UTF-8"?><ArrayOfTabela2 xmlns="http://tempuri.org/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><tabela2><codigo>F</codigo><descricao>Feminino</descricao></tabela2><tabela2><codigo>M</codigo><descricao>Masculino</descricao></tabela2></ArrayOfTabela2>',
Thanks for any help!
Vitor