在ASP.Net中创建动态表格-.NET教程,Asp.Net开发

＜element name=”title”＞
＜complextype content=”elementonly”＞
＜element name=”title_id” type=”string” minoccurs=”1″
maxoccurs=”1″＞＜/element＞
＜element name=”au_id” type=”string” minoccurs=”1″
maxoccurs=”1″＞＜/element＞
＜element name=”title” type=”string” minoccurs=”1″
maxoccurs=”1″＞＜/element＞
＜element name=”price” msdata:datatype=”system.currency”
type=”string”
minoccurs=”1″ maxoccurs=”1″＞＜/element＞
＜element name=”pubdate” type=”timeinstant” minoccurs=”1″
maxoccurs=”1″＞＜/element＞
＜/complextype＞
＜unique name=”titleconstraint” msdata:primarykey=”true”＞
＜selector＞.＜/selector＞
＜field＞title_id＜/field＞
＜/unique＞
＜key name=”authortitle”＞
＜selector＞../author＜/selector＞
＜field＞au_id＜/field＞
＜/key＞
＜keyref refer=”authortitle”＞
＜selector＞.＜/selector＞
＜field＞au_id＜/field＞
＜/keyref＞
＜/element＞
＜/schema＞
＜documentelement＞
＜author＞
＜au_id＞154-00-1300＜/au_id＞
＜au_name＞john doe＜/au_name＞
＜phone＞425 705 1234＜/phone＞
＜address＞one microsoft way＜/address＞
＜city＞redmond＜/city＞
＜state＞ca＜/state＞
＜zip＞98005＜/zip＞
＜/author＞

＜title＞
＜title_id＞bu1032＜/title_id＞
＜au_id＞213-46-8915＜/au_id＞
＜title＞the busy executives database guide＜/title＞
＜price＞19.99＜/price＞
＜pubdate＞1991-06-12t07:00:00＜/pubdate＞
＜/title＞
＜/documentelement＞
＜/root＞

public void session_onstart() {
// 将样例中所用的数据载入会话范围的 dataset.

filestream fs = null;
dataset ds = null;
try {
fs = new filestream(server.mappath(“data\\titlesdb.xml”),
filemode.open, fileaccess.read);
ds = new dataset();
ds.readxml(fs);
} finally {
if (fs != null) {
fs.close();
fs = null;
}
}
session[“appdata”] = ds;
}

imports system.dbnull
imports system.data
imports system.data.sqlclient
imports system.data.oledb
imports system.datetime
imports dataaccess

public class borrow
inherits system.web.ui.page
public db as new oledataaccess()
dim mydataset as new dataset()

dim selecttable as new datatable()
dim selectview as new dataview()
…
private sub page_load(byval sender as system.object, byval e as system.eventargs) handles mybase.load
dim info as string, time
if not page.ispostback then
if now.hour ＞= 6 and now.hour ＜ 12 then
info = “早上好！！”
elseif now.hour ＞ 12 and now.hour ＜ 18 then
info = “下午好！！”
else
info = “晚上好！！”
end if
dim counter as int16
counter = application(“counter”)
lblinfo.text = application(“username”) + “,” + info + chr(13) + “欢迎你前来借阅 。.” + chr(10) + “你是第” + counter.tostring + “位来访者！”

end if
if isnothing(session(“mtable”)) then
selecttable = createtable()
session(“mtable”) = selecttable
settext()
else
selecttable = session(“mtable”)
end if
end sub
private function createtable() as datatable
dim dt as new datatable()
dim dr as datarow
dt.columns.add(new datacolumn(“id”, gettype(string)))
dt.columns.add(new datacolumn(“name”, gettype(string)))
dt.columns(0).columnname = “系号”
dt.columns(1).columnname = “名称”
return dt
end function
end class

imports system.dbnull
imports system.data
imports system.data.sqlclient
imports system.data.oledb
imports system.datetime
imports dataaccess

public class borrow
inherits system.web.ui.page
public db as new oledataaccess()
dim mydataset as new dataset()
dim selecttable as new datatable()
dim selectview as new dataview()
…
private sub settext()
select case application(“index”)
case 0
lblfind1.text = “检索号 “
lblfind2.text = “图书分类”
lblfind3.text = “图书名称”
lblfind4.text = “分类号”
lblfind5.text = “作者”
lblfind6.text = “有效性”
case 1
lblfind1.text = “编号 “
lblfind2.text = “卷册名称”
lblfind3.text = “设计专业代码”
lblfind4.text = “专业代码”
lblfind5.text = “馆藏号”
lblfind6.text = “负责人 “
case 2
end select
end sub

private sub data2bind()
datagrid2.datasource = selecttable.defaultview
datagrid2.databind()
end sub

private sub linkbutton1_click(byval sender as system.object, byval e as system.eventargs) handles linkbutton1.click
application(“index”) = 0
settext()
end sub

private sub linkbutton2_click(byval sender as system.object, byval e as system.eventargs) handles linkbutton2.click
application(“index”) = 1
settext()
end sub

private sub linkfind_click(byval sender as system.object, byval e as system.eventargs) handles linkfind.click
dim strsql as string
dim txt(6) as string
dim i as int16 = 0
txt(0) = trim(txtfind1.text)
txt(1) = trim(txtfind2.text)
txt(2) = trim(txtfind3.text)
txt(3) = trim(txtfind4.text)
txt(4) = trim(txtfind5.text)
txt(5) = trim(txtfind6.text)
if txt(0) = “” and txt(1) = “” and txt(2) = “” and txt(3) = “” and txt(4) = “” and txt(5) = “” then
exit sub
end if
for i = 0 to 5
if txt(i) = “” then txt(i) = “!!!!”
next
try
if application(“index”) = 0 then
strsql = “select jsh as 检索号, tsmc as 图书名称, tsfl as 图书分类, cs as 册数, flh as 分类号, dj as 单价, zz as 作者, bz as 备注, zbbm as 主编部门, fbrq as 发布日期, ssrq as 实施日期, yxx as 有效性, zt as 状态 from g2272.kpk ” & _
” where jsh like %” & txt(0) & _
“% or tsfl like %” & txt(1) & _
“% or tsmc like %” & txt(2) & _
“% or flh like %” & txt(3) & _
“% or zz like %” & txt(4) & _
“% or yxx like %” & txt(5) & “%”
else
strsql = “select system_id as 编号, jcmc as 卷册名称, gcdm as 工程代码, zydm as 专业代码, gch as 馆藏号, rkrq as 入库日期, tzzs as 图纸张数, gdzb as 归档正本, gdfb as 归档副本, jc as 说明书, zsr as 清册, zbr as 负责人 from docsadm.twml ” & _
” where system_id like %” & txt(0) & _
“% or jcmc like %” & txt(1) & _
“% or gcdm like %” & txt(2) & _
“% or zydm like %” & txt(3) & _
“% or gch like %” & txt(4) & _
“% or zbr like %” & txt(5) & “%”
end if
mydataset = application(“db”).executesql(strsql)
datagrid1.datasource = mydataset.tables(0).defaultview
datagrid1.databind()
catch ex as exception
msgbox(“错误信息”, ex.message & vbcrlf & “stack step”)
end try
end sub
end class