I have the XML to data set part kinda working. the problem is that when i load the file to the data set the first row is fine but rows 2-11 don't have any data in them. (see dataFAIL.png) other than that data set works fine.
code for loading DS
Code:
Dim xmlDatadoc As New XmlDataDocument()
xmlDatadoc.DataSet.ReadXml("C:\Users\me\Desktop\XML Files\user002\user002_inv.xml", XmlReadMode.Auto)
Dim ds As New DataSet("Paint DataSet")
'Dim ds2 As New DataSet
ds = xmlDatadoc.DataSet
Now when i try to load my dataset into my datagridview nothing happens. i don't get and error and i don't get visible data.
code for loading datagridview
Code:
'BindingSource1.DataSource = ds.Tables("paint")
'BindingSource1.DataMember = "name"
'DataGridView1.DataSource = ds.DefaultViewManager
'ds2 = ds 'Me.BindingSource1
DataGridView1.DataSource = ds.Tables("paint")
DataGridView1.DataMember = "name"
as you can see i have tried many things and no have worked. so i have come to you guys fro help. What is wrong with my code that is making this not work.
NOTE: by the way the two sections of code above are all in the same button