asp.net 2.0 的GridView的问题??急急急!!

来源:百度知道 编辑:UC知道 时间:2024/05/15 16:44:44
如何动态的设置数据源,并且可以分页和排序啊

分页和排序可以用datagrid控件实现.dataview那是建立一个视图.有时用它可以很简单的代替sql语句.使用更为方便.下面是一个dataview和datagrid分页排序的实例.动态设置的数据源.是用的access数据库.名字是price.mdb.可以自己建一个数据库.内容随便.
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.oledb" %>
<script language=vb runat=server>
sub bindlist()
dim conn as string = "provider=microsoft.jet.oledb.4.0;data source = " & server.mappath("Price.mdb")
dim sql as string = "Select * From 零部件报价表"
dim da as new oledbdataadapter(sql,conn)
dim ds as new dataset()
da.fill(ds,"chwu")
dim dv as new dataview(ds.tables("chwu"))
dv.sort = sortfield.value
mydatagrid.datasource = dv
mydatagrid.databind()
end sub

sub pages(sender as object ,e as datagridpagechangedeventargs)
mydatagrid.currentpageindex = e.newpageindex
bindlist()
end sub

sub aa(sender as object ,e as datagridsortcomm