Since I have a lot of electronic components and I always lose track of my inventory, I decided to write my own SQLite-based management System in C#.
This project was not only for “inventory times”, but also for myself for learning object oriented programming and managing databases.
And yes, I tried a few of the freeware solutions out there, like LaVa or ElaLa, but none of them fit my needs, and often the GUI was terrible or way too complicated.
So I inspired myself by the softare a friend of mine wrote. It was written in Java, but it still was in the beginning and far away from a stable release and he had no time to develop it further.
So I decided I will write my own with a simple interface, slim design, compatability of the databases for a new version (so you don’t need to start all over again) and standalone without the need of installing a database server (like MySQL).
Features are added step by step and not all at once.
Beta-testers are welcome! Also if you have suggestions, please let me know.
Current features overview:
- Creating new database
- Adding new tables to the database with as much columns as you want
- Adding new entries to the tables
- Adding, editing, saving and deleting data in tables
- Sorting your data
- Delete existing tables
- Delete columns in tables
- Conditional formatting (e.g. for quantity alert)
- Multi-Language support
- Help-file integrated
- Tables can be exported as CSV-files
- Tables can directly be printed
- Generating barcodes
- Scanning barcodes
Versions:
Wait, no V0.5? Correct! V0.5 was not really a standalone version. I just worked a bit on the GUI and performance, but nothing else.
Also I adressed the problems around barcodes, so I implemented these too.
Now you can generate QR, MicroQR, Data-Matrix, Code-39, Code-22 and Code-128 barcodes following a specific pattern. The strings are specially encoded which you can read aout in the help file.
functions and changelog will follow
Finally a new Release. Normally I would’ve done a GUI-update, but not all my testers had given their feedback, so I implemented a few new functions.
The new functions are
- Help-file integrated
- Tables can be exported as CSV-files
- Tables can directly be printed
Bugfixes:
- none
Known Bugs:
- Strings in integer cells cause errors
- Comboboxes can be overwritten, results in errors
Planned for V0.5:
- Performance-Update
- GUI-Update
- more Bugfixes
Small bugfix along the line, since a few bugs could potentially corrupt your database…
Following bugs got fixed:
- Spaces in table and column names were causing errors
- Spaces and other characters are now filtered out (RegEx)
- SQL-Logic-Error after adding a new column
- Wrong declaration of class, fixed
- Textfield-bugs
- A few textfields and comboboxes were not recognizing that they are empty. Resulted in bugs in the database and in the code.
Fixed
- A few textfields and comboboxes were not recognizing that they are empty. Resulted in bugs in the database and in the code.
The new Release is a bigger update with a lot of changes. A few bugfixes, prevented user-errors and new functions.
New funktions:
- Deleting columns in tables
- Conditional formatting (e.g. for quantity alert)
- Multi-Language-Support
Bugfixes:
- (), {}, [], % and & are blocked if typed as input
- Datatype BLOB is causing errors, removed
- SQL-Syntax-Errors fixed
- datatype mismatch-Errors fixed
Known Bugs:
- Strings in integer cells cause errors
- Comboboxes can be overwritten, results in errors
- Spaces in table and column names were causing errors
- SQL-Logic-Error after adding a new column
- Textfield-Bugs
Planned for V0.4
- Bugfixes
- Clear conditional Formatting before formatting again
- Search-function
- New help page (more user friendly)
V0.2 and V0.1 redacted for brevity