This project is a C# Windows Forms desktop application that simulates a basic Game Rental System. It demonstrates full CRUD (Create, Read, Update, Delete) operations connected to a SQL Server database.
- View game rental data with JOIN queries across multiple related tables (Games, Vendors, Rentals, Clients, Users).
- Insert new records into:
- Users & Clients
- Vendors
- Games
- Rentals & related tables
- Update game and vendor details selectively.
- Delete game records along with related rental, retail, and supplies data safely (with confirmation prompts).
- Friendly Windows Forms interface using
DataGridViewand standard controls.
- C# (.NET Framework)
- Windows Forms (WinForms)
- SQL Server (Local Database)
The full database schema and sample data are included in the SchemaAndData.sql file. You can run this script in SQL Server Management Studio to recreate the database used in this project.