[dba-VB] Vb.net ADO Equivelent to recordset

Jim DeMarco Jdemarco at hudsonhealthplan.org
Fri Jul 22 06:53:43 CDT 2005


I don't have an example handy at the moment but I believe you can walk the records in a given table in a Dataset object.  I may have something here to show you if I get a chance to look around later.

Jim DeMarco

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Friday, July 22, 2005 7:27 AM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] Vb.net ADO Equivelent to recordset

I need to manipulate a recordset like I would in VBA

	with rst
		SomeVar = !SomeField
		SomeVar2 = !SomeField2
	end with

What is the equivalent in ADO / .net?  I do not need to bind this to a
control, and all of the examples I am finding for .NET assume I just want to
bind it to a grid or a list or something.

In fact I do want to bind it to a class if that is possible.  I am building
a class pair where one class represents an individual record, and the parent
class represents a table (an indexed collection of the record classes).  The
first class has properties (variables) for each field in the table, and the
init will load the values in.  The second class needs to open the
"recordset", and then start instantiating the first class, initializing with
data from a given record, storing in a collection and moving to the next

I have done all of this in ADO in VBA using the adodb.recordset object but
don't find the equivalent in .net.

John W. Colby

Contribute your unused CPU cycles to a good cause:

dba-VB mailing list
dba-VB at databaseadvisors.com

"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".

More information about the dba-VB mailing list