VISUAL C# .NET WITH MYSQL

VISUAL C# .NET WITH MYSQL
Author : Vivian Siahaan
Publisher : BALIGE PUBLISHING
Total Pages : 348
Release : 2020-09-13
ISBN 10 :
ISBN 13 :
Language : EN, FR, DE, ES & NL


In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be more familiar when applying them to some applications in this book. In chapter two, you will go through step by step to build a SALES database using MySQL. You will build each table and add associated data fields (along with the necessary keys and indexes). The first field in the Client table is ClientID. Enter the clien ID in the Name Field and select AutoNumber in the Data Type. You define primary key and other indexes which are useful for quick searching. ClientID is a primary field. You will define FamilyName as an index. You then will create Ordering table with three fields: OrderID, ClientID, and OrderDate. You then will create Purchase table with three fields: OrderID, ProductID, and Quantity. And you will create Product table with four fields: ProductID, Description, Price, and QtySold. Before designing Visual C# interface, you will build the relationships between four tables. The interface will be used to enter new orders into the database. The order form will be used to enter the following information into the database: order ID, order date, client ID, client’s first name and family name, client’s address, product information ordered. The form will have the ability to add new orders, find clients, add new clients. The completed order invoice will be provided in a printed report. In chapter three, you will build a database management system where you can store information about valuables in your warehouse. The table will have seven fields: Item (description of the item), Location (where the item was placed), Shop (where the item was purchased), DatePurchased (when the item was purchased), Cost (how much the item cost), SerialNumber (serial number of the item), PhotoFile (path of the photo file of the item), and Fragile (indicates whether a particular item is fragile or not). The development of this Warehouse Inventory Project will be performed, as usual, in a step-by-step manner. You will first create the database. Furthermore, the interface will be built so that the user can view, edit, add, or add data records from the database. Finally, you add code to create a printable list of information from the database. In chapter four, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. The steps that need to be taken in building Siantar Air Quality Index (SAQI) database project are: Build and test a Visual C# interface; Create an empty database using code; and Report database. The designed interface will allow the user to enter max pollutant, min pollutant, and air quality for any date that the user chooses in a particular year. This information will be stored in a database. Graphical result of the data will be provided, along with summary information relating to the maximum value, minimum value, and mean value. You will use a tab control as the main component of the interface. The control has three tabs: one for viewing and editing data, one for viewing graph of pollutant data, and another for viewing graph of air quality data. Each tab on this control operates like a Visual C# control panel. In chapter five, you will perform the steps necessary to build a MySQL book inventory database that contains 4 tables. You will build each table and add the associated fields as needed. You will have four tables in the database and define the relationship between the primary key and foreign key. You will associate AuthorID (foreign key) field in the Title_Author table with AuthorID (primary key) in the Author table. Then, you want to associate the ISBN (foreign key) field in Title_Author table with ISBN (primary key) in the Title table.

More Books:

VISUAL C# .NET WITH MYSQL
Language: en
Pages: 348
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-09-13 - Publisher: BALIGE PUBLISHING

In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be m
Database Management System Using Visual C# .NET: MySQL, SQL Server, and Access
Language: en
Pages: 740
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-09-14 - Publisher: BALIGE PUBLISHING

Book 1: VISUAL C# .NET WITH MYSQL: A Definitive Guide to Develop Database-Oriented Desktop Applications In chapter one, you will learn to know the properties an
LEARN FROM SCRATCH VISUAL C# .NET WITH MYSQL
Language: en
Pages: 684
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-10-05 - Publisher: BALIGE PUBLISHING

In Tutorial 1, you will start building a Visual C# interface for database management system project using MySQL. The database, named DBMS, is created. The desig
VISUAL C# .NET AND DATABASE
Language: en
Pages: 402
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-10-21 - Publisher: BALIGE PUBLISHING

This book aims to develop a database-driven desktop application that readers can develop for their own purposes to implement database-oriented digital image pro
VISUAL C# .NET FOR PROGRAMMERS
Language: en
Pages: 392
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-09-07 - Publisher: BALIGE PUBLISHING

In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be m
VISUAL C# .NET: A Step By Step, Project-Based Guide to Develop Desktop Applications
Language: en
Pages: 244
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-11-23 - Publisher: BALIGE PUBLISHING

In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# application. You need to learn and know in order to be m
VISUAL C# .NET FOR STUDENTS: A Project-Based Approach to Develop Desktop Applications
Language: en
Pages: 346
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-11-23 - Publisher: BALIGE PUBLISHING

In chapter one, you will learn to know the properties and events of each control in a Windows Visual C# applications. You need to learn and know in order to be
LEARN FROM SCRATCH VISUAL C# .NET WITH SQL SERVER To Develop Database-Driven Desktop Applications
Language: en
Pages: 686
Authors: VIVIAN SIAHAAN
Categories: Computers
Type: BOOK - Published: 2020-10-10 - Publisher: BALIGE PUBLISHING

In Tutorial 1, you will start building a Visual C# interface for database management system project with SQL Server. The database, named DBMS, is created. The d
Enterprise Development with Visual Studio .NET, UML, and MSF
Language: en
Pages: 984
Authors: Eric Hansen
Categories: Computers
Type: BOOK - Published: 2004-05-24 - Publisher: Apress

Thomsen and Hansen give easy-to-understand examples and provide readers with everything they need to create Enterprise solutions with .NET.
Two Books In One: Learn From Scratch Visual C# .NET with SQL SERVER and MYSQL
Language: en
Pages: 1371
Authors: Vivian Siahaan
Categories: Computers
Type: BOOK - Published: 2020-11-05 - Publisher: BALIGE PUBLISHING

BOOK 1: LEARN FROM SCRATCH VISUAL C# .NET WITH SQL SERVER To Develop Database-Driven Desktop Applications In Tutorial 1, you will start building a Visual C# int