What’s wrong with these parameters?

by

Simply ask google, I guess more than 10000 hits is quite impressive. Your argument “I don’t think that…” is not valid until you proved it.

This is what MSDN says:

The OLE DB.NET Provider does not support named parameters for passing parameters to an SQL statement or a stored procedure called by an OleDbCommand when CommandType is set to Text. In this case, the question mark (?) placeholder must be used. For example:

SELECT * FROM Customers WHERE
CustomerID = ?

Therefore, the order in which OleDbParameter objects are added to the OleDbParameterCollection must directly correspond to the position of the question mark placeholder for the parameter in the command text.

More Related Contents:

  1. OleDbCommand parameters order and priority
  2. OLEDB Parameterized Query
  3. Trying to insert DateTime.Now into Date/Time field gives “Data type mismatch” error
  4. How to connect to a MS Access file (mdb) using C#?
  5. Access SQL syntax error when using OleDbCommandBuilder
  6. Using parameters inserting data into access database
  7. Writing large number of records (bulk insert) to Access in .NET/C#
  8. Using Excel OleDb to get sheet names IN SHEET ORDER
  9. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  10. how to update a table using oledb parameters?
  11. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  12. OleDbParameters and Parameter Names
  13. Parsing CSV using OleDb using C#
  14. What is IMEX within OLEDB connection strings?
  15. Query Microsoft Access MDB Database using LINQ and C#
  16. Convert Access image OLE Object into raw image byte array in C#
  17. How to create an Access database at runtime in C#?
  18. Optimal way to Read an Excel file (.xls/.xlsx)
  19. Could not find installable ISAM
  20. How to insert a record into a access table using oledb?
  21. Is there a “proper” way to read CSV files [duplicate]
  22. Refresh button – Refreshing data grid view after inserting, deleting, updating
  23. Persist Security Info Property=true and Persist Security Info Property=false
  24. Retrieve List of Tables in MS Access File
  25. Scientific notation when importing from Excel in .Net
  26. Microsoft.Jet.OLEDB.4.0 Converting Characters
  27. SQL connection string for microsoft access 2010 .accdb
  28. Do we have transactions in MS-Access?
  29. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  30. Import Excel to Datagridview

Leave a Comment