ASP.NET ODBC Query with parameters

by

From MSDN:

When CommandType is set to Text, the .NET Framework Data Provider for ODBC does not support passing named parameters to an SQL statement or to a stored procedure called by an OdbcCommand. In either of these cases, use the question mark (?) placeholder. For example:

SELECT * FROM Customers WHERE CustomerID = ?

Rewrite your query to

OdbcConnection conn = new OdbcConnection(connString);
    String query = "INSERT INTO customer (custId, custName, custPass, "+
                   "custEmail, custAddress, custAge) VALUES (" +
                   "?, ?, ?, ?, ?, ?)";

Order of Parameter counts!

EDIT: Parameter can be added this way:

OdbcCommand exe = new OdbcCommand(query, conn);
exe.Parameters.Add("ID", OdbcType.UniqueIdentifier).Value = id;
exe.Parameters.Add("Name", OdbcType.VarChar).Value = name;
exe.Parameters.Add("Pass", OdbcType.VarChar).Value = pass;
exe.Parameters.Add("Email", OdbcType.VarChar).Value = email;
exe.Parameters.Add("Address", OdbcType.VarChar).Value = address;
exe.Parameters.Add("Age", OdbcType.Int).Value = age;

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Search SQL by date ASP.NET
  3. Sql: Incorrect syntax near ‘(‘ [closed]
  4. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  5. Is there a good LINQ way to do a cartesian product?
  6. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  7. Entering keys manually with Entity Framework
  8. Read SQL Table into C# DataTable
  9. Pass table valued parameter using ADO.NET
  10. DropdownList DataSource
  11. Stop SQL query execution from .net Code
  12. What is passing parameters to SQL and why do I need it?
  13. How to make LINQ execute a (SQL) LIKE range search
  14. Index (zero based) must be greater than or equal to zero
  15. Check if a SQL table exists
  16. no overload for method “ToString” takes 1 arguments
  17. Database Error: There is no row at position 0
  18. Passing data between different controller action methods
  19. OnclientClick and OnClick is not working at the same time?
  20. Read Post Data submitted to ASP.Net Form
  21. The client and server cannot communicate, because they do not possess a common algorithm – ASP.NET C# IIS TLS 1.0 / 1.1 / 1.2 – Win32Exception
  22. Do I need a Global.asax.cs file at all if I’m using an OWIN Startup.cs class and move all configuration there?
  23. What is the best way to determine a session variable is null or empty in C#?
  24. How to make the .net HttpClient use http 2.0?
  25. ASP.NET 5 add WCF service reference
  26. C#, FindControl [duplicate]
  27. Restrict route to controller namespace in ASP.NET Core
  28. Unable to serialize the session state
  29. How to insert data into SQL Server
  30. Could not load file or assembly ‘System.Net.Http.Formatting’ or one of its dependencies. The system cannot find the path specified

Leave a Comment