Hi guys,

This was easy enough to do in java....

String UserType == NameOfQuery.getString(X);

Although I know how to use a DataReader in VB code for my ASP.NET website to check to see if a record exists, I would really like to be able to use a DataSet so that I can convert a returned field from a record into a String or an Integer which can then be used in my page.

When a user is successfully logged into my website, I'd like the program to be able to look in the tblUsers table and if a field name called 'UserType' contains the String value 'Administrator' to then enable extra features to be available.

I know how to do the latter, but it's how I can give a String variable the returned 'UserType' that I'm unsure of!!!

Could someone please give me a hand with this !!

Thanks,

Si