Questions tagged [mysql-parameter]

MySqlParameter is a class in .NET MySQL connector.

19 questions
0
votes
1 answer

Parameterized MySql INSERT query not having right parameters value

I'm trying to do a basic insert statement using a parameterized query. My problem is whatever the syntax I'm using it seems like the query is being done with all parameters set to null instead of their appropriate values (unless I hard-code the…
Ben
  • 3
  • 1
  • 2
0
votes
0 answers

C# MySql - String.Format vs MySql Parameters

I've been looking for an answer to my question, but i cannot find it, so here it is: Between String.Format and MySql Parameters, what is the best practice in terms of creating a query for the database. Here is how i'm using…
João Reis
  • 73
  • 5
0
votes
1 answer

How to use MySQLparameter array in Mysqlcommand to add with command

I have a mysqlcommand and mysqlparameter array [] MySqlParameter[] param = new MySqlParameter[]{ // params here }; Now I want to set the command parameter for this array. How I can do that? I got the…
anirudha
  • 1
  • 1
0
votes
2 answers

The SqlParameterCollection only accepts non-null SqlParameter type objects, not MySqlParameter objects

I have created a method that will insert any exceptions thrown into a table on "ExceptionLog" on MySql server. ExceptionLog Table format idExceptionLog int (AI) User (varchar 45) ErrorMessage (varchart 4000) The problem is i keep getting the…
Steve
  • 215
  • 7
  • 18
1
2