INSERT Query with Parameter List

[KenYeung]

I am using ADO.Net to do an action (Insert) query on MS Access. I set up an parameter collection through the OleDBCommand object and try to map the parameter objects in the collection to the names specified in the CommandText in the OleDBCommand object. However, I found that the mapping was not successful. Access instead took the order of the statements of which the parameter objects were added to the parameter collection.

Can anyone confirm that Access does not support parameter collection mapping in ADO.Net (OleDbCommand)?

Thanks.

 

[KenYeung]

Problem confirmed

I found the answer from MSDN. Those who interested may look into this link:

http://msdn.microsoft.com/library/d...dataoledboledbcommandclassparameterstopic.asp

Thanks anyone looking into this problem.