28,406
社区成员
发帖
与我相关
我的任务
分享不好意思，问一个初级问题。
在获取数据库中的记录之前，有很多种方法连接数据库，如先建立connection通道，再用recordset，或者直接用recordset等等，多种方法，但是这些方法有什么区别？优点，缺点呢？
...全文
请发表友善的回复…
发表回复
redleaf 2002-02-28
- 打赏
- 举报
尽管我还是很糊涂,但还是很谢谢你.
karma 2002-02-27
- 打赏
- 举报
the concept is same, always use one Connection object.
If you have single Recordset or single Command, then use connection string, because, internally, ADO will construct a Connection Object for you
If you have single Recordset or single Command, then use connection string, because, internally, ADO will construct a Connection Object for you
redleaf 2002-02-27
- 打赏
- 举报
能再说详细点吗?还有command呢?
karma 2002-02-27
- 打赏
- 举报
if you are going to use Connection object in multiple places, for example, if you have
set rs = conn.execute(sql)
...
set rs2 = conn.execute(sql)
...
rs3.Open sql, conn
then you should 建立connection通道first
but if you are just going to use Recordset once, then you should just do
Recordset.Open sql, connection_string,...
set rs = conn.execute(sql)
...
set rs2 = conn.execute(sql)
...
rs3.Open sql, conn
then you should 建立connection通道first
but if you are just going to use Recordset once, then you should just do
Recordset.Open sql, connection_string,...
pukerno3 2002-02-27
- 打赏
- 举报
区别就是在速度和效率上有所差异。
