明明有分号,提示缺少分号。
添加的参数可以不用看。他提示是在mycommand.ExecuteNonQuery();处缺少分号。
  string cmd3 = "Insert into KHGL_Customer(cCusCode,cCusName,cCusAbbName,iDCID,cCusAddressMX,cCusSJName) values(@cCusCode,@cCusName,@cCusAbbName,@iDCID,@cCusAddressMX,@cCusSJName) where iCustomerId=" + Temp;
        mycommand = new OleDbCommand(cmd3, myconnection);
        mycommand.Parameters.Add(new OleDbParameter("@cCusCode", OleDbType.Char, 20));
        mycommand.Parameters.Add(new OleDbParameter("@cCusName", OleDbType.VarChar, 50));
        mycommand.Parameters.Add(new OleDbParameter("@cCusAbbName", OleDbType.VarChar, 50));
        mycommand.Parameters.Add(new OleDbParameter("@iDCID", OleDbType.Char, 20));
        mycommand.Parameters.Add(new OleDbParameter("@cCusAddressMX", OleDbType.VarChar, 100));
        mycommand.Parameters.Add(new OleDbParameter("@cCusSJName", OleDbType.VarChar, 50));        mycommand.Parameters["@cCusCode"].Value = cCusCode_Box.Text;
        mycommand.Parameters["@cCusName"].Value = cCusName_Box.Text;
        mycommand.Parameters["@cCusAbbName"].Value = cCusAbbName_Box.Text;
        mycommand.Parameters["@iDCID"].Value = iDCID_Box.Text;
        mycommand.Parameters["@cCusAddressMX"].Value = cCusAddressMX_Box.Text;
        mycommand.Parameters["@cCusSJName"].Value = cCusSJName_Box.Text;
        myconnection.Open();
        mycommand.ExecuteNonQuery();
        //添加确认对话框
        Response.Write("<script>window.alert('保存成功!')</script>");        myconnection.Close();