c# - 尝试保存到数据库时，列数与第 1 行的值数不匹配

Question

我想在 mysql 数据库上保存数据，但我总是得到“列数与第 1 行的值数不匹配”

我试着重新编写这个 sql 命令，看过一些关于这个的视频，但找不到任何有用的东西

string Insert = 
    "INSERT INTO db.pcs(Nome,Marca,Utilizador,Ram,CPU,Disco,TipoSO,SO,Licenca,TipoPC,ProgramaseLicenca) VALUES('" 
            + nome + "," + marca + "," + user + "," + ram + "," 
            + cpu + "," + disco + "," + tiposo + "," + so + "," 
            + lice + "," + tipopc + "," + progs + "')";

using (MySqlConnection cn = new MySqlConnection(connst))
{
    cn.Open();
    MySqlCommand cmd = new MySqlCommand(Insert, cn);

    try
    {
        if (cmd.ExecuteNonQuery() == 1)
        {
            pb1.Visible = true;
            timer1.Start();
        }
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

它应该添加到数据库，但在尝试消息框上我得到“列数与第 1 行的值数不匹配”

Answer 1

我认为你应该为每个值制作“'”

string Insert = 
"INSERT INTO  db.pcs (Nome,Marca,Utilizador,Ram,CPU,Disco,TipoSO,SO,Licenca,TipoPC,ProgramaseLicenca) VALUES('" 
        + nome + "','" + marca + "','" + user + "','" + ram + "','" 
        + cpu + "','" + disco + "','" + tiposo + "','" + so + "','" 
        + lice + "','" + tipopc + "','" + progs + "')";