Open the app

VB.NET Windows program to web app

The tool room's Windows program, now a web app

Who has the thermal camera? When is it due? What's in repair? Now on any phone or browser.

Open the app Move my VB program

Before VB.NET, Windows Forms, one PC
The original Windows program's Items screen: a form with four text boxes, a Save button and a grid of four items with database column names as headings
After Web app, any browser
The same equipment in the web app: a searchable list with each item's brand, location, and how many are on the shelf, on loan and in repair
  • 30 kinds of equipment
  • 123 on the shelf
  • 17 out on loan
  • 5 overdue
  • 2 in repair

Try it

  1. 1

    Check something out. Sign in as anyone and borrow a multimeter. Digital multimeter

  2. 2

    Hit a limit. Both thermal cameras are out, one overdue. Thermal camera

  3. 3

    Return it broken. It goes to the repair bench, not the shelf. Loans

  4. 4

    Export to Excel. A real .xlsx file, no Office needed. Reports

Fixed on the way

Found while reading the original's code. Old business programs usually hide a few like these.

  • One delete removed every record. A stored procedure's parameter had the same name as its column, so WHERE id = id matched every row.

  • The stock count could go blank. A database trigger lost the count when a loan was deleted. Now counts are worked out from the loans, never stored.

  • Adding an item failed. A trigger called a procedure that wasn't in the database.

  • An apostrophe broke a loan. Typed text went straight into the SQL. Now every value is passed safely.

  • Passwords in plain text. Gone: people sign in with their company account.

  • Returned before it went out. Dates are now checked, and returned loans stay in the history instead of being deleted.

What moved where

In the Windows programOn the web
MySQL on the same PC, as root, no passwordA server database, backed up, with its own account
Windows Forms screensReact screens that work on a phone
VB.NET behind the buttons, triggers in the databaseC# rules every change goes through, with tests
Export through Excel on the PCA real .xlsx download, no Office needed
Users table with passwordsCompany sign-in; staff and tool room see different things

Where it comes from

The original is Inventory Management App by Diaz Adriansyah, a VB.NET Windows Forms program under the MIT License, written for a lab in Indonesia. Its screens above are from the project's page. The web app follows its screens and tables; the company, people and history are fictional.

Open the app How we built it WinForms to web VB6 to web