求高手帮忙解释一下这个页面代码每一句具体的作用,急~~~
八月 3, 2007
发表在: java
imports system.data
imports system.data.oledb
private sub page_load(byval sender as system.object, byval e as system.eventargs) handles mybase.load
在此处放置初始化页的用户代码
dim str1 as string = "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("bookmanage.mdb")
dim str2 as string = "select book_id as 图书编号, bookname as 图书名称,bookpub as 出版社,bookprice as 价格,author as 作者 from book"
dim ad as oledbdataadapter
ad = new oledbdataadapter(str2, str1)
ad.fill(ds, "book")
dim dv as dataview = ds.tables("book").defaultview
datagrid1.datasource = dv
datagrid1.databind()
end sub
private sub datagrid1_sortcommand(byval source as object, byval e as system.web.ui.webcontrols.datagridsortcommandeventargs) handles datagrid1.sortcommand
dim dv1 as dataview = ds.tables("book").defaultview
dv1.sort = e.sortexpression
datagrid1.datasource = dv1
datagrid1.databind()
end sub
private sub datagrid1_pageindexchanged(byval source as object, byval e as system.web.ui.webcontrols.datagridpagechangedeventargs) handles datagrid1.pageindexchanged
dim dv1 as dataview = ds.tables("book").defaultview
datagrid1.datasource = dv1
datagrid1.currentpageindex = e.newpageindex
datagrid1.databind()
end sub
end class
电脑软件技术推荐:
asp.net+vb.net
先导入名称空间,在页面加载的时候,查询book表数据并绑定到datagrid1控件.
datagrid1_sortcommand是对数据进行排序,datagrid1_pageindexchanged是取得当前页的记录.
你贴的代码不全,贴出来就大概这意思.
No comments in this entry