上一篇:select top 1 * from table where 主键<当前主键 order by 主键 desc 下一篇:select top 1* from table where 主键>当前主键
SET @Sql = 'select top 1 * from Tb_Article where 1=1 ' if(@Flag='01') begin set @Sql=@Sql+' and XTBH <'+@ID+'' set @Sql=@Sql+'order by LastUpdateTime DESC' end else if(@Flag='02') begin set @Sql=@Sql+' and XTBH>'+@ID+'' set @Sql=@Sql+'order by LastUpdateTime' end EXECUTE (@Sql) select * from Tb_article where id=(select min(id) from Tb_article where id>当前id) select * from Tb_article where id=(select max(id) from Tb_article where id <当前id)
...
简单东西不要复杂化~
下一篇:select top 1* from table where 主键>当前主键
if(@Flag='01')
begin
set @Sql=@Sql+' and XTBH <'+@ID+''
set @Sql=@Sql+'order by LastUpdateTime DESC'
end
else
if(@Flag='02')
begin
set @Sql=@Sql+' and XTBH>'+@ID+''
set @Sql=@Sql+'order by LastUpdateTime'
end
EXECUTE (@Sql) select * from Tb_article where id=(select min(id) from Tb_article where id>当前id)
select * from Tb_article where id=(select max(id) from Tb_article where id <当前id)
http://topic.csdn.net/u/20090902/16/a87dd82d-1df7-4357-9967-3e54e18a2145.html
DataTable dt=ds.tables["xxx"];
DataRow dtr=dt.Row[i-1];
string title=dtr["数据库文章标题字段"].tostring();i为当前页在DataSet中的行数,从0开始