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 "
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 "