Queryng Acees Database

[Luis]

Hello,

In VB6.0 if I have a recorset and I want to move to a
specific location on it (let´s say a Field wich is the
primary key and is autoincrement) I woul type .Findfirst
where IDPAC = 5.
With the tecnology in VB.NET How can I do the same, ou
similar?

What I wont to do is to move to a specific record in a
table or recordset where my primary as a determined value.

Thanks in advance

[William Ryan]

Totally depends on what objects you are using? For instance, in a keyed
DataTable, you could use the .Select method. In a DataView, you could set
the .RowFilter. You can move around a BindingContext as well.

In a DataReader, you only now about one row at a time, so you'd need to walk
it until you found the value you are looking for (DataReaders are great
objects, but not well suited to what it appears you are looking for).
"Luis" <an*******@discussions.microsoft.com> wrote in message
news:03****************************@phx.gbl...
Hello,

In VB6.0 if I have a recorset and I want to move to a
specific location on it (let´s say a Field wich is the
primary key and is autoincrement) I woul type .Findfirst
where IDPAC = 5.
With the tecnology in VB.NET How can I do the same, ou
similar?

What I wont to do is to move to a specific record in a
table or recordset where my primary as a determined value.

Thanks in advance

[Herfried K. Wagner [MVP]]

* "Luis" <an*******@discussions.microsoft.com> scripsit:

In VB6.0 if I have a recorset and I want to move to a
specific location on it (let´s say a Field wich is the
primary key and is autoincrement) I woul type .Findfirst
where IDPAC = 5.
With the tecnology in VB.NET How can I do the same, ou
similar?

Maybe this group is better for the topic of your question:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Cor]

Hi Luis,

Using a dataset you do more than with a recordset.
Some here typed examples (so there can be little errors)

To get in the 3th row the Item "Luis" in the first table of ds,
(ds=dataset)
ds.tables(0).rows(2)("luis") or if you want
ds.tables(0).rows(2).item("luis")

to find the first row in a table where the key is "luis"
dim dr as new datarow
'"luis" is the key colomn
dr = ds.tables(0).rows.find("luis")

to select a couple of rows
dim drselect() as datarow
drselect = ds.tables(0).select("myselectstatement")

And there are thousands more possiblities

What is confusing is that all documentation is in:
datasets
datatables
datarows
datarowscollections

But look at the introduction to datasets

http://msdn.microsoft.com/library/de...ondatasets.asp

I hope this helps?

Cor





"Luis" <an*******@discussions.microsoft.com> schreef in bericht
news:03****************************@phx.gbl...
Hello,

In VB6.0 if I have a recorset and I want to move to a
specific location on it (let´s say a Field wich is the
primary key and is autoincrement) I woul type .Findfirst
where IDPAC = 5.
With the tecnology in VB.NET How can I do the same, ou
similar?

What I wont to do is to move to a specific record in a
table or recordset where my primary as a determined value.

Thanks in advance