OleDbCommand parameters order and priority

by

According to http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbcommand.parameters.aspx OleDbCommand does not support named parameter

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.

So order of parameter is important.

More Related Contents:

  1. OLEDB Parameterized Query
  2. Trying to insert DateTime.Now into Date/Time field gives “Data type mismatch” error
  3. What’s wrong with these parameters?
  4. How to connect to a MS Access file (mdb) using C#?
  5. Access SQL syntax error when using OleDbCommandBuilder
  6. Do we have transactions in MS-Access?
  7. MetadataException: Unable to load the specified metadata resource
  8. ADO.NET |DataDirectory| where is this documented?
  9. Get the generated SQL statement from a SqlCommand object?
  10. Get connection string from App.config
  11. Using Excel OleDb to get sheet names IN SHEET ORDER
  12. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  13. Can you get the column names from a SqlDataReader?
  14. Is it necessary to manually close and dispose of SqlDataReader?
  15. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  16. How to create a DataTable in C# and how to add rows?
  17. ado.net Closing Connection when using “using” statement
  18. How to pass a table-value parameter
  19. How to keep single SQL Server connection instance open for multiple request in C#?
  20. Fill an array (or arraylist) from SqlDataReader
  21. How to use SqlCommand to CREATE DATABASE with parameterized db name?
  22. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  23. Optimal way to Read an Excel file (.xls/.xlsx)
  24. How do I extract data from a DataTable?
  25. Persist Security Info Property=true and Persist Security Info Property=false
  26. What is the difference between dataview and datatable?
  27. Reading a date using DataReader
  28. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  29. Retrieve List of Tables in MS Access File
  30. How to give ADO.NET Parameters

Leave a Comment