Help me pls.. How can I create a flexible fillby/search in VB 2005 express?

[flushfire]

I posted this already in VB's ask a question thread but nobody's answering ATM, I really need an answer ASAP. Anyways, Im a noob in both VB and SQL so I just followed the walkthrough MS provides. I made myself a textbox that searches for data in my table/datagrid, and its working alright until I realized that I can't search for non-exact values, i.e. if I want to search for all names starting with Ch, I can't, but I have Charlies, Christians and Christophers in my table. I was playing around with:

SELECT Name FROM Table1 WHERE Name LIKE ?

By changing the arguments after WHERE but VB Express just gives me this error:

Error 1 Too many arguments to 'Public Overridable Overloads Function FillBy(dataTable As ClearanceDBDataSet.ClearanceQueryDataTable) As Integer'.

I guess I don't get the proper syntax. Im sure this is simple enough, that's why even if I googled for it I can't find it because it's easy enough to figure out but I can't. Somebody please help me. Thanks. ^_^

[flushfire]

Nevermind, I found the answer. I dunno why I never thought of it immediately. Just had to change ? to '%'+?+'%' and I got what I wanted. How do I delete my post? I don't see any delete button in the original post.

[Killer42]

Nevermind, I found the answer. I dunno why I never thought of it immediately. Just had to change ? to '%'+?+'%' and I got what I wanted. How do I delete my post? I don't see any delete button in the original post.

I wouldn't worry about deleting it. The information could be useful for anyone else who comes searching for the same answer.

(You can delete or edit a message, but only for 5 minutes after you post it.)

[flushfire]

Oh, alright, thanks. ^_^