Simple question : How to reference a single row's data

[MU]

Hello,

I have the following code:

Dim userTableAdapter As New RSTTableAdapters.UsersTableAdapter
Dim userDataTable As RST.UsersDataTable

userDataTable = userTableAdapter.GetUserByEmailAddressPassword
(txtEmailAddress.Text, txtPassword.Text)

The query should only return 1 row. How do I reference the data
columns in the row that was sent back? I know how to do it with a
loop, but not a single row.

Thanks

 

[randy.buchholz]

If you are trying to get scalars and not a set.you can try 'executescalar'.