Select statement that uses a variable, result to a text box

[DogTailRed2]

Hi,

I'm relatively new to VB.
I want to perform a SELECT statement that uses a variable to return a value, example;

mysql> SELECT room_description FROM room_descriptions WHERE current_room = 'someVariable';

and display the result in a TextBox i.e. TextBox.text = someVariable.

So how do I perform a query from VB that passes a variable?
How do I assign the result to a variable?

Also, is there an excellent book or web site the demonstrates all these things in simple examples?

Many thanks,

Ted.

[Hack]

Welcome to the forums.

Change myConnection to whatever you are using as your connection object.

SqlCommand and SqlDataReader are only valid for SQL Server. If that is what you are using, then you are good. If not, then they need to be changed as appropriate.

Dim sSQL As String
sSQL = "SELECT room_description  "   
sSQL = sSQL & "FROM room_descriptions "
sSQL = sSQL & "WHERE current_room  = @Room "
Dim command As New SqlCommand(sSQL, myConnection)        
command.Parameters.AddWithValue("@Room", txtRoom.Text)       
Dim reader As SqlDataReader = command.ExecuteReader()
reader.Read()
TextBox1.Text = reader.GetString(0)
reader.Close()

[jmcilhinney]

It would actually be better to call ExecuteScalar, which is intended for queries that return a single value, rather than ExecuteReader. The rest would be the same but this part:

Dim reader As SqlDataReader = command.ExecuteReader()
reader.Read()
TextBox1.Text = reader.GetString(0)

would become:

TextBox1.Text = CStr(command.ExecuteScalar())

[DogTailRed2]

Hi,

many thanks to you both for the replies.
I'll give this a go and get back to you.

Cheers,

Ted.