摘要:
建立数据库表...............TableAdapter添加sql查询语句:select * from(SELECT Id, Title, Msg, Createdtime,Row_Number() over(order by Id) rownum FROM dbo.T_News)twhere t.rownum>@startRowIndex and t.rownum<=@startRowIndex+@maximumRowsRow_Number() over(order by Id) //ROW_NUMBER函数 SQL Server2005为我们引入了一个ROW_NUMB 阅读全文