Live Demo

Database CRUD Operations

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

Product List (3 rows)

ID Name Price Stock Category
1 Widget $9.99 100 Tools ×
3 Doohickey $4.99 200 Hardware ×

Add Product (INSERT)

Aggregate Stats

3
products
$21.66
avg price
325
total stock

Edit / Reset

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

1: Widget 3: Doohickey
Reset Sample Data