📄 17819.html
字号:
<html>
<head>
<title>Re: VB6 ADO Recordset问题?</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: VB6 ADO Recordset问题?</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by 大汉堡 on August 24, 1999 at 23:47:21:<p>
In Reply to: <a href="17722.html">VB6 ADO Recordset问题?</a> posted by Lai on August 23, 1999 at 14:49:20:<p>
: vb6 dao上 <br>: dim db as database<br>: dim rs1 as recordset<br>: dim rs2 as recordset<br>: Set db = DBEngine.Workspaces(0).OpenDatabase("xxx.mdb")<br>: Set rs1 = db1.OpenRecordset("table1",dbOpenTable)<br>: Set rs2 = db1.OpenRecordset("table2",dbOpenTable)<br>: 请问在vb6 ado上要如何描述?或有何书籍可参考<p>基本上ADO及DAO所开启的RecordSet是不同的,其属性也<br>有相当程度的差异(虽然DAO我仅练习时用过),所以要<br>作这个描述,会觉得难以下手<br>但如要使用ADO,可如下宣告<br>Dim rs1 as New ADODB.Recordset<br>Dim rs2 as New ADODB.Recordset<br>Dim SQL_str as String<br>Dim CON_str as String<br>SQL_str = 要Run的SQL Statement(若为Select则传回Recordset)<br>CON_str = ConnecttionString<br>rs1.open CON_str,SQL_str(后面还有两个有关Recordset的属性,这里不说了)<br>这样就可开启rs1这个ADO的Recordset<br>若想更深入...王国荣先生的'VisualBasic资料库程式设计' <br>有详细的介绍
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 17819-->
</ul><!--end: 17819-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -