DB Administration Software

Overview

This is a database administration software coded in C# with a modern and professional design. It is still under development and aims to provide an intuitive and ergonomic user interface for managing databases. The software allows for simplified management of data, including additions, modifications, deletions, and visualizations. It also includes features such as drop-down menus, logo customization, and a modern color palette. The project follows good practices in terms of naming, factorization, comments, and the use of stored procedures and triggers.

Features

• Intuitive navigation with menus
• Add, modify, and delete forms for selected tables
• Operational total input controls with regular expressions and error handling
• Advanced search for tables and the entire database
• Automatic generation of data summary PDFs for each table

Prerequisites

• Windows
• WAMP Server
• HeidiSQL
• Visual Studio
• .NET Framework
• SQL

Steps

1. Start the WAMP Server environment.
2. Import the DataBase.sql database into your database administration software (HeidiSQL).
3. Launch the software in Visual Studio.

Note: If you encounter the "Mark of the Web" error in Visual Studio, follow these instructions:

• Right-click on the FrmMain.resx file in Visual Studio's Solution Explorer.
• Select Properties.
• In the properties, look for the "Security" or "General" section.
• If you see an "Unblock" option or something similar, click on it to unblock the file.
• Save the changes and try rebuilding your project to see if the error persists.

Configuration

You can modify the FrmConnexion.cs file to automatically fill in the login information in the login form.

Summary

This is a database administration software coded in C# with a modern design. It is still under development and aims to provide an intuitive and ergonomic user interface for managing databases. The software includes features such as intuitive navigation, add/modify/delete forms for tables, operational input controls, advanced search functionality, and automatic data summary generation. It follows good programming practices and requires Windows, WAMP Server, HeidiSQL, and Visual Studio for installation.