A Grocery Store GUI based application. Have 2 types of users, i.e. Admin & Customer. The data is stored using SQL Local Database.
Install the .NET Framework in the MS Visual Studio. Clone the repository and open it.
- Microsoft.Data.SqlClient package installed
- New database is added
- Two tables, i.e. Customers & Products are added
Go to Tools > NuGet Package Manager > Manage NuGet Packages for Solution...
Then search for "Microsoft.Data.SqlClient"
Install the package in the project
Go to View > SQL Server Object Explorer
Go to "(localdb)\MSSQLLocalDB...." and then right-click on Databases and Add New Database
Go to the created database, right-click on Tables and Add New Table
Add the "Customers" table as follows and click on Update
Also, Add "Products" table as follows and click Update
Let's get connected!
You can also follow my GitHub Profile to stay updated about my latest projects:
If you liked the repo then kindly support it by giving it a star ⭐!
Copyright (c) 2020 MUHAMMAD AHMAD KHAN