VB.NET: Use a Textbox to filter Data

Question

Here is my code:

Dim connectionString As String ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\ACCESS DATABASE\search.mdb"

Dim selectCommand As String
Dim connection As New OleDbConnection(connectionString)

selectCommand = "select * from GH  WHERE (COURSE='BSIT')"
Me.dataAdapter = New OleDbDataAdapter(selectCommand, connection)

I want to know how to use a textbox to filter data. Because this code will have to enumerate all of the courses, and will need much buttons.

Answer 1

No sure I understand the question correct. Try this

selectCommand = "select * from GH  WHERE (COURSE='" & TextBox1.Text & "')"

Also you need to avoid single quotes(') on the textbox.