Find Code:
All Words
Any of the Words
Exact Phrase
Home
:
Code
:
Forums
:
Submit
:
Mailing List
:
About
:
Contact
Code
All
VB.NET
ASP.NET
C#
VB Classic
ASP Classic
Snippets
Popular
Resources
Submit Code
Forums
Articles
Tips
Links
Books
Contest
Link to us
Show you how to use ado NextRecordset. ...
Author:
Mike g
E-mail:
Click to e-mail author
Website:
http://www.ivbnet.com
Submitted:
7/30/2001
Version:
VB5
Compatibility:
VB5, VB6
Category:
Databases
Views:
12247
Show you how to use ado NextRecordset.
Declarations:
'none
Code:
Private Sub cmdLoad_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset 'Run multi select statment rs.Open "SELECT au_lname FROM authors; SELECT fname FROM employee", _ "dsn=pubs", adOpenForwardOnly, adLockReadOnly Do While Not rs.EOF Me.lstAu.AddItem rs.Fields(0) rs.MoveNext Loop 'Get Next rs Set rs = rs.NextRecordset Do While Not rs.EOF Me.lstEmp.AddItem rs.Fields(0) rs.MoveNext Loop Set rs = Nothing End Sub
Home
|
Forums
|
Submit
|
Books
|
Mailing List
|
Advertising
|
About
|
Contact
© 2024 A1VBCode. All rights reserved.
Legal disclaimer & terms of use
Privacy statement