reading a dataset

[jkw119]

ok,

does anyone know how to read a dataset...

i have an xml file that contains 3 columns of data and the following code that puts it into a datagrid on the form.

Dim myStream As System.IO.Stream
Dim openFileDialog1 As New OpenFileDialog()
 
openFileDialog1.Title = "Open an XML file to analyze"
openFileDialog1.InitialDirectory = "c:\"
openFileDialog1.Filter = "xml files (*.xml)|*.xml|All files (*.*)|*.*"
openFileDialog1.FilterIndex = 1
openFileDialog1.RestoreDirectory = True
 
If openFileDialog1.ShowDialog() = DialogResult.OK Then
myStream = openFileDialog1.OpenFile()
ProfileName = openFileDialog1.FileName
MsgBox(ProfileName)
 
Dim newDataSet As New DataSet()
newDataSet.ReadXml(ProfileName)
DataGrid1.SetDataBinding(newDataSet, "point")
     If Not (myStream Is Nothing) Then
          myStream.Close()
     End If
End If

so how do i read each colum in the datagrid into an array

column1(x), column2(x), column3(x) so i can do some calculations (like multiply each column by 3) then repopulate the dataset...

i am new to this whole database stuff, i don't even know if i need to read it into an array or what..

thanks,

jeff

[jkw119]

nevermind, i just figured it out, but for anyone elses reference...

you read a dataset like so...

first a load an xml file into a dataset
then i can access the data like this...

Dim newDataSet As New DataSet()
            newDataSet.ReadXml(ProfileName)
 
            Dim a As Single
            a = newDataSet.Tables(0).Rows(0)(1)
            MsgBox(a)

this is good stuff...

Jeff

[jkw119]

nevermind, i just figured it out, but for anyone else interested...

you read a dataset like so...

first a load an xml file into a dataset
then i can access the data like this...

Dim newDataSet As New DataSet()
            newDataSet.ReadXml(ProfileName)
 
            Dim a As Single
            a = newDataSet.Tables(0).Rows(0)(1)
            MsgBox(a)

this is good stuff...

Jeff