When I read a XmlDocument into a DataSet, the structure defined in the schema is created but the datarows are not being populated.
Dim XMLreader As StringReader = New System.IO.StringReader(XMLstring)
Dim DS As DataSet = New DataSet
DS.ReadXml(XMLreader, XmlReadMode.ReadSchema)
Dim dr As DataRow = DS.Tables(0).Rows(0) ' <= error: "there is no row at position 0"
The rows collection has a count of 0. I know there around a hundred rows in the Xml string.
I googled around, but nearly all the examples are the same or similar to one I have here.
I would not mind if the xml string is flawed. but no error or exception is generated. The dataset's HasErrors reports false.
Any help would be great.
Greg Reichert