How i can read xml into DataTable type object?

Jayden Bell 2211 30 Jan 2014

I don't have problem if i read xml to DataSet:

DataSet temp = new DataSet();
temp.ReadXml(UncompressedStream,
System.Data.XmlReadMode.Auto);

But if i use DataTable:

DataTable temp = new DataTable();
temp.ReadXml(UncompressedStream);
then datatable not load data (count of columns and rows
equal 0 )

How i can read xml to DataTable

My temporary solution:

DataSet temp = new DataSet();
DataTable structure = new DataTable();
temp.ReadXml(UncompressedStream,
System.Data.XmlReadMode.Auto);
structure = temp.Tables[0];

Ask by Jayden Bell

Updated 30 Jan 2014

private static void DemonstrateReadWriteXMLDocumentWithString()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintValues(table,"Original table");
    string fileName ="C:\\TestData.xml";
    table.WriteXml(fileName, XmlWriteMode.WriteSchema);
    DataTable newTable= new DataTable();
    newTable.ReadXml(fileName);
    // Print out values in the table.
    PrintValues(newTable, "New table");
}
private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);
    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);
    // Add ten rows.
    DataRow row;
    for (int i = 0; i<= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }
    table.AcceptChanges();
    return table;
}

forum

How i can read xml into DataTable type object?

Can you answer this question?

1 Answers