Alternative to ADODB Recordset (1 Viewer)

Simon_MT

Registered User.
Local time
Today, 22:08
Joined
Feb 26, 2007
Messages
2,177
Is there a better solution to ADODB Recordset.

I've had my fill DataAdapters and Datagrids I just want the records and I'm perfectly capable of doing the rest from there but using Recordcounts Absolutepositions Paging and Divs.

Simon
 

Banana

split with a cherry atop.
Local time
Today, 15:08
Joined
Sep 1, 2005
Messages
6,318
I have to admit confusion - you ask for alternative to ADODB then talk about DataAdapters & DataGrid which are .NET components. Are you talking about using the Data.OleDb to populate those adapters/grids? Does the data source have an ADO.NET provider?
 

Simon_MT

Registered User.
Local time
Today, 22:08
Joined
Feb 26, 2007
Messages
2,177
The reason I'm asking is a performance issue and seeing if there is a better method. I don't use Classes, Functions or subs as before I use For intRecord = 1 To rs.PageSize I decare the Header, Tags Body and the Artist Name as they only need to appear once. Once If intRecord = intRow has been reached then we start with the Navigation which is the right.

This is what I'm using at the moment, the Select has been truncated
Code:
    connString =  Application("my_conn")
    conn = New ADODB.Connection
    conn.Open(connString)
    rsSql = "SELECT  ArtistsGroupings.[Artist Grouping] ... _
    FROM ArtistsGroupings WHERE ArtistsQuery.[Artist] = '" & Application("Artist") & "' 
    ORDER BY ArtistsGroupings.[Artist Grouping Seq]"
    rs = New ADODB.Recordset
    rs.CursorLocation = 3 'adUseClient
    rs.CursorType = 3 'adOpenStatic
    rs.let_ActiveConnection(conn)
    rs.open(rsSql)
    rs.MoveFirst()
    rs.PageSize = 25
    rs.CacheSize = rs.PageSize
    intPageCount = rs.PageCount
    intRecordCount = rs.RecordCount

Simon
 

Users who are viewing this thread

Top Bottom