Hi all first post!
I am attempting to read an XML and display certain portions of the XML in a datagridview. I was able to get one table at a time, but I am having trouble figuring out how to get ALL the info I want from the XML and not just one table at a time. I was speaking to someone and they told me that my issue is that the dataset contains datatables and it's not just one big piece of information that I can use. I looked into merge code, but I haven't managed to get anything working the way I would like.
Below is what I have so far:
Imports System.Xml Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim xmlFile As XmlReader xmlFile = XmlReader.Create("C:\XMLtesting\FVOD_az20100427152451.xml", New XmlReaderSettings()) Dim ds As New DataSet ds.ReadXml(xmlFile) DataGridView1.DataSource = (ds.Tables(0, 1)) End Sub End Class