c#关于数据库更新的问题

Question

数据库主键类型为char 添加数据后更新报错，说是语法错误怎么回事呀。

Answer 1

sql是不是写错了？具体什么错误？

Answer 2

没用  sql 语句  是系统自动生成的语句
 try
            {
                m_dtContacts.Clear();
                DataRow drnewrow = m_dtContacts.NewRow();                drnewrow["User_LoginId"] = txb_usernumber.Text;
                drnewrow["User_Pwd"] = txb_usernumber.Text;
                drnewrow["name"] = txb_name.Text;
                drnewrow["sex"] = changeSex(cbb_sex.Text);
                drnewrow["Tell"] = txb_phone.Text;
                drnewrow["Power"] = changePower(cbb_grade.Text);
                drnewrow["State"] = "True";
                
                m_dtContacts.Rows.Add(drnewrow);
                m_daDataAdapter.Update(m_dtContacts);
                m_daDataAdapter.Fill(m_dtContacts);
                ((L_Option)this.Owner).Addsuccess = true;
                this.Close();
            }
这个没错
try
            {
                //m_dtContacts.Clear();
                DataRow drnewrow = m_dtContacts.NewRow();
                drnewrow["p_id"] = "P389dd";                drnewrow["product_id"] = txb_p_id;
                drnewrow["name"] = txb_name.Text;
                drnewrow["buyunit_id"] = changeunit(cbb_buyunit.Text);
                drnewrow["buyprice"] = txb_buypice.Text;
                drnewrow["saleunit_id"] = changeunit(cbb_saleunit.Text);
                drnewrow["saleprice"] = txb_salepice.Text;
                drnewrow["supplier_id"] = getSupplierID(cbb_supplier.Text);
                drnewrow["status"] = changestatus(cbb_status.Text);
                drnewrow["memo"] = txb_beizhu.Text;
                drnewrow["pic"] = null;
                drnewrow["product_type"] = null;
                //drnewrow["pic"] = "";
                m_dtContacts.Rows.Add(drnewrow);
                m_daDataAdapter.Update(m_dtContacts);
                m_daDataAdapter.Fill(m_dtContacts);
                //((product_ifo)this.Owner).Addsuccess = true;
                this.Close();
            }这个就做了

Answer 3

Update 表明 set 列名=值 where ...