一个按钮一个文本框一个模块
Private Sub Command1_Click() Dim Rs As New ADODB.Recordset
Dim Str As String
Str = "select * from aa"
Rs.Open Str, Con
Text1.Text = Rs.Fields("a")
Rs.Close
End Sub
'模块
Option ExplicitPublic Con As ADODB.ConnectionSub main()
Dim Str As String
Set Con = New ADODB.Connection
Str = "provider=SQLOLEDB.1;" & _
"data source=.;" & _
"initial catalog=master;" & _
"user id=sa;password=sa"
Con.Open Str
Form1.Show
End Sub
总显示连接无法用于执行此操作.在此上下文中它可能已被关闭或无效.问题究竟在哪里呢??
Private Sub Command1_Click() Dim Rs As New ADODB.Recordset
Dim Str As String
Str = "select * from aa"
Rs.Open Str, Con
Text1.Text = Rs.Fields("a")
Rs.Close
End Sub
'模块
Option ExplicitPublic Con As ADODB.ConnectionSub main()
Dim Str As String
Set Con = New ADODB.Connection
Str = "provider=SQLOLEDB.1;" & _
"data source=.;" & _
"initial catalog=master;" & _
"user id=sa;password=sa"
Con.Open Str
Form1.Show
End Sub
总显示连接无法用于执行此操作.在此上下文中它可能已被关闭或无效.问题究竟在哪里呢??
解决方案 »
- commondialog.cancelerror = true 为什么捕获不到?
- 在线快速结贴~~~急~~~简单问题
- 请问vc++和vb哪一个更好学?
- @@@@@@@@各位仁兄,怎样禁止修改系统时间或让程序运行时得到CMOS的时间?@@@@@@
- 如何在制作ASP的Dll组件时添加Internet Transfer Control和winsock控件???来者有分,不够再加!
- 怎样给VB程序加一个Photoshop做成的按钮?
- vb中退出到windows如何实现?
- 请教关于记录键盘输入的问题(〓高分相送!!!〓)
- 窗体与模块之间的疑问
- 请教各位高手,在哪里能得到关于对 Office进行编程的资料,要求是比较深入的
- Connection.....Recordset............ADO连接问题......谢谢...在线等
- 求教一个关于 Package & Deployment Wizard 的问题
Private Rs As New ADODB.RecordsetPrivate Sub Command1_Click()
Dim conStr As String
dim sqlstr as string
Conn.CursorLocation = adUseClient
conStr = "provider=SQLOLEDB.1;" & _
"data source=.;" & _
"initial catalog=master;" & _
"user id=sa;password=sa"
Con.Open conStr
sqlStr = "select * from aa"
Rs.Open sqlStr, Con
Text1.Text = Rs.Fields("a")
Rs.Close
End Sub
Set Con = New ADODB.Connection
设为全局的就可以了