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

Mike & Doris Manning mikedorism at verizon.net
Fri Jul 22 07:10:43 CDT 2005

In .Net, you use DataAdapters, Datasets, and DataReaders to work with data.
A DataAdapter has Select, Insert, Update, and Delete commands.

You use the DataAdapter to fill a Dataset.  A Dataset can contain as many
tables as you like.  Each Table is indexed according to the order it is
added to the dataset.

A DataReader is a forward only dataset used when you just want to read
through the data once.

To work with the individual rows of a dataset, you would do the following.

Dim dt as Table	'Variable to hold the Dataset table you want to work with
Dim dr as Row	'Variable to refer to the row in the Dataset table.

Dt = ds.Tables(0)		'Set the DataTable variable to the Dataset

For Each dr in dt			'Loop through the rows in the
	'Do something		'Do something
Next dr				'Advance to the next row

Doris Manning
Database Administrator
Hargrove Inc.

-----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

More information about the dba-VB mailing list