Private Sub Form_Load()
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = server.CreateObject("ADODB.Connection") '----此处变黄。“要求对象”
Set rs = server.CreateObject("adodb.recordset")
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
Conn.Open "Provider=SQLOLEDB.1;Password=; Persist Security Info=True;User ID=sa;Initial Catalog=weilecture;Data Source=(local)"
End SubPrivate Sub Command1_Click()
For i = 1 To 5
sql1 = "select top 1 timubiaoti,timudaan,chapter,tixing from bjtutimubase where tixing='简答题' and chapter='" & Str(f(i)) & "' and kecheng='" & strKecheng & "' order by newid()"rs.Open sql1, Conn, 1, 1
rs.Close
Set rs = Nothing
Next
Conn.CloseSet Conn = Nothing
End Sub请大家帮忙看看!
焦头烂额。试了一些改法,但仍显示此错误。完全不知怎么改。
不然,我的系统就夭折在这个问题上了。
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = server.CreateObject("ADODB.Connection") '----此处变黄。“要求对象”
Set rs = server.CreateObject("adodb.recordset")
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
Conn.Open "Provider=SQLOLEDB.1;Password=; Persist Security Info=True;User ID=sa;Initial Catalog=weilecture;Data Source=(local)"
End SubPrivate Sub Command1_Click()
For i = 1 To 5
sql1 = "select top 1 timubiaoti,timudaan,chapter,tixing from bjtutimubase where tixing='简答题' and chapter='" & Str(f(i)) & "' and kecheng='" & strKecheng & "' order by newid()"rs.Open sql1, Conn, 1, 1
rs.Close
Set rs = Nothing
Next
Conn.CloseSet Conn = Nothing
End Sub请大家帮忙看看!
焦头烂额。试了一些改法,但仍显示此错误。完全不知怎么改。
不然,我的系统就夭折在这个问题上了。
解决方案 »
- VB显示循环显示文本框内容
- vb6.0/vb.net 怎么给某个进程发送个消息?
- VB更新MySQL时,碰到非常奇怪的问题(急)!!!
- 请问如何将内存中的位图直接存储到数据库中?
- FTP的问题!!!(急)
- 请问各位大虾vb 中怎样使用 sdk
- 如何把JPG文件放入资源文件中,需要是再从资源文件中提出来?
- 请问:如何使用scrollwindow 及 scrollwindowex API函数。
- 怎样从IE缓存中提到网页文件
- VB 有没有反编译器,可以读取注册码的?
- 大家用什么报表控件进行开发
- 同时查找字段a和字段b在子查询中,in的正确用法写,我这样写是不对的,请指教:"update tab1 set d="2.1" where a,b in (select a,b from tab
Set Conn = server.CreateObject("ADODB.Connection") '----此处变黄。“要求对象”
Set rs = server.CreateObject("adodb.recordset")
Set rs = New ADODB.Recordset
Set Conn = server.CreateObject("ADODB.Connection") '----此处变黄。“要求对象”
Set rs = server.CreateObject("adodb.recordset")顺序应该是这样吧!
Set rs = New ADODB.Recordset
应该这样定义变量
这是在定义变量吗?
Set Conn = new ADODB.Connection
Set rs = new adodb.recordset
Set Conn = new ADODB.Connection
Set rs = new adodb.recordset
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = CreateObject("ADODB.Connection") '----此处变黄。“要求对象”
Set rs = CreateObject("adodb.recordset")
'Set Conn = New ADODB.Connection
'Set rs = New ADODB.Recordset
Conn.Open "Provider=SQLOLEDB.1;Password=; Persist Security Info=True;User ID=sa;Initial Catalog=weilecture;Data Source=(local)"
End Sub