Skip to content

muhammad-shozab/WinForms-Database-Project

Repository files navigation

Inventory Management System (WinForms)

A desktop-based Inventory Management System developed using C# WinForms and SQL.
This project was created as an academic database project with a focus on real-world inventory workflows.


Features

  • User authentication (Admin & Cashier)
  • Product and category management
  • Inventory tracking
  • Order and sales handling
  • Role-based access control

Technologies Used

  • C#
  • Windows Forms (WinForms)
  • SQL
  • ADO.NET

Database Design

The database is designed using relational principles and includes:

  • Users
  • Products
  • Categories
  • Orders
  • Customers

The complete database schema is available in:


Screenshots

Login Screen
image

Admin Dashboard
image

Add Products
image

Cashier Order Panel
image


How to Run the Project

  1. Clone the repository
  2. Open Database.sql in mySQL and execute it
  3. Open the .sln file in Visual Studio
  4. Update the connection string in App.config
  5. Run the project

Academic Purpose

This project was developed as part of a Database Systems course to demonstrate:

  • Database integration with desktop applications
  • CRUD operations
  • Real-world inventory workflows

Author

Muhammad Shozab

About

WinForms application with mySQL database

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages