dim rs as recordeset
Set Rc2 = DB.OpenRecordset("select * from table2")dim rs as new adodb.recordeset
rs.open "select * from table1",cn
Set Rc2 = DB.OpenRecordset("select * from table2")dim rs as new adodb.recordeset
rs.open "select * from table1",cn
解决方案 »
- COOLGRID中如何删除选定的多行?
- 为何不能在SQL SERVER中添加记录
- 关于shell的奇怪问题,急急!!!
- 自己做了個控件, 模擬combox, 現在的問題是按了下拉顯示按鈕後,在任務欄出現了個新窗口. 如何不讓他出現
- 用activebar的高手请进来,给分手不软!
- 请教:如何把接收的即时数据用图表形象的表示出来
- 请大家帮忙推荐VB入门书籍,谢谢!在线等!
- 求大神交流如何用VB6.0写类似于QQ的聊天软件。。
- 谁能用(for each..next)(array)(isarray)(redim)编一个程式!?
- msflexgrid控件
- 为什么我知道的VB程序员,都会涉及到出差呢?
- MS 网络传输控件Internet Transfer 帐号不起作用????
Dim rs As New ADODB.Recordset' After cn is openedWith rs
'.ActiveConnection = cn
'.CursorType =
'.CursorLocation =
'.LockType =
.Open "Select * From TableName"
End With
以下是ado编写的 '用特定的筛选条件(MyRecordSource)连接特定的数据库(MyDatabase)两个参数来连接数据库中的某张表(MyTable),数据库的密
'码为DataBasePassword
'并指定特定的字段(MyFields),返回特定的值,不绑定数据控件Function adoconnect3(ByVal MyDatabase As String, ByVal MyTable As String, ByVal MyFields As String, ByVal MySQLCondition1 As String) As Recordset
Dim MyRs As ADODB.Recordset
Dim MyConnectString As String
Dim sql As String
''' 打开连接。
MyPath = getapppathparent + "database\"
MyConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & MyPath & MyDatabase & ";Jet OLEDB:Database Password=" & DataBasePassword
Set MyCnn = New ADODB.Connection
MyCnn.Open MyConnectString
''建立RecordSet
Set MyRs = New ADODB.Recordset
sql = "SELECT " & MyFields & " FROM " & MyTable & MySQLCondition1
MyRs.CursorLocation = adUseClient
MyRs.LockType = adLockBatchOptimistic
MyRs.CursorType = adOpenKeyset
''给函数赋值
MyRs.Open sql, MyCnn
Set adoconnect3 = MyRs
End Function