Manipulate results of sql query from ADO

8 Jun 2009 4:26 PM

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?

8 Jun 2009 6:18 PM

Cor Ligthert[MVP]

Gum

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

(first item in first row)

Cor

Show quoteHide quote

"Gum" <gum@nospam.nospam> wrote in message
news:D13F0225-1C93-4E41-9F55-35F939D86CB1@microsoft.com...
> 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?