表log

logid   title    content
15       "title001"  "content 110"
5       "title001"  "content 110"
445       "title001"  "content 110"
25       "title001"  "content 110"


select * from log where (logid =5)

怎么选择logid=5的上一篇，和下一篇

试试这样：


public string GetNextPhotoUrl(string id){
  string sql = "select top 1 id,PhotoUrl from 表名 where id>" + id + "order by id asc"
  return GetPhotoUrl(sql);
}

public string GetPreviousPhotoUrl(string id){
  string sql = "select top 1 id,PhotoUrl from 表名 where id<" + id + " order by id desc";
  return GetPhotoUrl(sql);
}