Add Dynamic Filter To A Not Bounded Datagridview?

I have a datagridview which get filled with an sql query like this;

Dim strQuery As String = "SELECT * FROM tablename"
SQLConn.ConnectionString = ConnectionString
SQLConn.Open()

[Code]....

Now I wanted to add a textbox that works like a filter when someone enters some text in the textbox the ontextchange event add's a LIKE filter for that word on columnname1.

Is something like that possible on the way how I fill my datagridview? On google you'll get some examples only those are with a bounded dataset and that's not working with my datagridview.