无法绑定由多个部分组成的标识符 "Inserted.Id"

CREATE trigger Navigation_update
on Navigation
for update
AS
BEGIN
update Navigation set [path] =
case
when NavFId=0 then '/'
else (select [path] from Navigation where id = Inserted.NavFId) + NavFId + '/'
end
where Id=Inserted.Id;

END
GO
改成new.Id 也是一样无法绑定由多个部分组成的标识符 "new.Id "
群里的朋友帮解决了。
ALTER TRIGGER [dbo].[Navigation_update]
ON [dbo].[Navigation]
AFTER UPDATE
AS
begin
update Navigation set [path]=
(select path from Navigation where id =(select NavFId from Inserted))+ convert(varchar,NavFId) +'/'
where Navigation.id=(select id from Inserted)
end

如果是数字：
string sql1 = "select proname,promodel,prospec,producer,unitprice,danwei,prodesc from jichuang where [promodel]="+txtmodel.Text;
如果是字符串：
string sql1 = "select proname,promodel,prospec,producer,unitprice,danwei,prodesc from jichuang where [promodel]='"+txtmodel.Text+"'";

另外，这样拼接查询字符串，得考虑到sql 注入的风险