数据表sql..how如何处理分页 [英] data table sql..how to handle pagination

问题描述

我正在从事类似Twitter的项目.该用户可以在其中发布文章或所有内容.这些帖子以幻灯片显示.现在我有三个按钮. 1>下一个2>上一个3>停止.我正在幻灯片放映中显示前10名帖子.问题是我想在下10个帖子中使用另一个按钮.如何显示它们?以及如何处理以前的事件?请帮助我..

Hi ,
I am working on a project like twitter. In that user can post an article or everything. That posts are shown in slide show. Right now I have three buttons in that. 1>next 2>previous 3> stop. I am showing top 10 posts in a slide show. The question is that I want another button for next 10 posts. How to show them? and how to handle previous event? please help me..

推荐答案

int currentIndex = 0;
int pageSize = 5;

string orderSQL = "SELECT * FROM Orders ORDER BY OrderID";
// Assumes that connection is a valid SqlConnection object.
SqlDataAdapter adapter = new SqlDataAdapter(orderSQL, connection);

DataSet dataSet = new DataSet();
adapter.Fill(dataSet, currentIndex, pageSize, "Orders");

http://msdn.microsoft.com/en-us/library/tx1c9c2f.aspx [ ^ ]

http://msdn.microsoft.com/en-us/library/tx1c9c2f.aspx[^]

这篇关于数据表sql..how如何处理分页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！