Executing SQL queries in VB at runtime

[Baal]

I started typing this post last night, but then decided to do another day of research before giving up and seeking help from here.

I'm going to be as brief as possible, since there really is no need for a huge amount of details.

Basically, I need to execute SQL queries at runtime based on user interaction.

So, for example, take this:

dim strCategorySelect as String

strCategorySelect = txtCategorySelect.text

SELECT title, etc.
FROM Book
WHERE CategoryID = strCategorySelect

I have a data grid view listing the categories of books from the database, and then I need to be able to display one category in another data grid view based on what the user types into the textbox.

Obviously there's a million more things I need to do, and I'm very flexible about how I do them, however if I figure out this one thing, I should be able to do everything else that needs to be done very easily.

Here's how I have it set up now, except I'm cheating because I have two data grid views set up on top of each other that are set to visible or invisible based on what the user types into the textbox.

Help me please before I kill myself