how do you make a custom filter that uses a textbox, button and a radgrid work together. here is the scenario: the user types in the textbox what he is searching for then clicks the button which searches the radgrid's hidden column (hidden colums hold all the other columns' data in one column.)
my SQL Statement is : "SELECT accountId, name, .... , CONVERT (varchar(1024), accountId) + ', ' + name AS Expr1 FROM Account WHERE Expr1 IN ("+ RadTextBox1.Text+")";
my SQL Statement is : "SELECT accountId, name, .... , CONVERT (varchar(1024), accountId) + ', ' + name AS Expr1 FROM Account WHERE Expr1 IN ("+ RadTextBox1.Text+")";