Probably a simple question - but im a noob here.
I am building a website using asp.net in VS 2005 using c#. i have a grid view that is pulling values from a table on my sql database. All fine so far, but what i would like to do is filter these results by values entered in text boxes.
For example, there is a textbox for ID number. i would like the user to enter a value in to this box and for the gridview to filter its results by the value in this field.
I built the query that brings this data in to the gridview with the query builder wizard , but i couldnt see in there how to link the SQL query WHERE declarations to a field on my form.
Ideally what i want to see is:
select * from customers
where ID = textbox1.value
Is this indeed possible?