14587.html
来自「VB技巧问答10000例,是一个教程」· HTML 代码 · 共 30 行
HTML
30 行
<html>
<head>
<title>请问如何读取总笔数?</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>请问如何读取总笔数?</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:joef@tomail.com.tw">Joef</a> on June 24, 1999 at 17:17:17:<p>
我是用程式方式去open database<br>Dim cnPersonal As Connection<br>Dim rsDepartment As Recordset<br>Dim c As Integer<br>Set cnPersonal = New Connection<br>Set rsDepartment = New Recordset<p>With cnPersonal<br> .Provider = "Microsoft.Jet.OLEDB.3.51"<br> .ConnectionString = "Data Source = d:\work\personal\personal.mdb;"<br> .Open<br>End With<p>With HFGDepartment<br> rsDepartment.Open "department", cnPersonal,adOpenDynamic<br> adLockReadOnly<br> .<br> .<br> .<br>end with<br>我用过rsDepartment.Recordcount去读取department表格的总笔数,但是不行,<br>不知我方法错误,可否告之如何读取谢谢
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 14587-->
<!--top: 14609--><li><a href="14609.html">Cursor 指到 Server 了</a> <b>Sephiroth</b> <i>09:36:11 6/25/99</i>
(<!--responses: 14609-->1)
<ul><!--insert: 14609-->
<!--top: 14612--><li><a href="14612.html">Re: Cursor 指到 Server 了</a> <b>Joef</b> <i>11:21:30 6/25/99</i>
(<!--responses: 14612-->0)
<ul><!--insert: 14612-->
</ul><!--end: 14612-->
</ul><!--end: 14609-->
</ul><!--end: 14587-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?