Hi all
I am a newbie.. so please be patient with me
i have been using vb6 all along
very recenty i am working myself on Visual Studio 2005

once i establised the conection to my MSAccess database (Trial.mdb) and refrence to the table (birthday_table)..uing a binding source
i am able to conect my textboxes to thetable and retrive recods in the table.
I ma using bindingnavigatpr to move throght the records and the text boxes are getting refreshed accordngly

[u]I want to retrive the value of <name> field each time the recordsource is refreshed </u>

in VB6 i will be using msgbox(adodc1.recordset.feilds("name")
in VB2005 i understand taht i have to use
....myDataTable.Rows(rowIndex)("Name")
here again...i am struck as to how will i be retiving the current-row index..aT runtimei might be missing something really silly here... so please be patinet with me

here is how i grabbed fields from a currently selected record


Dim field1 As String
Dim dr As DataRowView = Sheet1BindingSource.Current
field1 = CStr(dr.Item("Description"))
messagebox.show(field1)


this code went in my binding navigator private sub and passed the currently selected row's "Description" column of my dataset to the string field1

hope that helps !!!

squeak squeak

thnks squeak i shall let u know as soon as i try this