filtering a datagrid with a textbox

i haf a datagrid bounded to a adodc control to view my table in the database

i'm trying to filter the view using a textbox
*e.g. typing 20/06 (the date) into the textbox and the datagrid will show all records that are of the same date

and also after filtering, i want to be able to edit a column using a combo box

i've done the project, it can view the table and edit the 'attendance status' column using the combox box, all i lack now is to filter the data shown.

can any1 help? thx alot in advance

i've attached the project