Help required. SQL Server queries through Visual Basic. Will pay if problem is solved

Basically, what i am trying to do is i have a form in visual basic which allows the user to choose features of a product that they wish to buy via clicking on combo - boxes. Once a selection has been chosen and the "view products" button has been clicked, the products that match the features chosen by the user will be displayed. As you'll know this will be done through a query from a SQL server database.

All that is required is example code that shows how to query the sql database.

So for example :
If Brand_ComboBox.SelectedIndex = 0 Then
?????????

So if the first option in the brand combobox is chosen, what other code would be needed?

What version of VB are you using?

You are better off posting this thread in the database section instead.

Anyway, the sql my look something like...

Code:

---

"SELECT * FROM Table WHERE Field = '" & Brand_ComboBox.List(Brand_ComboBox) & "'"

---