Specific Data in a Field

[MTSkull]

How do I get at the specific data in a dataset field.

For Example dsDataset table has a specific row that I want data from how do I get to that specific Field?

Here is what I have tried so far.

        iCurrentRow as Int32
        dtData as DataTable
        drDataRow as DataRow

        iCurrentRow = grdResult.CurrentRowIndex()
        drDataRow = dtData.Rows.Find(CInt(iCurrentRow))
        giSelectedDoctor = CInt(drDataRow("Professional_ID").ToString)

This errors with "Object Refernce not set to an instance of this object" for line 3

Also, is it possible to navigate a dataset like a record set and if so
how.

For Example, I want to replace values in a column based on the results of anouther column. Better to do this in SQL but if I had to do it programmatically is it possible?

Thanks
Brian

 

[MTSkull]

Duh
I changed
drDataRow = dtData.Rows.Find(CInt(iCurrentRow))

to
drDataRow = dtData.Rows(icurrentrow)

and it all works fine now.