各位兄弟帮帮忙。看看我的这个,为什么总是提醒说“至少一个参数没有被指定值”谢谢了!!!up 给分

wrrybo5221 wrrybo5221 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
<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 oledbdataAdapter

dim 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 sub



sub 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 sub

sub dgdata_pageindexChanged(obj as object,e as datagridpagechangedeventargs)
dgdata.currentpageindex=e.newPageindex
dgdata.databind()
filldatagrid()
end sub
...全文
评论 17
收藏 已收藏
分享
返回顶部
wrrybo5221
.NET社区 62,272 成员 668,968 内容