Project: Inventory System In C# With Source Code
Inventory System is a simple desktop application developed using C# Language. The project is based on the concept of managing records. Talking about the system, a user has to pass through a login system for using its features. The admin can stock master, stock out, returns, etc.
The user can manage stock master; for this, the user has to enter the item name, description, category, price, and quantity. Naturally, the user can CRUD functions on it. After this, the user can manage stock out, return by entering the customer id, transaction id, name, address, and adding items. From settings, he/she can add categories and item-unit. The last feature of this system in about the User management system, where the admin can add and arrange the roles of different users.
The design of this is so simple that the user won’t find difficulties while working on it. Inventory System project helps the user on managing stock items record. For handling data, MySQL is used as a database. This project is easy to operate and understood by the users. To run this project you must have installed Visual Studio IDE and XAMPP on your PC. Inventory System in C# is free to download with source code. For the project demo, have a look at the video above.
Project Features:
- Login System
- Manage Stock master, out, return
- Generate report
- Settings
- User management system
How To Run??
Start Apache and MySQL in XAMPP, and follow the given steps
Connecting Database (MySQL)
1st Step: Open a browser and go to URL “http://localhost/phpmyadmin/”
2nd Step: Then, click on the databases tab
3rd Step: Create database naming “ db_inventory ” and then click on the Import tab
4th Step: Click on browse file and select “db_inventory.sql” file which is inside “Database (MySQL)” folder
5th Step: Click on go.
After Creating Database,
Final Step: Open “InventorySystem1.0.sln” file.
Insert the username and password which is provided inside the “Readme.txt” file.
Other Requirements To Run The Project:
- Connector/NET
- MySQL Connector/ODBC
- To generate reports, download Crystal Reports for Visual Studio here: Download
error when logging in it says authentication to host ‘localhost’ for user ‘root’ using method ‘caching_sha2_password’ plss help
Hi
In this project, it been used mysqli.
Why use xampp. What’s the purpose. We can use mysqli without xampp or any web server.
Any particular reason.
By using xampp. Can we allow the users access a specific folder in the web server.
If yes. Appreciate if any one can explain how it can be done.
Thank you for your very constructive comment. This is just for educational purposes source code for beginners on how to connect csharp into xampp and its database. But anyway, your comment is highly appreciated.
h! sir, how to download and install crystal reports?
You can download it here: https://www.campcodes.com/giveaways/software/crystal-reports-visual-studio-2019-installer/