Question

gridview排序代码该怎么写，前台后台的都要

点一下表头排序，比如说点一下时间就那时间排，再点一下就换个顺序排

Answer 1

排序？怎么个排序？是想把文章添加的时间从新往旧排列吗？
直接用SQL语句就可以

select [标题字段] from [文章表] order by [文章表标识列] desc

如果想只列出N行数据，可以用

select top N [标题字段] from [文章表] order by [文章表标识列] desc