1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| string strXMLPart = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>";
strXMLPart += "<participants>";
strXMLPart += "<participant id=\"1\">";
strXMLPart += "<nom>NOM1</nom>";
strXMLPart += "<prenom>PRENOM1</prenom>";
strXMLPart += "<datenaissance>1978-01-11</datenaissance>";
strXMLPart += "</participant>";
strXMLPart += "<participant id=\"2\">";
strXMLPart += "<nom>NOM2</nom>";
strXMLPart += "<prenom>PRENOM2</prenom>";
strXMLPart += "<datenaissance>1979-11-11</datenaissance>";
strXMLPart += "</participant> ";
strXMLPart += "<participant id=\"3\">";
strXMLPart += "<nom>NOM3</nom>";
strXMLPart += "<prenom>PRENOM3</prenom>";
strXMLPart += "<datenaissance>1980-12-14</datenaissance>";
strXMLPart += "</participant>";
strXMLPart += "</participants>";
// Response.Write("strXMLPart : " + strXMLPart);
//XmlTextReader reader = new XmlTextReader(new StringReader(strXMLPart));
//DataTable datTablePart = new DataTable("TableName");
//datTablePart.ReadXml(reader);
DataSet dataSet = new DataSet();
DataTable dataTable = new DataTable("participant");
dataTable.Columns.Add("nom", typeof(string));
dataTable.Columns.Add("prenom", typeof(string));
dataTable.Columns.Add("datenaissance", typeof(DateTime));
dataSet.Tables.Add(dataTable);
StringReader xmlSR = new StringReader(strXMLPart);
XmlTextReader xmlTextReader = new XmlTextReader(
dataSet.ReadXml(xmlSR, XmlReadMode.IgnoreSchema);
foreach (DataTable dataTable2 in dataSet.Tables)
{
foreach (DataRow row in dataTable2.Rows)
{
Response.Write (row["nom"] + "<br>");
Response.Write(row["prenom"] + "<br>");
Response.Write(row["datenaissance"] + "<br>");
}
} |
Partager