I have a table adapter which returns a row from a users table based on a parameter
eg select * from users where username = 'Peter'
This works fine though what i want to do is when it returns the data below,
Username Email City
Peter Pete@Pete.com Edinburgh
I would like to enter the email value into a label or a Variable...
Dim SelectedEmail AS String=Useradapter.getalldata(UserID).????EmailField????.AsString
It must be something stupid but I cant see an easy way to do this although I think it should be simple