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.
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?
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
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.