asp.net怎么获取当前记录的上一条ID和下一条ID

asp.net如何获取当前记录的上一条ID和下一条ID
asp.net如何获取当前记录的上一条ID和下一条ID，小弟急求方法

[解决办法]

sql = "select top 1 from table where id < 当前id order by id desc "

sql = "select top 1 from table where id > 当前id order by id asc "