Question

asp.net中运行页面时提示错误为：用户代码未处理Oledbexception 还有是：至少一个参数没有被指定急急急！！

Sub BindGrid(byval tj as string,byval nr as string)
Dim StrCnn As String
Dim Cnn As OleDbConnection
Dim Cmd As OleDbCommand
dim dtcmd as oledbdataadapter
dim dt as new datatable
dim str2 as string
dim Str1 as string
if trim(tj)<>"" and trim(nr)<>"" then
str1=" where " & tj & " like '%" & trim(nr) & "%'"
end if
StrCnn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Music.mdb")
Cnn=New OleDbConnection(StrCnn)
Cnn.Open()
str1="select id,songname,songer,addr,zj from music " & str1 & " order by id desc"
dtcmd=new oledbdataadapter(str1,cnn)
dtcmd.fill(dt) 至少有一个参数没被指定怎么回事啊？
datagrid1.datasource=dt
datagrid1.databind()
cnn.close()
End Sub

Answer 1

确认你的music表中是否有以下字段：id,songname,songer,addr,zj,tj

追问

确认有啊 不知道为什么 哪里出现问题了 而且歌曲搜索 按歌手姓名就查询不了

追答

估计是传入的参数值有问题，建议response.write(str1)出来看看

追问

能具体告诉我在哪里添加代码吗 谢谢了

追答

str1="select id,songname,songer,addr,zj from music " & str1 & " order by id desc"
后面添加：
response.write(str1)
response.end
执行后看是不是你要的SQL

追问

select id,songname,songer,addr,zj from music order by id desc 运行了 结果只有这句话了怎么回事啊?

追答

晕，难道缺"dim dt as new datatable"?

Answer 2

一个语句一般先在数据库里面查看能得到数据不，能得到再套进来