MySqlCommand removed all parameter values

Question

I have a problem with MySqlParamters in C#. I will create a new entry in the database, but MySqlCommand writes only null-values.

    MySqlCommand see = new MySqlCommand("REPLACE INTO users (login, email) VALUES (@login,@email)",this.dbcontext);

            MySqlParameter p1 = new MySqlParameter("@login",MySqlDbType.VarChar,20);
            p1.Value = "Hello";

MySqlParameter p2 = new MySqlParameter("@email", "Dude");

            see.Parameters.Add(p1);
            see.Parameters.Add(p2);

            Console.WriteLine(p2.Value);

            see.ExecuteNonQuery();

The entry in my database is

login   email
------------------
null    null

What can I do?

score 0 · Accepted Answer · answered Nov 15 '13 at 11:20

Doesn't the MySql connector use ? for parameters? (@ are user variables) - so:

using(var see = new MySqlCommand(
    "REPLACE INTO users (login, email) VALUES (?login,?email)",this.dbcontext))
{
    MySqlParameter p1 = new MySqlParameter("login",MySqlDbType.VarChar,20);
    p1.Value = "Hello";
    MySqlParameter p2 = new MySqlParameter("email", "Dude");
    see.Parameters.Add(p1);
    see.Parameters.Add(p2);
    see.ExecuteNonQuery();
}

or if you like some "dapper":

this.dbcontext.Execute(
    "REPLACE INTO users (login, email) VALUES (?login,?email)",
    new { login = "Hello", email = "Dude" }
);

score -1 · Answer 2 · edited May 23 '17 at 11:56

-1

see this...

Find and Replace text in the entire table using a MySQL query MySQL Replace query http://dev.mysql.com/doc/refman/5.0/en/replace.html

edited May 23 '17 at 11:56

Community

1
1

answered Nov 15 '13 at 11:27

user2927075

53
2
7

None of these are even remotely related to the question – Marc Gravell Nov 15 '13 at 11:46
i need your help Marc. i want how to do upload and download files to database in asp.net c# using attribute based encryption and decryption... – user2927075 Nov 15 '13 at 11:55

MySqlCommand removed all parameter values

2 Answers2