Live Demo

Database CRUD Operations

Connect, query, insert, update, and delete with SQLite via ADODB

Product List (3 rows)

ID Name Price Stock Category
2 Gadget $24.99 50 Electronics ×
4 Thingamajig $49.99 25 Electronics ×
5 Whatchamacallit $14.99 75 General ×

Add Product (INSERT)

Aggregate Stats

3
products
$29.99
avg price
150
total stock

Edit / Reset

Click a row id below to edit, or reset all data.

2: Gadget 4: Thingamajig 5: Whatchamacallit
Reset Sample Data