ADO.NET 查询一条记录时，如何并查出上一条记录的ID，和下一条记录的ID

CREATE PROCEDURE pTable2_getPN @titleid varchar(30)  AS declare @kind varchar(30),@P varchar(100),@Pid varchar(30),@Ptitle varchar(50),@N varchar(100),@Nid varchar(30),@Ntitle varchar(50) set @kind=(select top 1 kind from table2 where id=@titleid) select top 1 @Ptitle=title,@Pid=id from table2 where id<convert(int,@titleid) and kind=@kind order by id desc select top 1 @Ntitle=title,@Nid=id from table2 where id>convert(int,@titleid) and kind=@kind order by id if @Ptitle is null set @Ptitle='' if @Pid is null set @Pid='' if @Ntitle is null set @Ntitle='' if @Nid is null set @Nid='' set @P='<Li>上一篇 :<A href="viewTitle.aspx?titleid='+@Pid+'">'+@Ptitle+'</A>' set @N='<Li>下一篇 :<A href="viewTitle.aspx?titleid='+@Nid+'">'+@Ntitle+'</A>' select @P+'<br/>'+@N as innerhtml GO