插入数据后执行更新动作

Question

当我插入一笔数据成功后；自动执行更新另外一个表格的动作；如下代码；更新不起作用
 string sql = "insert into draw(ID,Line,DateTime,DUser,Quantity,category,re,action)values(@ID,@Line,CONVERT(varchar(100),GETDATE()),@DUser,@Quantity,@category,@re,@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("@re", this.txtre.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);
                    }