i using ADODC to link to my database. If i only want to retrieve particular data where the condition i put in textbox, what should i do?

eg.
Select * from customer
where CustomerCode = text1.text

***this code can't work...what's the correct way?