MySQL ADO.Net Command Text Quries ?

[rubicon]

How do you get form variables and substitute them into text queries using ADO.NET and also ensure that the common language runtime (CLR) does not confuse your variables for literal strings ? It was easy to do this with classic ASP, but not with .Net

 

Approximately 80% of MySQL ADO.Net examples online have SQL values hardcoded.

 

D Connector/ODBC with Microsoft .NET:

http://www.mysql.com/products/myodbc/manual.html#ODBC.NET(C#)

http://www.mysql.com/products/myodbc/manual.html#ODBC.NET(VB)

 

Approximately all MySQL ADO.Net text query examples are simple selects and there are very little or no action text query examples.

 

They have all been parametized and it is a mission to configure the native drivers for Visual Studio .NET.

eg insert, update, alter table, drop

[Teapot]

Hello,

do you have success in using native driver for Oracle? I'm having Visual C++ .net 2003

 

Please help!