问题描述
我正在使用visual basic 2017和SQL Server express 2014中的商店项目
同样的错误包括将数据插入到日志信息表中/>
数据表
Id(pk,int not null)
user_name(nvarchar,50)
密码(nvarchar,50)
login_time(datetime 7 null)
login_date (datetime 7 null)
我的代码是
i我不会在此查询中插入pk值,
需要帮助
我尝试过:
hi i am working on my shop project in visual basic 2017 and SQL server express 2014
the same error consist in inserting a data to log information tabel
data tabel as
Id (pk,int not null)
user_name (nvarchar,50)
password (nvarchar,50)
login_time(datetime 7 null)
login_date(datetime 7 null)
and my code is
i am not going to insert a pk value in this query ,
please need help
What I have tried:
sql.AddParam("@u1", m_name)
sql.AddParam("@u2", TxtPAssword.Text)
sql.AddParam("@u3", m_time)
sql.AddParam("@u4", dt1)
sql.ExecQuery("Insert into user_log(user_name,password,login_time,login_date) " &
"Values(@u1,@u2,@u3,@u4)")
If Noerrors(True) = False Then MsgBox(sql.Exception)
推荐答案
这篇关于Execquery错误:主键约束'pk_user_log_3214ec276f8e662e'的声音。在对象dbo.user.log中插入duplicat键。重复键值为(0),结果已经终止的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!