|
One of the first things you will probably need to do with
SQLitePlus is display query results in your application. If you are not
using our WOW control with HSP, or if you need a Grid control, then you should
consider using the SQLitePlus Grid control. It is very easy to use. In fact, you only need to
set a SQLitePlus Dataset into the Grid control and it will automatically display
it. Here's a screenshot:
Here's a VB example of how to use the Grid control:
Dim db As New
SqliteDb
Dim ds As Dataset
m_db.Init "sqlt307.dll"
db.Open App.Path & "\northwind.db", eReadWrite
Set ds = m_db.Exec("SELECT * FROM Suppliers")
Set
SqlitePlusGrid1.Dataset = ds
db.Close
|
The SQLitePlus Database
Explorer uses the Grid control to display its result sets.
Editable Datasets
The SQLitePlus Grid control can be used to directly edit a
table. The table must have been opened using the
"OPEN TABLE" command. Double-clicking on a field
changes it to an edit box. Here is how you would
create an editable Dataset with the OPEN TABLE command:
Dim db As New
SqliteDb
Dim ds As Dataset
m_db.Init "sqlt307.dll"
db.Open App.Path & "\northwind.db", eReadWrite
Set ds = m_db.Exec("OPEN TABLE Suppliers")
Set
SqliteGrid1.Dataset = ds
db.Close
|
Its Free
Use the Grid freely in your SqlitePlus applications.
|
See how to build Dynamic WPF
Database Products
