Beginner's TextBox and Gridview and SQL Select question

[h8226]

This is my first ASP.NET project.

I have a textbox where I can type multiple text strings and a gridview that displays the result from an SQL SELECT based on what's in the textbox.

For example, if the textbox has "abc def -xyz" then the gridview would display all records that have the substrings 'abc' and 'def' and NOT the substring 'xyz'.

I also want the gridview to refresh whenever the space character is entered. That means right after 'abc' and then 'def'.

How do I do that? Many thanks for your help.

 

[jbenson001]

For the auto refresh portion of your question, look in to AJAX and ICallBack.