��̹��VB�ж�ȡ��ݿ��ݵ��

Article View: cn.bbs.comp.lang.visual-basic

Article #39

Back to cn.bbs.comp.lang.visual-basic Previous Next

#39

From: dqkit
Date: Wed, 07 Feb 2007 15:06

11 lines
1388 bytes

��λ��������֪����VB��ΰ���ݿ�����һ���������ĳһ�е����ͳ�Ƴ���������Select count(*)=num from....��ȡ����ֻ����DataGrid��ʾ��������֪����ΰ�num��ֵ�ŵ�һ��textBox�����أ�лл��
������datagridʱ��Դ�룺
Private Sub Command1_Click()
     Data1.RecordSource = "SELECT count(*),sum(*) FROM answered WHERE 
     person=" & "'" & Text1.Text & "'"
     Data1.Refresh
End Sub
��������һ���ı���������Ҫ�������ġ�
--

[m[36m�� ��Դ ����ɾ�bbsվ http://bbs.scau.edu.cn [FROM: 58.62.223.*][m

Technical Details

Message-ID: <4SRA5B$_yH@bbs.scau.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!news.szu.edu.cn!SCAU

Show Full Headers

Complete Article Headers

X-Google-Thread: 109fdd,41e8b45a93b9e937,start
X-Google-Attributes: gid109fdd,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!newsfeed.media.kyoto-u.ac.jp!news.neu.edu.cn!news.szu.edu.cn!SCAU
From: dqkit@bbs.scau.edu.cn-SPAM.no (dqkit)
Newsgroups: cn.bbs.comp.lang.visual-basic
Subject: ��̹���VB�ж�ȡ��ݿ���ݵ�����
Date: 07 Feb 2007 15:06:35 GMT
Organization: ����ɾ�
Message-ID: <4SRA5B$_yH@bbs.scau.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: VB/M.1170860795.T0

Article View: cn.bbs.comp.lang.visual-basic

��̹���VB�ж�ȡ��ݿ���ݵ�����

��̹��VB�ж�ȡ��ݿ��ݵ��