Click to See Complete Forum and Search --> : Beginner's TextBox and Gridview question


h8226
November 22nd, 2008, 03:03 AM
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.

HanneSThEGreaT
November 22nd, 2008, 04:47 AM
What have you done up to so far ¿

h8226
November 22nd, 2008, 05:15 AM
What have you done up to so far ¿

I have both controls and can display the result in the gridview with a simple string in the textbox such as "abc" after the user hit return.

I now want to improve the user experience, by allowing a more complicated search (adding in AND and NOT) and use space ' ' to trigger the search instead of return.

Many thanks for your help.