Skip to content

Product Manager with SQL Queries is a WinForms application developed in C#. It allows managers to perform CRUD operations on a list of products and categories, which are stored in an MS SQL Server database. The app uses SQL commands to manage the database, demonstrating efficient database management through direct SQL queries.

License

Notifications You must be signed in to change notification settings

zabavb/Product-manager-with-sql-queries

Repository files navigation

Product Manager Logo

Product Manager with SQL Queries

Project Overview

Product Manager with SQL Queries is a Windows Forms application developed in C#. It allows managers to perform CRUD operations on a list of products and categories, which are stored in an MS SQL Server database. The app uses SQL commands to manage the database, demonstrating efficient database management through direct SQL queries. The interface has a partially dynamic build, providing flexibility for user interactions.

Project Details

  • Languages: C#
  • Technologies: .NET Framework MS SQL Server
  • IDE: Visual Studio
  • Project Type: WinForms Application

Development Details

This project was created at 12.07.2023 as part of a homework assignment at IT Step Computer Academy. It showcases the integration of SQL queries with a C# WinForms application for managing product and category data in an MS SQL Server database.

Getting Started

To run the project, follow these steps:

  1. Clone the repository:
    git clone https://github.com/zabavb/Product-manager-with-sql-queries.git
  2. Ensure you have an MS SQL Server database set up. Update the connection strings in the configuration file.
  3. Open the solution in Visual Studio, build the project, and run the application.

Features

  • SQL Query Integration: Perform CRUD operations on product and category data using direct SQL queries.
  • WinForms Interface: The application provides a user-friendly interface for managing data, with a partially dynamic build for a flexible user experience.

Contributing

Contributions are welcome! If you have any suggestions or improvements, please feel free to fork the repository and submit a pull request.

  1. Fork the Repository: Click the "Fork" button at the top-right of this page.
  2. Create a Branch: Create a new branch for your changes.
  3. Commit Changes: Make your changes and commit them with a descriptive message.
  4. Push to Your Fork: Push your changes to your forked repository.
  5. Submit a Pull Request: Go to the "Pull Requests" tab and submit a new pull request.

Contact

If you have any questions, feel free to reach out at email or connect with me on LinkedIn.

Acknowledgements

  • Thanks to IT Step Academy for the guidance and resources provided for this project.
  • Special thanks to the open-source community for tools and frameworks used in this project.

Feel free to modify or extend this README to fit your needs better. Happy coding!

About

Product Manager with SQL Queries is a WinForms application developed in C#. It allows managers to perform CRUD operations on a list of products and categories, which are stored in an MS SQL Server database. The app uses SQL commands to manage the database, demonstrating efficient database management through direct SQL queries.

Topics

Resources

License

Stars

Watchers

Forks

Languages