I have seen this issue when using OleDB rather than Sql .... when I tried to see if I could get the same error as you did, in the initial steps of the wizard, when it asks for the connection string, the first time I tried this I used a generic connection string such that the wizard generated OleDbCommands and OleDbDataAdapters instead of SqlCommand and SqlDataAdapter. When that happened, it did NOT like me using a parameter. When I tried it again and gave it a connection string that was clearly a Sql connection string, then it allowed the parameter.

Personally, I don't recommend the use of TableAdapters. If you're not using SQL, and you need to use OleDb then I don't know how you can get around this issue.

I could be wrong ... I might be missing something, since I don't use TableAdapters myself.

~~Bonnie




>Thanks for the reply.
>
>
>I am fill in the sql statement during one of the step of TableAdapter Configurator Wizard .
>
>Here are the steps :
>
>1. add new item to the project
>2. select dataset, the tableadapter Configurator wizard start
>3. add tableAdapter
>4. enter sql statement <---- this step
>
>SELECT id, po, item, cusid, `date`,lorryno
>FROM product
>WHERE cusid = @cusid
>
>at the end of the wizard, it prompt me error message :
>
>generated select statement
>error in where clause near '@'.
>
>
>TIA.