插入数据后执行更新动作

[prosezhang]

当我插入一笔数据成功后；自动执行更新另外一个表格的动作；如下代码；更新不起作用
string sql = "insert into draw(ID,Line,DateTime,DUser,Quantity,category,remark,action)values(@ID,@Line,CONVERT(varchar(100),GETDATE()),@DUser,@Quantity,@category,@remark,@action)";
try
{
SqlCommand cmd = new SqlCommand(sql, DBHelper.con);
DBHelper.con.Open();
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
cmd.Parameters.AddWithValue("@line", this.txtLine.Text.Trim());
cmd.Parameters.AddWithValue("@DUser", this.txtUser.Text.Trim());
cmd.Parameters.AddWithValue("@Quantity", this.txtqty.Text.Trim());
cmd.Parameters.AddWithValue("@category", this.cbocategory.Text.Trim());
cmd.Parameters.AddWithValue("@remark", this.txtremark.Text);
cmd.Parameters.AddWithValue("@action", this.rdodraw.Text.Trim());
cmd.CommandText = sql;
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
string sql1 = "Update date set status='在线' where id = @ID";
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
DBHelper.con.Open();
SqlCommand cmd1 = new SqlCommand(sql1, DBHelper.con);
int result1 = cmd.ExecuteNonQuery();
if (result1 == 1)
{
MessageBox.Show("添加成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("添加失败", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

[足球中国]

触发器
问题说的不明