How write parameterised command in ADODC commnd text

Question

I have one table there is id field i want to compare with textbox.text when i write command as like select * from Table1 where id = text1.text

that time this popup mssage will display no value given for one or more required parameter

Plz Help Me

Answer 1

You'll need to use ADODB.Parameter class along with the ADO.Command. Here's an example: http://www.freevbcode.com/ShowCode.asp?ID=3687