ADODB Get X Record.

[astrodestino]

Hi!
I got an access db and I am accessing it thru ADODB

Here is how I open the rs:

MasterConn.ConnectionString = MasterAccessConnect
MasterConn.Open(MasterAccessConnect)
MasterRs = New ADODB.Recordset
MasterRs.Open("SELECT * FROM noticias where idcategoria=" & l.Tag, MasterConn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)

How can I read the third record without looping thru the database?

Tnx!

 

[ThatRickGuy]

You could use a DataSet and Datatable from ADO.Net.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[astrodestino]

Yes, I could but using this I throw 3 lines and I can get the records...
But tnx anyway I made it using absolutepage.
Cya!

 

[ThatRickGuy]

I hear ya! While I think the back end of ADO.Net is awesome, I miss the 3 object model of ADO. The more I work with ADO.Net though, the more I like it.

-Rick

----------------------
If you're about to post an ASP.Net question,
please don't do it in the VB.Net forum

http://www.ringdev.com

I believe in killer coding ninja monkeys.