Live Demo

Database CRUD Operations

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

Product List (4 rows)

ID Name Price Stock Category
8 Widget $9.99 100 Tools ×
9 Gadget $24.99 50 Electronics ×
10 Doohickey $4.99 200 Hardware ×
11 Thingamajig $49.99 25 Electronics ×

Add Product (INSERT)

Aggregate Stats

4
products
$22.49
avg price
375
total stock

Edit / Reset

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

8: Widget 9: Gadget 10: Doohickey 11: Thingamajig
Reset Sample Data