还是触发器的问题
asp.net2.0:
protected void Button1_Click(object sender, EventArgs e)
{
string connstring = ConfigurationManager.ConnectionStrings["qztvoaConnectionString"].ToString();
SqlConnection dbConnection = new SqlConnection(connstring);
dbConnection.Open();
string query = "insert into ttapeborrow(tapecode,borrowman,borrowdate,borrowreason,operateman,operatedate) values(@tapecode,@borrowman,@borrowdate,@borrowreason,@operateman,@operatedate)";
SqlCommand dbCommand = new SqlCommand(query, dbConnection);
dbCommand.Parameters.Add(new SqlParameter("@tapecode", tapecodeBox.Text.ToString()));
dbCommand.Parameters.Add(new SqlParameter("@borrowman", userDropDownList.SelectedItem.Text.ToString()));
dbCommand.Parameters.Add(new SqlParameter("@operateman", Session["username"].ToString()));
dbCommand.Parameters.Add(new SqlParameter("@borrowreason", reasonDropDownList.SelectedItem.Text.ToString()));
dbCommand.Parameters.Add("@operatedate", SqlDbType.DateTime).Value = DateTime.Now.Date;
dbCommand.Parameters.Add("@borrowdate", SqlDbType.DateTime).Value = DateTime.Now.Date;
try
{
dbCommand.ExecuteNonQuery();
Response.Write("<script>");
Response.Write("window.alert('添加成功')");
Response.Write("</script>");
}
catch
{
Response.Write("<script>");
Response.Write("window.alert('添加失败,请与数据库管理员联系')");
Response.Write("</script>");
}
dbConnection.Close();
}
触发器:
CREATE TRIGGER Trigger1
ON dbo.ttapeborrow
After insert
AS
begin
update ttape
set instack = '0'
from ttape a, ttapeborrow b
where a.tapecode = b.tapecode
end
现在的情况是:只要有这个触发器,上面那段代码就无法添加记录,而一旦把触发器去掉,添加记录就正常,触发器语法是没错了,然到是逻辑错了?