Retreving values from a row in the dataset

[jennyek2000]

I want to retreive the value of the primary key of the last row in a dataset. I have used the following code so far,

Dim mydataset As New DataSet()

myDataAdapter = New OleDbDataAdapter("SELECT * FROM transmittals", myConnection)
myDataAdapter.Fill(mydataset, "transmittals&quot

Dim bmtransmittals As BindingManagerBase
bmtransmittals = Me.BindingContext(mydataset, "Transmittals&quot
bmtransmittals.Position = bmtransmittals.Count - 1

Hopefully this code has got me to the last row in the dataset? But now how do I retreive the value of the primary
key (transNo) so that I can display it in a text box?

Thanks,
Jenny

 

[Ragnarox]

Hello,

Bind the text box that you want to show the data to the primary key of your data. I tried this on my form and it worked.

Hope this helps

Brian

BTW : Thanks for your help earlier.