I am writing an application in vb.net 2008 to extract multiple xml files selected from a destined folder. App has managed to select a folder, then it reads each xml file one by one inset the data in dataset.
After the app inserts xml into dataset I want to establish relationship among tables created in the data set.
For more info xml has this strucure:
So I want to establish relationship as Each file will have 1 customer, 1 or many sites, each site will have more than 1 meters and each meters will have more than 1 channels.
If any one help me in this I would appreciate. Please not the xml files are of the size of 80 to 90Kb therefore it contains lot of data.
Here is the code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Open the Folder Browser Dialog
'Dim dsOutput As New Data.DataSet Dim fb As New FolderBrowserDialog Dim count As Integer With fb
View Complete Post