对数组中的数字进行排序
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 }
sql语句分页
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 }