> Hello,
> I would lige to give a datagrid.datasource a recordset resulting
> from a query of SQLite, but I do not know how to do, since SQLite
> cannot give me a RecordSet as result (I guess...).
> Someone coul give me a tip? Some (free) wrapper to VB6 that
> support recordsets?
My wrapper (dhSQLite) supports COM-based ADO-
Databinding.
To bind to a VB6-Datagrid you will have to do the following:
Private Cnn as cConnection, Rs as cRecordset
Set Cnn = New cConnection
Cnn.OpenDB FileName
Set Rs = Cnn.OpenRecordset("Select * from Tbl...")
Set Datagrid.Datasource = Rs.DataSource
That's all.
@ Dwight:
The wrapper at phxsoftware is not ADO-compatible AFAIK.
(ADO and ADO.NET are two different animals, since
ADO is part of the COM-world as is VB6)
Regards,
Olaf Schmidt
--
View this message in context:
http://www.nabble.com/How-to-bind-data-to-Data-Grid-VB6-tf4547337.html#a12989633
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
