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.