<script runat="server">
dim conn as new oledbconnection("provider=microsoft.jet.oledb.4.0; data source="+server.MapPath("data/fwk.mdb"))dim objcmd as new oledbdataAdapterdim ds as new dataset("my")
sub page_load(obj as object, e as eventargs) dim sql as string
sql=new string("select top 10 fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from fwk order by fwk_bianhao DESC")if request("fwk_bianhao")<>"" then
sql=new string("select fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from kehu where fwk_bianhao=" & request("fwk_bianhao") & " order by fwk_bianhao DESC")
view1.text=request("sort") & ".."
end if objcmd=new oledbdataAdapter(sql,conn)
filldatagrid()
fillsort()
end sub
'query method
sub query(Sender As Object, e As EventArgs)
if request("select")<>"" and request("keyword")<>"" then
[select].value=request("select")
keyword.value=request("keyword")
elseif keyword.value="" then
exit sub
end if
dim sql as string="select fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from fwk where " & [select].value & " like '%" & keyword.value &"%'order by fwk_bianhao DESC"objcmd=new oledbdataAdapter(sql,conn)
filldatagrid()
view1.text="搜索结果:"
end sub
sub getdata() ----问题好像就出在这!!帮帮看看 objcmd.fill(ds, "art")
'define primary key
' dim keys() as datacolumn={ds.tables("gb").columns("userid")}
' ds.tables("gb").primarykey=keys'
end subsub filldatagrid ----问题好像就出在这!!帮帮看看
ds.clear()'
getdata() dgdata.datasource=ds
dgdata.datamember="kehu"
dgdata.databind()
end sub
sub fillsort
dim objcmd as new oledbcommand("select * from fwlx",conn)
dim objreader as oledbdatareader
try
objcmd.connection.open()
objreader=objcmd.executereader()
catch ex as exception
view1.text=ex.message
end try
sort.datasource=objreader
sort.databind()
objreader.close
objcmd.connection.close()
end subsub dgdata_pageindexChanged(obj as object,e as datagridpagechangedeventargs)
dgdata.currentpageindex=e.newPageindex
dgdata.databind()
filldatagrid()
end sub
dim conn as new oledbconnection("provider=microsoft.jet.oledb.4.0; data source="+server.MapPath("data/fwk.mdb"))dim objcmd as new oledbdataAdapterdim ds as new dataset("my")
sub page_load(obj as object, e as eventargs) dim sql as string
sql=new string("select top 10 fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from fwk order by fwk_bianhao DESC")if request("fwk_bianhao")<>"" then
sql=new string("select fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from kehu where fwk_bianhao=" & request("fwk_bianhao") & " order by fwk_bianhao DESC")
view1.text=request("sort") & ".."
end if objcmd=new oledbdataAdapter(sql,conn)
filldatagrid()
fillsort()
end sub
'query method
sub query(Sender As Object, e As EventArgs)
if request("select")<>"" and request("keyword")<>"" then
[select].value=request("select")
keyword.value=request("keyword")
elseif keyword.value="" then
exit sub
end if
dim sql as string="select fwk_bianhao,fwk_tel,fwk_dizhi,fwk_danwei from fwk where " & [select].value & " like '%" & keyword.value &"%'order by fwk_bianhao DESC"objcmd=new oledbdataAdapter(sql,conn)
filldatagrid()
view1.text="搜索结果:"
end sub
sub getdata() ----问题好像就出在这!!帮帮看看 objcmd.fill(ds, "art")
'define primary key
' dim keys() as datacolumn={ds.tables("gb").columns("userid")}
' ds.tables("gb").primarykey=keys'
end subsub filldatagrid ----问题好像就出在这!!帮帮看看
ds.clear()'
getdata() dgdata.datasource=ds
dgdata.datamember="kehu"
dgdata.databind()
end sub
sub fillsort
dim objcmd as new oledbcommand("select * from fwlx",conn)
dim objreader as oledbdatareader
try
objcmd.connection.open()
objreader=objcmd.executereader()
catch ex as exception
view1.text=ex.message
end try
sort.datasource=objreader
sort.databind()
objreader.close
objcmd.connection.close()
end subsub dgdata_pageindexChanged(obj as object,e as datagridpagechangedeventargs)
dgdata.currentpageindex=e.newPageindex
dgdata.databind()
filldatagrid()
end sub
解决方案 »
- 显示隐藏头部
- 在Gridview的模板里添加了Checkbox控件,并另外添加一个Checkbox控件,实现全选功能与全部删除功能。
- GridView控件里的删除如何弹出一个提示(是否)的对话框
- asp.net 结合jquery easyui如何实现某些操作
- 谁搞过这样SQL数据库复制(比如数据库事务复制,快照复制等),我想在两台服务器之间实现数据同步,但是无法实现,报错说总是连接不上Subcr 另一台服务器,谁搞过请赐教,或者贴个图(步骤方案)出来,谢谢啊
- 提取数据问题
- 客户端对象和服务向服务器端转换问题??
- 请问为什么我的页面继承一个abstract的Page后页面不能进入编辑状态。
- .net安装程序制作,生成的时候总是有“不可恢复的错误!”是怎么回事,请高人指点?
- 安装程序的制作问题
- 在Session_End的时候如何去获得Cache对象?
- 急!比较弱的问题:怎么将字符串变量转换成字节数组byte[]??
是说你的Select语句中至少有一个列名和表中的列名不同,VB的看不懂.你再找一下吧.
麻烦各位帮帮忙!谢谢了!!!!!!
你最好检查一下