ADO.Net equivalent of the ADO rs.GetRows() method

[Ali M]

Hi, I had a VB application that exported the values of one column -
all rows - to an array by doing:
rs.movefirst
ar = rs.getrows(, , "col2")

What is the equivalent to this in ADO.Net?
Thanks
Ali

 

[Joyjit Mukherjee]

Hi,

If you are using a DataReader, which is readonly & forwardonly, you could
use something like

while dr.Read()
{
Get all the values
}

If you are using a Dataset, you could use indexers like

var = Ds.Tables[0].Rows[j]

See more on the section on ADO .NET in MSDN at
http://msdn.microsoft.com/library/d.../en-us/cpguide/html/cpconoverviewofadonet.asp

Thanks
Joyjit

 

[Cor Ligthert]

Ali,

In ADONet you do not need it as Joyjit already wrote because the datatable
is already a collection (array of objects).

However there are such a lot of posibilities extra to select rows.

Have by instance a look at the datatable.select
http://msdn.microsoft.com/library/d.../frlrfsystemdatadatatableclassselecttopic.asp

But there are much more.

I hope this helps?

Cor