MVC Combo Box Control

MVC (Model, View, Controller) & CRUD (Create, Read, Update, Delete)

Project name : prjWin_MVC_ComboBox_selector_Rm

Fall-2018

Description

Implementing a basic CRUD Functionality(create, read, update, delete) code with the MVC (model, view, controller) philosophy in C # .NET, focusing in the ComboBox control.

This project focus in the MVC philosophy.

Prerequisites

• Microsoft Visual Studio Community 2015 Version 14.0.25425.01 Update 3
• Programming language : C#.
• Object Oriented Programming.
• SQL server Management Studio v17.9.
• Programming language : SQL Server.
• MVC Concepts.

Videos

• Understanding MVC architecture
• SQL Server connection
• CRUD with MVC

Installation

Download and install.

• Install Visual Studio
• Install SQL Server
• Dowland the MVC_ComboBox_selector project

Create the database with SQl server.

1.- Create the data base : open SQL Server Management Studio, open a new query and run SqlServer/1_init_DataBase.sql

MVC_CRUD_Cs_ComboBox_selector/SqlServer/1_init_DataBase.sql

2.- Create the Stored Procedures : run SqlServer/2_create_StoredProcedures.sql

MVC_CRUD_Cs_ComboBox_selector/SqlServer/2_create_StoredProcedures.sql

3.- Fill up the tables : run SqlServer/3_fill_Tables.sql

MVC_CRUD_Cs_ComboBox_selector/SqlServer/3_fill_Tables.sql

4.- Create Views : run SqlServer/4_create_Views.sql

MVC_CRUD_Cs_ComboBox_selector/SqlServer/4_create_Views.sql

5.- The class clsConnection connects the SQL Server and the Visual Studio.

static private string stringConnection = "Data Source = .; DataBase = bd_combobox_crud; Integrated Security = true";

Data Base Diagram.

Author

• Ricardo Mendoza - Programmer Analyst

Running the test

Inteface loads the grid when it starts.

We can select a client by combo box Employee or combo box Agencies.

We can select a row and loads the texts boxes then we can update a clietn.

Save and update are executed with the same button.

Built With

• Microsoft Visual Studio Community 2015 Version 14.0.25425.01 Update 3
• SQL server Management Studio v17.9.

Versions and source manager.

This project uses GitHub.com as source manager in the following repository:

https://github.com/RicardoAMendoza/MVC_CRUD_Cs_ComboBox_selector.git

License

This project is licensed under the MIT License - see the LICENSE.md file for details

• Copyright Ricardo Mendoza
• the MIT License (MIT)

Acknowledgments

• Andy Del Risco - MENTOR, Technicien Informatique Cl. Principale École des métiers de l’aérospatiale de Montréal
• Fernand Tonye - MENTOR, Chief d'Equipe Informatique pour les enseignants Institut Teccart
• Charles Vilaisak - MENTOR, Registraire à l'École nationale de cirque École nationale de cirque
• Jesvin Ciril Joachim - MVC
• RJ Code Advance - CRUD
• Derek Banas - SQL Server and Visual Studio Installation
• Institut Teccart