How to bind parameters via ODBC C#?

by

Odbc cannot use named parameters. This means that the command string uses placeholders for every parameter and this placeholder is a single question mark, not the parameter name.

OdbcCommand.Parameters

Then you need to add the parameters in the collection in the same order in which they appear in the command string

OdbcCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM [user] WHERE id = ?";
cmd.Parameters.Add("@id", OdbcType.Int).Value = 4;
OdbcDataReader reader = cmd.ExecuteReader();

You have also another problem, the USER word is a reserved keyword per MS Access Database and if you want to use that as field name or table name then it is required to enclose every reference with square brackets. I strongly suggest, if it is possible, to change that table name because you will be hit by this problem very often.

More Related Contents:

  1. static void Main(string[] args) [closed]
  2. Get URL parameters from a string in .NET
  3. OdbcConnection returning Chinese Characters as “?”
  4. Reflection: How to Invoke Method with parameters
  5. What is the use of “ref” for reference-type variables in C#?
  6. How do I assign by “reference” to a class field in C#?
  7. C# “Parameter is not valid.” creating new bitmap
  8. ‘UserControl’ constructor with parameters in C#
  9. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  10. How to pass parameters to another process in c#
  11. In C#, what happens when you call an extension method on a null object?
  12. MySqlCommand Command.Parameters.Add is obsolete
  13. How to pass anonymous types as parameters?
  14. Passing just a type as a parameter in C#
  15. Is there a reasonable approach to “default” type parameters in C# Generics?
  16. Interesting “params of ref” feature, any workarounds?
  17. thread with multiple parameters
  18. When is using the C# ref keyword ever a good idea?
  19. C# constructing parameter query SQL – LIKE %
  20. use decimal values as attribute params in c#?
  21. How do the In and Out attributes work in .NET?
  22. “this” in function parameter
  23. How does C# choose with ambiguity and params
  24. Oracle Parameters with IN statement?
  25. Can I have a variable number of generic parameters?
  26. C# : how to – single instance application that accepts new parameters?
  27. problem using Oracle parameters in SELECT IN
  28. Can I get parameter names/values procedurally from the currently executing function?
  29. Singleton with parameters
  30. Passing parameters to the base class constructor

Leave a Comment