Hello everyone

the following is my connection string to the database

instantiate the connection object
Set cn = New ADODB.Connection
'specify the connectionstring
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Ruhsa Health Station\RHS.mdb"
'open the connection
cn.Open

'instantiate the recordset object
Set rs = New ADODB.Recordset
'open the recordset
With rs
.Open "tblPatient_Details", cn, adOpenKeyset, adLockPessimistic, adCmdTable
'loop through the records until reaching the end or last record

End With




Now if i want to use a Data grid, Flex grid or Grid how do i connect it with the database and how do i display it in the one of the GRIDS

Please help