Alternative to ADODB Recordset

[Simon_MT]

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]

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]

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

    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

 

[Simon_MT]

I sussed it out. Datagrids only present old-fashioned Tables, TRs and TDs. All very well for inert lists but what about including images and data sensitive links? I don't think so.

I will start a separate thread on Paging.

http://www.access-programmers.co.uk/forums/showthread.php?t=267121

Simon