How to search for the next word in a cell of a datagridview with a database? (VB.NET)(WindowsApplication)
<p>I have no idea how to do this, and thus I want to ask this question.
It's a windows form application, where I will search for the word in a datagridview, I've been searching High and Low for the reference and it seems like I'm out of options.</p>

<p>To be precise, I know the code, there's no error, everything's working but not like I expected.</p>

<p>First here is the Image:
<a href="https://i.stack.imgur.com/8QGta.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8QGta.png" alt="Query"></a></p>

<p>Then the code:</p>

<pre><code>If query.Text &lt;&gt; "" Then
        adapter = New OleDbDataAdapter("select * from JobOrders where CLIENT like('" &amp; query.Text &amp; "%') order by datereceived", myconnection)

        data = New DataSet
        adapter.Fill(data, "JobOrders")
        dgjobs.DataSource = data.Tables("JobOrders").DefaultView

    Else
        grid()
    End If
</code></pre>

<p>There are still fields I included from the command, for now I only put CLIENT there from the code. Sorry if my database is like, from a stone age.</p>

<p>The problem is, I want to enter a text, for example "clinic", Since I have 20,000+ records, I know there are still entries from the column client like "Remita clinic", or "Delos Santos Dental Clinic" and I want that entry to show too!</p>

<p>Is there a way?? My brain's about to burst!</p>