插入MySql表 [英] insert into MySql Table

问题描述

很抱歉，如果您已经看到这个问题一千次了，但是我在Google上搜索了一下，但仍然找不到解决方案.我用谷歌搜索并更改了我的代码，但是它仍然不能解决我的代码.

所以，我想将数据插入到Mysql表中，但是它一直给我错误，最后一个错误是只能存储MySqlParamaters对象"，

这是我的代码:

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

字符串com =将用户插入(姓名，姓氏，通行证，电子邮件，类型)
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();

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();

推荐答案

使用"@"代替?".因为参数名称应与参数名称相同.

Use ''@'' instead of ''?''. As the Parameters name should be the Same as that of arguments.

这篇关于插入MySql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！