ADO.NET RecordSet Equivalent

[Frank]

Hi, group sorry for this Question but really need help, What would be the
similar method in ADO.NET like MoveNext in ADO RecordSet.


Best Regard
Frank

 

[Chris Taylor]

Hi,

The DataReader interface provides the Read method which moves forward
through the result cursor, but this is a forward only cursor. Using the
DataTable/DataView you have random access the rows using an indexer on the
Rows property or you can process each row using the foreach statement.

Hope this helps

Chris Taylor

 

[Frank]

Mr. do you mean that I can check the limits of my DataTable for the count
property of the Rows collection for up limit and Rows[0] for the low limit .
?

Best regard

 

[Chris Taylor]

Hi,

Yes, when using DataSet and DataTable you are working with disconnected data
ie. you are no longer referencing the original datasource. This is very much
like the previous ADO disconnected recordsets.

Regards

Chris Taylor

Mr. do you mean that I can check the limits of my DataTable for the count
property of the Rows collection for up limit and Rows[0] for the low limit ..
?

Best regard

Hi,

The DataReader interface provides the Read method which moves forward
through the result cursor, but this is a forward only cursor. Using the
DataTable/DataView you have random access the rows using an indexer on the
Rows property or you can process each row using the foreach statement.

Hope this helps

Chris Taylor

 

[Frank]

Thank. Mr. Chris.

Best Regard
Frank.
From Venezuela

Hi,

Yes, when using DataSet and DataTable you are working with disconnected data
ie. you are no longer referencing the original datasource. This is very much
like the previous ADO disconnected recordsets.

Regards

Chris Taylor

Mr. do you mean that I can check the limits of my DataTable for the count
property of the Rows collection for up limit and Rows[0] for the low

limit

.
?

Best regard






be
the

 

[Cor]

Hi Frank,

Maybe this will help you
(Rough written)

First row
dataset.tables(0).rows(0)(item)
the next row is
dataset.tables(0).rows(1)(item)

You have of course to know if the rows exist

you therefore can use things as
dataset.tables.count and dataset.tables(0).rows.count

Very simple I thought.

I hope this helps a little bit?

Cor

 

[Frank]

Thank, so much. Budy