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

Start the WAMP Server environment.
Import the DataBase.sql database into your database administration software (HeidiSQL).
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.

Lenysauzet

DB Administration Software