@Param for Access Databass

Question

User1406963893 posted

Hello All,

I have DataSet And add access database and I want to selcet from tabel by @Param

This the code

SELECT        tblname.name, tblname.office, tblname.fax, tblname.another, tblcat.cat_name
FROM            (tblname INNER JOIN
                         tblcat ON tblname.cat_id = tblcat.cat_id)
WHERE        (tblname.name =  @Param)

But show Error with "@Param"

Answer 1

User560403387 posted

OledbCommand parameters only take ? style parameters. Replace your @Param by ?, and pass in your parameters in the right order.

Menno

Answer 2

User1406963893 posted

OledbCommand parameters only take ? style parameters. Replace your @Param by ?, and pass in your parameters in the right order.

Menno

Thank you it's work :)

Answer 3

User-1199946673 posted

OledbCommand parameters only take ? style parameters.

Although this is what MSDN says, but when you test this you'll notice that named parameters are supported also... The only thing is that the name of the parameter doesn't need to be the same as the name of the parameter in the parametercollection, The parameters must be added in the same order they (first) appear in the command....