✦ Store Management System
This project is a C# Windows Forms application for managing a store's database. It provides a graphical user interface to interact with products, customers, and orders data stored in a SQL Server database.
Features
- View Data: Display data from the database in a tabular format.
- Search: Search for specific records within the database.
- Filter: Filter data based on various criteria.
- Update: Modify existing records in the database.
Technologies Used
- C#: The application is written in C#.
- Windows Forms: Used for the graphical user interface.
- .NET: Built on the .NET framework.
- SQL Server: The backend database for storing data.
Setup and Installation
- Clone the repository:
1 git clone
- Open the project in Visual Studio: Open the StoreProject.sln file in Visual Studio.
- Restore NuGet packages: The required NuGet packages should be restored automatically by Visual Studio. If not, you can do it manually through the NuGet Package Manager.
Database Setup
- Create the database: The StoreProject.sql file contains the necessary SQL script to create the database and tables. Execute this script in your SQL Server instance.
- Configure the connection string: The database connection string is located in the Constants.cs file. You will need to update the con variable to point to your SQL Server instance.
1 // Example connection string in Constants.cs 2 public static string con = "Data Source=YOUR_SERVER_NAME;Initial Catalog=Store;Integrated Security=True;";
Usage
- Build the project: Build the solution in Visual Studio (Build > Build Solution).
- Run the application: Start the application by pressing F5 or clicking the "Start" button in Visual Studio.