please tell me how to convert xml file to datatable

Question

i am using following code to convert xml file to datatable but its just creating multiple tables (but without data) and i want tables with data..

Dim myDS As New DataSet
    Dim xmlStream As System.IO.StreamReader = New System.IO.StreamReader(Server.MapPath("~\xmldoc\result_availhotel.xml"))
    myDS.ReadXmlSchema(xmlStream)
    Response.Write(myDS.Tables.Count)

Answer 1

ReadXmlSchema only reads the Schema (structure) not the data. Use ReadXml instead.