我用ASP.NET想得到从第10条记录开始的20条记录,请问各位大大怎么写这个代码
解决方案 »
- ASP.net页面之间控件共享问题?GridView 控件
- 数据导入时,弹出对话框
- vs2005不能调试.net程序??
- 如何引用动态生成的CheckBoxList?(思归等达人求救,抓狂几天了)
- 关于.net2.0repeater控件运用???
- ◆◇◆ 求一个正则表达式! ◆◇◆
- 提示:vs.net已经检测到指定的Web服务器运行的不是ASP.net 1.1版,你将无法打开ASP.net Web应用程序和服务.这是怎么搞的
- processModel的maxWorkerThreads设置没用
- button 怎样调用javascript
- (20分)vs2005(C#)调试成功后,不再有错误对话框,可浏览器没有显示网页呀?
- 想利用ASP按钮的OnChange事件完成一件事情。。。
- 用户登入问题?
不过得先排序!
select top 20 !
oledbadaper.fill()函数里面就有 从第几个开始,取多少个数据的参数
外面在selet top 10 * ...... descORACLE的话 rownum
Dim ds As DataSet
...................
da.Fill(ds, i, Num, "Tabel1")
思路是把整张表的记录全读到一个SqlDataAdapter中,然后用DataSet从中取出你想要的,其中:
i表示从第几条起(比如从第10条开始取,则i=9),Num表示你一共想取的条数(比如你想取10条,则Num=10)。
CREATE PROCEDURE Admin_Article_Manage_BindList
(@PageSize int,
@PageNo int)
as
declare @Countrows integer
select @Countrows=count(ID) from Article where deleted=0
if (@Countrows>0)--如果有数据才进行分页取数据set nocount on
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@PageNo-1)*@PageSize
set @PageUpperBound=@PageLowerBound+@PageSize
set rowcount @PageUpperBound
insert into @indextable(nid) select ID from Article where deleted=0 order by UpdateTime desc
select
CASE O.pass
WHEN '1' THEN '已通过'
ELSE '<font color="#FF0000"/>未通过'
END AS pass,
CASE O.IncludePic
WHEN '1' THEN '<font color="#0066FF">[有图]</font>'
ELSE '<font color="#CCCCCC">[无图]</font>'
END AS IncludePic,O.ID,O.Title,O.Editor,O.Hits,(select Class.ClassName from Class where Class.ID=O.ClassID) as class,O.ClassID from Article O,@indextable t where O.ID=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
set nocount offreturn @Countrows
GO
CREATE PROCEDURE test @pagesize int,@pageno int as
SELECT TOP 10 * FROM Article WHERE (ID > (SELECT MAX(id)
FROM (SELECT TOP 20 id FROM Article ORDER BY id) AS T)) ORDER BY ID
--10是页大小
declare @TopN integer
set @TopN=@pagesize * @pageno
SELECT TOP 10 * FROM Article WHERE (ID >
(SELECT MAX(id) FROM (SELECT TOP @TopN id FROM Article ORDER BY id) AS T))
ORDER BY ID
select top 10 * from
(select top 20 * from table order by field desc(根据你的要求排序) )
order by order by field asc(根据你的要求反排序)
Dim conn As New OleDbConnection(dsn)
Dim strsql As String = "select top 20 客户ID,公司名称 from 客户 where 客户ID not in(select top 10 客户ID from 客户 order by 客户id) order by 客户id" Dim da As New OleDbDataAdapter(strsql, conn)
Dim ds As New DataSet
Dim ds_count As Integer
Try
ds_count = da.Fill(ds, "客户")
Catch ex As Exception
RegisterClientScriptBlock("err", "<script language=""javascript"">alert('" & ex.Message.ToString.Replace("'", "") & "')" & "</script>")
End Try If ds_count > 0 Then
DataGrid1.DataSource = ds.Tables("客户").DefaultView
DataGrid1.DataBind()
End If
ds.Dispose()
da.Dispose()
conn.Dispose()