冒泡排序，sql分页语句

 1 public int[] PopSmall(int[] IntArray)
 2             {
 3                 int temp = 0;
 4                 for (int i = 0; i < IntArray.Length - 1; i++)
 5                 {
 6                     for (int j = i + 1; j < IntArray.Length; j++)
 7                     {
 8                         if (IntArray[i] > IntArray[j])
 9                         {
10                             temp = IntArray[i];
11                             IntArray[i] = IntArray[j];
12                             IntArray[j] = temp;
13                         }
14                     }
15                 }
16                 return IntArray;
17             }

 1 public DataTable GetListBy(int pageIndex,int pageSize)
 2             {
 3                 int count = (pageIndex - 1) * pageSize;
 4                 //写法一 需要拿出数据库的第5页，就是40-50条记录。首先拿出数据库中的前40条记录的id值，然后再拿出剩余部分的前10条元素
 5                 string sql = "SELECT TOP " + pageSize + " * FROM A WHERE ID NOT IN (SELECT TOP " + count + " ID FROM A ORDER BY ID) ORDER BY ID";
 6                 //写法二 先把表中的数据进行排序 然后取其需要的条数
 7                 sql = "SELECT TOP " + pageSize + "  * FROM (SELECT ROW_NUMBER() OVER(ORDER BY ID ASC) AS num,* FROM A) a WHERE a.num>" + count;
 8                 
 9                 // Todo...
10                 return null;
11             }