VB中为什么取不到recordset.fields(i).value:
dll中游段代码,正常连接到数据库,测试有一条数据,fields(i).name也能得到,fields(i).value却得不到,上帝帮助我:
源代码如下:
cnstr = "Provider = SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=appdata;Data Source=qysoft;"
cn.ConnectionString = cnstr
cn.Errors.Clear
cn.Open
Response.Write "<BR>" + cnstr + "<BR>"
If cn.Errors.Count <= 0 Then
Set cmd.ActiveConnection = cn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "qywsfc"
cmd.Parameters(1) = "2004"
cmd.Parameters(2) = " 5"
cmd.Parameters(3) = "160104"
Set rs = cmd.Execute()
If Not (rs.BOF And rs.EOF) Then
Response.Write "<table border = 1><tr><td>hello"
rs.MoveFirst
Response.Write "<tr>"
For i = 0 To rs.Fields.Count - 1
ls_t = rs.Fields(i).Name
If ls_t = "" Then ls_t = "NULL"
Response.Write "<td>" + Trim(ls_t) + "</td>"
Next
Response.Write "</tr>"
Do While Not rs.EOF
Response.Write "<tr>"
For i = 0 To rs.Fields.Count - 1
Response.Write "<td>" + Trim(rs.Fields(i).Value) + "</td>"
Next
Response.Write "</tr>"
rs.MoveNext
Loop
Else
Response.Write "没有数据"
End If
Else
Response.Write "数据库连接不上"
End If
Response.Write "</table>"
disconn
OnEndPage
End Sub
dll中游段代码,正常连接到数据库,测试有一条数据,fields(i).name也能得到,fields(i).value却得不到,上帝帮助我:
源代码如下:
cnstr = "Provider = SQLOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Initial Catalog=appdata;Data Source=qysoft;"
cn.ConnectionString = cnstr
cn.Errors.Clear
cn.Open
Response.Write "<BR>" + cnstr + "<BR>"
If cn.Errors.Count <= 0 Then
Set cmd.ActiveConnection = cn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "qywsfc"
cmd.Parameters(1) = "2004"
cmd.Parameters(2) = " 5"
cmd.Parameters(3) = "160104"
Set rs = cmd.Execute()
If Not (rs.BOF And rs.EOF) Then
Response.Write "<table border = 1><tr><td>hello"
rs.MoveFirst
Response.Write "<tr>"
For i = 0 To rs.Fields.Count - 1
ls_t = rs.Fields(i).Name
If ls_t = "" Then ls_t = "NULL"
Response.Write "<td>" + Trim(ls_t) + "</td>"
Next
Response.Write "</tr>"
Do While Not rs.EOF
Response.Write "<tr>"
For i = 0 To rs.Fields.Count - 1
Response.Write "<td>" + Trim(rs.Fields(i).Value) + "</td>"
Next
Response.Write "</tr>"
rs.MoveNext
Loop
Else
Response.Write "没有数据"
End If
Else
Response.Write "数据库连接不上"
End If
Response.Write "</table>"
disconn
OnEndPage
End Sub
解决方案 »
- 高手帮忙解决下VB显示日期的问题
- 急!!菜鸟求助访问sql数据库,设置时间段查询问题
- 在VB里利用API查看内存信息怎么做?
- text控件怎么设置垂直居中?
- 请问谁有用友华表做的例子?请给一个,谢谢!
- 我想获取系统是否有文件拷贝/删除的消息,谁有好的例子?
- 求助:如何用代码自动建立数据源?(内详)
- 我用VB进行SQL日期比较的时候,出现如下错误,请大家进来帮帮忙,在线等侍,谢谢!!
- 如何在VB环境中查看、修改资源文件(*.RES)或将其他文件如*.TXT做为资源文件?
- 一个窗体问题,Why?why?why?
- 自由软件-XPmenu菜单控件新版本(含帮助)
- 怎么实现一个程序在后台运行,但是在按下ctrl+alt+del后看不到这个程序的运行??
不支持rs.movefirst
rs.CursorType =adOpenKeyset
rs.CursorType =adOpenDynamic
在cn.Open 后面的参数中设置也一样