Warning This README.md file and this project are still under development.
📊 This repository is made to contain a Database administration software coded in C# with a modern and professional design.
A database administration software coded in C#.net still in development adapted and improved from a school project coded in VB.Net. it includes an intuitive and ergonomic Navigation, whether on its design thought to be adaptable and customizable, the implementation of drop-down menus, a place reserved for the logo or even on its modern and professional color palette all this with a certain quality of the man-machine interface. It allows a simplified management of additions, modification, deletion and visualization of data according to the rights allowed by the connected user. Input controls are total and operational, an advanced search of tables and the complete database and also implement as well as the Generation of a pdf of an automatic data summary for each table The project respects a good number of good practices whether for naming, factorization, regions, comments, the use of store procedures and triggers, storage and the creation of a class library (dll) allowing exchange with database data.
this software aims to have an operation and an autonomous interface according to the database connected to it while keeping a complete practice taking into account the different parameters and functions of a classic database administration software like the management of functions, stored procedure, trigger, etc . . .
- Start WampServer environment.
- import the
DataBase.sqldatabase into your database administration software. (HeidiSQL)- Launch the software in Visual Studio.
Home Page
Note If you encounter the
Mark of the Weberror, which is a common error on visual studio, please 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.
You can modify the file
FrmConnexion.csto automatically fill in the login information in the form.
private void btnPreSet_Click(object sender, EventArgs e)
{
tbServeur.Text = "server";
tbBase.Text = "DataBase";
tbId.Text = "id";
tbMDP.Text = "password";
}
Login Page
functionalities State Description Intuitive navigation / Menus / Design / Consistency, HMI quality, professional appearance ✅ - Add/Modify/Delete form(s) for a selected table ✅ - Operational total input controls (regular expressions, errorProvider, etc.) ✅ - Advanced tuple search (e.g. customer or product) ✅ - Operational and ergonomic order management ✅ - Generate pdf order summary ✅ - Best naming and storage practices ✅ - Code factoring (getLesTuples, executerRequeteSelect, etc.) ✅ - Input control code (use of regexes, etc.) ✅ - calling up a STORED PROCEDURE set up for CONSULTATION ✅ - call (application side) and code of parameterized procedure ✅ - call a STORED PROCEDURE set to ACTION ✅ - call a parameterized STORED FUNCTION ✅ - automatic TRIGGER call ✅ - Multi-connection mode with multiple users and associated MySql rights ✅ - Visualization Database Views, procedures, functions, triggers, events on the software ❎ - automatic software adaptability to database structure and data ❎ -
libraries Description MySql.Data.dllis a .NET data provider that enables communication between a .NET application and a MySQL database. It provides a set of classes and methods that allow developers to connect to, query, and manage data in a MySQL database from within their .NET applications. This DLL is widely used in .NET projects that need to interact with MySQL databases, enabling seamless data integration and manipulation. itextsharp.dllis a popular open-source library for working with PDF documents in the .NET environment. It allows developers to create, manipulate, and extract content from PDF files programmatically. With iTextSharp.dll, you can generate PDF files from scratch, merge existing PDFs, add images, text, tables, and other elements to PDF documents, and even digitally sign them. This library is commonly used in various .NET applications that require PDF processing, such as generating reports, filling forms, or managing document workflows. Note that iTextSharp.dll is a port of the original Java iText library adapted for .NET development. I used a data generation tool called generatedata to randomly generate data for my database.
This database administration software coded in C#.net is adapted and improved from a school project coded in VB.Net by O.ALBERT & B.ROUCHON.
