C Sharp :: Using Textbox To Filter From DataGridView And SQLite Database

I'm trying to get some more user friendly things in my program done. Now I'm trying to filter by typing in a text box and it filters to what you are typing and shows the entire row.

This is what I currently have:

private void txtFilter_TextChanged(object sender, EventArgs e) {
            try  {
                SQLiteConnection connect = new SQLiteConnection(connString);
                connect.Open();

[Code] ....

I get an exception error though:

SQLite error
near "'N'": syntax error

// N is what I started typing to start the filter.

Ok, so I've edited the code now to this:

private void txtFilter_TextChanged(object sender, EventArgs e) // FILTER TODO {
                DataView view = new DataView();
                SQLiteConnection connect = new SQLiteConnection(connString);
                connect.Open();
                view.RowFilter = "Channel like '%" + txtFilter.Text + "%'";
        }

No more exception errors, just not what I want it to do. It just keeps everything there.