🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #354

Re: ADO Open������

#354
From: ��ϵ����*Shiyanʲôʱ�����*5������
Date: Fri, 06 Mar 2009 04:52
31 lines
2201 bytes
���ʸ����⣺
rs.Open sql, cn, adOpenDynamic, adLockOptimistic, 1
�����Ǹ�1��ʲô��˼���ҿ�ò��һֱ���ĸ���������ӣ���֪��1���ʲô�أ�
�� �� zxxia (����) �Ĵ������ᵽ: ��
: ��  ��: ADO Open������
: ����վ: ��ˮ˼Դ (2009��03��05��12:52:35 ������)
: 
: 
: Dim cn As New ADODB.Connection           '����һ��Ado����
: Dim rs As New ADODB.Recordset            '����һ��Ado��¼��
: Dim sql As String                        '����һ���ַ����
: Set cn = CurrentProject.Connection       '����cn���ڵ�ǰ����
: sql = "SELECT * FROM [QPM AVG]"          '���ַ�ֵ
: rs.Open sql, cn, adOpenDynamic, adLockOptimistic, 1  '��һ����¼��������rs
: 
: �������ڵ��Ե�ʱ��ϵͳ˵��Open ��������һ������û�б�ָ���� ��ʲôԭ���أ�
: ��̴�����лл
: --
: 
: �� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 219.228.123.4]


--
Hebei
��������Զ��ů�ļ�

qq����ϵ����

��Ʒ����ӭ���� Tea ��

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.26.99]
Technical Details
Message-ID: <4eh352$aSd@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,3a8cbc17eecf4c96
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTU
From: qqlover.bbs@bbs.sjtu.edu.cn (��ϵ����*Shiyanʲôʱ�����*5������)
Newsgroups: cn.bbs.comp.database
Subject: Re: ADO Open������
Date: 06 Mar 2009 04:52:39 GMT
Organization: ��ˮ˼Դ
Message-ID: <4eh352$aSd@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1236315122.A
Lines: 30