代码:
Public DATA_CONNECTION As String
Private rs As ADODB.RecordsetPrivate Sub Command1_Click()
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM t_site where siteID=10000", _
DB_CONNECTION_STRING, adOpenForwardOnly, adLockReadOnly
If Not rs.EOF Then
Text1.Text = rs("siteName")
End If
rs.Close
Set rs = Nothing
End SubPrivate Sub Form_Load()
DATA_CONNECTION = "Server=10.10.2.30;PROVIDER=SQLOLEDB;UID=sa;PWD=;DATABASE=abc"
End Sub运行报“rs as ADODB.Recordset”用户定义类型未定义怎么弄?
Public DATA_CONNECTION As String
Private rs As ADODB.RecordsetPrivate Sub Command1_Click()
Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM t_site where siteID=10000", _
DB_CONNECTION_STRING, adOpenForwardOnly, adLockReadOnly
If Not rs.EOF Then
Text1.Text = rs("siteName")
End If
rs.Close
Set rs = Nothing
End SubPrivate Sub Form_Load()
DATA_CONNECTION = "Server=10.10.2.30;PROVIDER=SQLOLEDB;UID=sa;PWD=;DATABASE=abc"
End Sub运行报“rs as ADODB.Recordset”用户定义类型未定义怎么弄?
解决方案 »
- VB中文本框绑定到DataEnvironment的问题
- 一个很纠结的sql查询,不知道能不能实现,各位老大来看看。
- ADO操作记录集的问题
- 如何确定CommonDialog控件中,是选择了“保存”还是选择了“取消”或“帮助”?
- 怎样在vb中用代码创建新窗体
- 如何用VB建立系统热键? (问题解决马上给分)
- Access中记录分组统计(sql)出来的值为什么会出现很长的小数位,单个记录中没这么长?
- 用DAO操作ACCESS的问题
- 这么一个项目给多少钱合适?
- 如何通过代码控制窗体的最小化按钮的隐藏和显示
- 如何在程序中,读取一个word文档的内容。请大家提供一个可行的方法!谢谢了
- 请大家支持一下,有几个问题关于数据库
实时错误3001Arguments are of the wrong type, are out of accepteable range, or are in conflict with one another