Insert Into MySql Table

Im sorry if you have seen this question a thousand times, But ive googled this and still couldnt find a solution. I googled and changed my code a bit but it still doesnt fix my code.

So,i want insert data into my Mysql table But it kept giving me errors, the lastest of which is "Only MySqlParamaters objects may be stored",

Here is my Code:

MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySql"].ConnectionString);

string com = "INSERT INTO Users(Name, Surname, Pass, Email, Type)
VALUES(@Name,@Surname,@Password,@Emailaddr, @type)";

MySqlCommand Com = new MySqlCommand(com, con);

Com.CommandType = CommandType.Text;
Com.Parameters.Add(new MySqlParameter("?Name", MySqlDbType.Text).Value = txtfname.Text);
Com.Parameters.Add(new MySqlParameter("?Surname", MySqlDbType.Text).Value = txtlname.Text);
Com.Parameters.Add(new MySqlParameter("?Password", MySqlDbType.Text).Value = txtpass11.Text);
Com.Parameters.Add(new MySqlParameter("?Emailaddr", MySqlDbType.Text).Value = txtemail.Text);
Com.Parameters.Add(new MySqlParameter("?type", MySqlDbType.Text).Value = "Patient");

con.Open();
Com.ExecuteNonQuery();

con.Close();

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
If you're using the ? prefix when adding your parameters, then I'd have thought you should do likewise in the INSERT statement:

string com = "INSERT INTO Users(Name, Surname, Pass, Email, Type)
VALUES(?Name,?Surname,?Password,?Emailaddr, ?type)";