Thanks in advance!

If you're using 3.5, then it can be really simple with Linq. Here, I'm retreiving the ProductName of the Product with a ProductID equal to 1. 

NorthwindDataContext db = new NorthwindDataContext();
var productName = db.Products.Single(p => p.ProductID == 1).ProductName;

Easy enough?

Here's a simple example in c# using SqlCommand.ExecuteScalar:

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPNETDBConnectionString"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT ID FROM Tests WHERE (Colour = 'Pink')", conn);
TextBox1.Text = Convert.ToString(cmd.ExecuteScalar());      // Put the ID value from the query in the textbox
cmd.Dispose();
conn.Dispose();

I am sorry, I realized that I did not provided enough information. Hereby some more detail:

I am using VB, not C. Unfortunately I can't use ASP.NET 3.5 as my provider only supports version 2.0. I am using Visual Studio 2005 to put my website together.

This is the code that I used so far but I have the feeling that I am doing something way to complicated. Afterall,k I am only trying to retrieve one single string value out of a database using a SELECT command:

Imports System.Data.SqlClient

For Each connection As ConnectionStringSettings In connections

If connection.Name = "ServerListConnectionString" Then

Exit For

End If

Next

"SELECT [BesrApproved] FROM [manualInfo] WHERE ([name] = @name)"

Dim command As New SqlCommand(queryString, connection)

' Call Read before accessing data.

End While

' Call Close when done reading.

reader.Close()

Your code is fine if it's working ok, and it's not too complicated really. Using a SqlDataReader is a perfectly valid way to get at your data. My only suggestion would be looking at SqlCommand.ExecuteScalar as I posted earlier. This returns a single value from a query so seems to be what you're looking for. Instead of using a SqlDataReader, you'd just use:

LabelUserName.Text = Convert.ToString(command.ExecuteScalar())

I wasnt able to work on the website for a while but I tried that command today and it worked like a charm. Thanks!