Manipulate results of sql query from ADO

[Gum]

ADO.net discussion group said that this is out of scope. I have the following:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'myDataSet.myFunction'
table. You can move, or remove it, as needed.
Me.myFunctionTableAdapter.Fill(Me.myDataSet.myFunction)

End Sub


I need to be able to manipulate the results of the query in VB.net. I can
do quite a lot using the queries, but how do I get the results in a VB.net
variable that I can manipulate?

 

[Cor Ligthert[MVP]]

Gum

dim a as string = myDataSet.myFunction.Rows(0)(0).ToString

(first item in first row)

Cor