Is there an easy way for searching codes in vb.net?

See more:

VB

Good Day!
I hope someone can help me, I am trying to create an efficient way of searching records in my database. For Example: I Have Table that contains the list of courses, in my system I will allow users to check if the course they wanted is already in the database.

At first, I am showing the user all the list of available courses and there is a textbox where in they can type words/course that will search from the database and will be displayed in the gridView all matching courses either perfect match or some words only matches.

I tried getting each words using regex and i manage to get each word typed by the user what i want to happen now is to search this words for matching courses in the database. but i can't show the selected data in the gridview. Hope you can help me..

Thank you very much.

Dim myMatches As MatchCollection
        Dim myRegex As New Regex("\w+")
        Dim t As String
        t = TextBox5.Text
        myMatches = myRegex.Matches(t)
        ' Search for all the words in a string
        Dim successfulMatch As Match
        For Each successfulMatch In myMatches
            ListBox1.Items.Add(successfulMatch.Value)
            Dim sql As String = " Select * from Courses_Tbl where Crs_Desc Like ''"& t &"'%' or  Crs_Desc Like '%'"& t &"''"
        Dim adp As New SqlDataAdapter(sql, con)
        Dim com As New SqlCommand(sql, con)
       Dim adp As New SqlDataAdapter(sql, con)
        Dim ds As New DataTable
       adp.Fill(ds)

        Next
        GridView2.DataSource = ds
        GridView2.DataBind()

        Next
        GridView2.DataSource = ds
        GridView2.DataBind()