Data grid population using recordset

[newbie1983]

I would like to populate a datagrid with all the rows contained in a recordset, how would i go about doing this? i dont really want to use the data environment or any other binding method as alot of errors have occurred as a result. Any ideas would be much appreciated

Regards,

newbie1983

 

[ZOR]

Have you considered the Flexgrid control. There is a FAQ on it. You can do so much more with this control, only a thought. Regards

 

[demoman]

The datagrid is very easy to use. create an adodc, set the recordsource & recordset properties. then set the grid's datasource to the adodc. no need to use the data environment. there is some overhead with an adodc, if your data is relatively static you can close it just like any other recordset when not reqired to be open. i use the adodc/datagrid quite a bit and with very few problems.

 

[bbrendan]

hi newbie,

The ADODC control is ok, but tends to be a little flaky, and slow

I would rather use code like the following

-----------------------------------------------
Public Sub GetTbltitle()

Dim objConn As ADODB.Connection
Dim strConnect As String
Dim strSQL As String

strConnTitle = INI_getString("String", "ConnectString1", App.Path & "\dataconn.ini")

Set objConn = New ADODB.Connection
Set oRSTitle = New Recordset
oRSTitle.CacheSize = 100
oRSTitle.CursorLocation = adUseClient

strSQL = "select * from tbl_title"

oRSTitle.Open strSQL, strConnTitle, adOpenDynamic, adLockBatchOptimistic, adAsyncFetch

Set frmMain.TDBGridTblTitle.DataSource = oRSTitle
frmMain.TDBGridTblTitle.ReBind

End Sub
-------------------------------------------