Hi guys,

I've created a table (with Gridview) and it's expected to have a lot of rows. There's also pagination and because I didn't want the page to refresh every time the user use it, everything go through Javascript.

Now I want to implement a search option with regex support but I'm not sure what the best way is to do it. I need the search on all the rows (not only the rows of the current page).

I'm not sure if it's possible to use regex in an sql query (I searched a bit on Google but didn't really find anything that helped me). The other option would be to query all the rows and filter them on the server.

What would you do? Is there another option I didn't think of?