dataset Issues
This is all very confusing, but I'm trying.
I am using strongly typed datasets, that I simply drag on to the form.
I have a dataset created here:
Me.PODetailTableAdapter.Fill(Me.PODataSet.PODetail)
Its there, because I have a datagridview that uses it. Now I want to
take all the detail lines and write them to another table.
now how do I access this data. I come from the fox world and am used
to working with cursors.
I tried this:
For i = 1 To Me.POtDataSet.Tables("PODetail").Rows.Count - 1
MsgBox(Me.PODataSet.Tables("PODetail").Rows(i).Item("Item_Nr"))
Next
but that gives me ALL the data from the backend. I want the data that
I have currently loaded on the form.
I do know how to create a dataReader and loop thru it, but I figure
since the data is already loaded on the form, I don't want to keep
reloading redundant data.
Some day soon, something will click and I will understand all this.
Thanks for your help
Date:Sat, 28 Jul 2007 13:41:36 -0600
Author:
|