FUNCTIONX SAMPLE APPLICATIONS
FUNCTIONX
This website provides a few samples exercises to help you practice programming. Some applications are for databases in Microsoft Access and Microsoft SQL Server. Some other applications are for various ways to be introduced to C#, C++, Visual Basic, F#, etc. There are console applications, desktop graphical applications (WinForms), and web-based applications in ASP.NET MVC and ASP.NET Core.
The applications follow detailed step-by-step instructions with many screenshots so you can follow along.
MS ACCESS - WATTS' A LOAN
VBA, ADO, Tables, Queries
Watts' A Loan: is a small fictitious company that issues loans to people and small businesses. This exercise is an application for such a small company. This version uses Microsoft Access.
MS SQL SERVER - COLLEGE PART AUTO PARTS
SQL, Transact-SQL, Database
Microsoft SQL Server is one of the leaders in the enterprise database market. This College Park Auto-Parts exercise is an introduction to creating a database and a table, then adding records.
WINFORMS - STELLAR WATER POINT - XML
XML, Windows Forms, Collections
The eXtensible Markup provides a good solution to create a text-based database. This Stellar Water Point example is an approach to such an application.
RAZOR PAGES - ADO.NET - WATER
ASP.NET Core, Razor Pages
The Stellar Water Point is an ASP.NET Core application with Razor Pages.
VBA ACCESS - CAR RENTAL
Database, Access, VBA
Visual Basic for Application is a good option to test a database and especially to test code that is involved in database development. That is the idea with this Bethesda Car Rental database.
MS SQL - STELLAR WATER POINT
SQL Server, Database, Transact-SQL
Stellar Water Point is a small relational database for a water distribution company. The database has three tables and some stored procedure.
WINFORMS - STELLAR WATER POINT
WinForms, XML Serialization
This exercise is one more way to study collections and create an XML-based application. That's the purpose of this Stellar Water Point application.
RAZOR PAGES - WATTS' A LOAN
C#, Razor Pages, Entify Framework, HTML/CSS
This version of our Watts' A Loan application is written for ASP.NET Core as Razor Pages. The application uses a CSS file that has its own formats and modifies some of the Bootstrap formats.
MS ACCESS - DEPARTMENT STORE
Database, VBA, Programming
This is the Fun Department Store application. It is designed in Microsoft Access as project. VBA code is written to create and manage records, and to perform necessary operations.
MSSQL - APARTMENT RENTAL
SQL, Transact-SQL, Database
This Apartment Rental Management project is a database created in Microsoft SQL Server. The example contains relational tables and stored procedures.
RAZOR PAGES - XML - STELLAR WATER POINT
ASP.NE Core, Razor Pages, XML
One of the options offered by ASP.NET Core is Razor Pages, which in turn provides various options. This Stellar Water Point project explores the option to create a web project that uses XML for its database.
jQuery - TRAFFIC TICKETS SYSTEM
MVC, WEB API, Entity Framework, jQuery
To experiment with a relatively complex application, we create one as a Traffic Tickets System that is used to manage traffic tickets for a fictitious police department.
MS ACCESS - WATTS' A LOAN
VBA, ADO, Tables, Queries
Watts' A Loan: is a small fictitious company that issues loans to people and small businesses. This exercise is an application for such a small company. This version uses Microsoft Access.
MS SQL SERVER - WATTS' A LOAN
SQL, Transact-SQL, Database
Here is simple SQL (Transact-SQL) code to create a basic relational database (tables, foreign keys, primary keys) in Microsoft SQL Server. The database is named Watts' A Loan.
WINFORMS - STELLAR WATER POINT - XML
XML, Windows Forms, Collections
The eXtensible Markup provides a good solution to create a text-based database. This Stellar Water Point example is an approach to such an application.
jQuery - APARTMENTS RENTAL
ASP.NET, MVC, WEB API, jQuery
The Apartments Rental Management is an ASP.NET Web API application that starts as MVC. Some records interactions require events. That's where we use jQuery.
VBA ACCESS - CAR RENTAL
Database, Access, VBA
Visual Basic for Application is a good option to test a database and especially to test code that is involved in database development. That is the idea with this Bethesda Car Rental database.
MS SQL - BETHESDA CAR RENTAL
SQL, Database, Transact-SQL, Tables
This Bethesda Car Rental project is a small relational database. It contains many tables, one of which has two foreign keys from the same table (Employees).
WINFORMS - ADO.NET STELLAR WATER POINT
ADO.NET, Windows Forms, C#
This Stellar Water Point project is a Windows Forms application where database connection and management are made using ADONET with the C# language.
WINFORMS - ADO.NET: CPAP
WinForms, C#, ADO.NET, SQL Server
This is a Windows Forms (WinForms) app. College Park Auto-Parts is a Windows Forms application that uses a Microsoft SQL Server database with records processed in the .NET Framework.
ENTITY FRMWRK - CAR RENTAL
ASP.NET, MVC, Entity Framework
This Entity Framework application, Bethesda Car Rental, starts as an ASP.NET MVC project. It contains a database created from the Empty Code First Model option.
WINFORMS - WATTS' A LOAN
C#, ADO.NET, SQL, Stored Procedures
SQL as a language presents many options when creating a database. One option is on stored procedures. This Watts' A Loan project includes such examples.
C# - WINFORMS - XML: BCR
C#, WinForms, XML, XPATH
This is the Bethesda Car Rental application. It is a Windows Forms (WinForms) application. The records are save in XML. The records are located using XPATH.
COLLECTIONS - ALTAIR REALTORS
WinForm, Linked Lists, JSON Serialization
In a certain lesson on collections, we were studying collections, and particularly, linked lists. From there, we created Altair Realtors, a same serialization project.
C# WINFORMS - XML SERIALIZATION
C#, Classes, Serialization
Watts' A Loan: This application is an exercise for a fictitious small company that provides various types of loans to persons and small businesses, using XML Serialization.
C# XML - WATTS' A LOAN
C#, XML, Database
In this exercise, we create an XML database for a small company named Watts' A Loan. We review ways to save records as XML in a graphical application, namely WinForms.
MVC - ENTITY FRAMEWORK - WATTS' A LOAN
ASP.NET, MVC, Entity Framework
This small application explores one of the options to create a database project using the Entity Framework, namely the Code First From Database option. This is for our Watts' A Loan business.
jQuery - WATER DISTRIBUTION COMPANY
ASP.NET, MVC, jQuery, Entity Framework
The Water Distribution Company application combines ASP.NET, MVC, the Entity Framework, and jQuery. The application was created in MS Visual Studio.
RAZOR PAGES - APARTMENTS RENTAL
ASP.NET, Razor Pages, Entity Framework
The Apartments Rental Management application was created in the Razor Pages version of Microsoft Visual Studio with its Entity Framework database.
ASP.NET MVC - ADO.NET - WATTS' A LOAN
MVC, ADO.NET, MS SQL Server
This Watts' A Loan application is an "old school" way to create and manage a database. It is created as an ASP.NET MVC project where the records are managed using ADO.NET.
ASP.NET MVC - WATER DISTRIBUTION
ASP.NET, MVC, XML
This XML application, Water Distribution Company, is an ASP.NET MVC project. The records of the application are visually created and managed in XML.
C# XML - FUN DEPARTMENT STORE
C#, WinForms, XML
This Fun Department Store Application is written was originally completely written in C# and compiled at the Command Prompt. You can still open it in MS Visual Studio and build it.
C# WINFORMS XML - SOLO MUSIC STORE
C#, XML, WinForms
XML is a wonderful solution for database applications. The Solo Music Store application is an example of an XML database application.
MVC ADO.NET - APARTMENT RENTAL
C#, MVC, ADO. NET, Database
This version of the Apartment Rental Management application is an ASP.NET MVC database application. The tables are created using SQL code. The records too are created and managed in SQL.
XML SERIALIZATION - CPAP
WinForms, Lists
You can create a complete database using built-in lists classes. To manage the records of such an application, you can use Xml serialization, as demonstrated in this College Park Auto-Parts.
jQuery - WATTS' A LOAN
ASP.NET, MVC, WEB API, jQuery
Watts' A Loan is a an ASP.NET Web API application with the Entity Framework database. Some record processings need events on Web forms. This made us use jQuery.
WINFORMS - DATA SET: CPAP
C#, WinForms, Data Set, XML
This is a Windows Forms (WinForms) app. College Park Auto-Parts is a text-based database that is created from the Data Set sub-library of the .NET Framework. The records are save in XML.
jQuery - BETHESDA CAR RENTAL
ASP.NET, MVC, WEB API, jQuery
Bethesda Car Rental is an ASP.NET MVC Web API application that uses the .NET Framework 4.8 version. The Entity Framework database is created using the Empty Code First Model option.