Learn From Scratch Visual C Net With Mysql To Develop Desktop Applications
Learn From Scratch Visual C Net With Mysql To Develop Desktop Applications Book in PDF, ePub and Kindle version is available to download in english. Read online anytime anywhere directly from your device. Click on the download button below to get a free pdf file of Learn From Scratch Visual C Net With Mysql To Develop Desktop Applications book. This book definitely worth reading, it is an incredibly well-written.
Learn From Scratch Visual C#.NET with MySQL to Develop Desktop Applications by Rismon Hasiholan Sianipar,Vivian Siahaan Pdf
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 designed interface in this tutorial will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table.In Tutorial 2, you will build a project, as part of database management system, where you can store information about valuables in school. 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).In Tutorial 3 up to Tutorial 4, you will perform the steps necessary to add 6 tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a library database project, as part of database management system, where you can store all information about library including author, title, and publisher.In Tutorial 5 up to Tutorial 7, you will perform the steps necessary to add 8 more tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a high school database project, as part of database management system, where you can store all information about school including parent, teacher, student, subject, and, title, and grade.
LEARN FROM SCRATCH VISUAL C# .NET WITH SQL SERVER To Develop Database-Driven Desktop Applications by VIVIAN SIAHAAN Pdf
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 designed interface in this tutorial will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table. In Tutorial 2, you will build a project, as part of database management system, where you can store information about valuables in school. In Tutorial 3 up to Tutorial 4, you will perform the steps necessary to add 6 tables into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a library database project, as part of database management system, where you can store all information about library including author, title, and publisher. In Tutorial 5 up to Tutorial 7, you will perform the steps necessary to add 6 more tables into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a high school database project, as part of database management system, where you can store all information about school including parent, teacher, student, subject, and, title, and grade.
LEARN FROM SCRATCH VISUAL C# .NET WITH MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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 designed interface in this tutorial will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table. In Tutorial 2, you will build a project, as part of database management system, where you can store information about valuables in school. 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). In Tutorial 3 up to Tutorial 4, you will perform the steps necessary to add 6 tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a library database project, as part of database management system, where you can store all information about library including author, title, and publisher. In Tutorial 5 up to Tutorial 7, you will perform the steps necessary to add 8 more tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a high school database project, as part of database management system, where you can store all information about school including parent, teacher, student, subject, and, title, and grade.
VISUAL C# .NET WITH MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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.
Two Books In One: Learn From Scratch Visual C# .NET with SQL SERVER and MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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# interface for database management system project with SQL Server. The database, named DBMS, is created. The designed interface in this tutorial will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table. In Tutorial 2, you will build a project, as part of database management system, where you can store information about valuables in school. In Tutorial 3 up to Tutorial 4, you will perform the steps necessary to add 6 tables into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a library database project, as part of database management system, where you can store all information about library including author, title, and publisher. In Tutorial 5 up to Tutorial 7, you will perform the steps necessary to add 6 more tables into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a high school database project, as part of database management system, where you can store all information about school including parent, teacher, student, subject, and, title, and grade. BOOK 2: LEARN FROM SCRATCH VISUAL C# .NET WITH MYSQL To Develop Database-Driven Desktop Applications 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 designed interface in this tutorial will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table. In Tutorial 2, you will build a project, as part of database management system, where you can store information about valuables in school. 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). In Tutorial 3 up to Tutorial 4, you will perform the steps necessary to add 6 tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a library database project, as part of database management system, where you can store all information about library including author, title, and publisher. In Tutorial 5 up to Tutorial 7, you will perform the steps necessary to add 8 more tables using phpMyAdmin into DBMS database. You will build each table and add the associated fields as needed. In this tutorials, you will create a high school database project, as part of database management system, where you can store all information about school including parent, teacher, student, subject, and, title, and grade.
LEARN FROM SCRATCH VISUAL BASIC .NET WITH MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
This book will teach you with step-by-step approach to develop from scratch a MySQL-driven desktop application that readers can develop for their own purposes to implement school database project using Visual Basic .NET. In Tutorial 1, you will perform the steps necessary to add 8 tables using phpMyAdmin into School database that you will create. You will build each table and add the associated fields as needed. In this tutorial, you will also build login form and main form. In Tutorial 2, you will build such a form for Parent table. This table has thirteen fields: ParentID, FirstName, LastName, BirthDate, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need fourteen label controls, two picture boxes, six text boxes, four comboxes, one check box, one date time picker, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, six buttons for other utilities, one button for searching member’s name, one button to upload parent’s photo, and button to upload parent’s finger. Place these controls on the form. In Tutorial 3, you will build such a form for Student table. This table has fifteen fields: StudentID, ParentID, FirstName, LastName, BirthDate, YearEntry, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need sixteen label controls, two picture boxes, six text boxes, five comboxes, one check box, two date time pickers, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, seven buttons for controlling editing features, one button for searching parent’s name, one button to open parent form, one button to upload student’s photo, and one button to upload student’s finger. In Tutorial 4, you will build a form for Teacher table. This table has fifteen fields: TeacherID, RegNumber, FirstName, LastName, BirthDate, Rank, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need an input form so that user can edit existing records, delete records, or add new records. The form will also have the capability of navigating from one record to another. You need sixteen label controls, one picture box, seven text boxes, five comboxes, one check box, one date time picker, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, six buttons for controlling editing features, one button for searching teacher’s name, and one button to upload teacher’s photo. In Tutorial 5, you will build a form for Subject table. This table has only three fields: SubjectID, Name, and Description. You need four label controls, four text boxes, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, secen buttons for utilities, and one button for searching subject name. Place these controls on the form. You will also build a form for Grade table. This table has seven fields: GradeID, Name, SubjectID, TeacherID, SchoolYear, TimaStart, and TimeFinish. You need to add seven label controls, one text box, four comboxes, and two date time pickers. You also need four buttons for navigation, seven buttons for controlling editing features, one button to open subject form, and one button to open teacher form. In Tutorial 6, you will build a form for Grade_Student table. This table has only three fields: Grade_StudentID, GradeID, and StudentID. You need an input form so that user can edit existing records, delete records, or add new records. The form will also have the capability of navigating from one record to another. You need two label controls and two comboxes. You also need four buttons for navigation, seven buttons for controlling editing features, one button to open grade form, and one button to open student form.
VISUAL C# .NET FOR PROGRAMMERS by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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 Microsoft Access and SQL Server. 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. If the small lock symbol is not displayed next to the ClientID row, then you need to place it there. Right click on ClientID row and select Primary Key. A small key is now displayed next to the entry indicating it is the primary key. You will define FamilyName as an index. Select the FamilyName line. On the General tab, set the Indexed property to Yes (Duplicates OK). 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. In chapter three, you will build a Visual C# interface for the database. 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 four, 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 five, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. You will do this in stages, from database development to creation of distribution packages. These steps are the same as those used in developing a commercial database application. 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 six, you will perform the steps necessary to build a SQL Server book inventory database that contains 4 tables using Microsoft Visual Studio 2019. 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.
VISUAL C# .NET FOR STUDENTS: A Project-Based Approach to Develop Desktop Applications by Vivian Siahaan Pdf
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 more familiar when applying them to some desktop applications in this book. In chapter two, you will build Throwing Fire program. This program can be played by two human players or human player versus computer. You will use 12 labels, a large control panel, and three control buttons on the form. In the control panel, a smaller panel with two group box controls and a button control are placed. In the first group box, you will use 2 radio buttons; in the second box group, place 4 radio buttons. Next, two timer controls are added to the project. All label controls are used for titles and provide scoring and game information. The large panel (Panel1) is the playing field. Three button controls are used to start / stop a program, set options, and exit the program. One timer control is used to control game animation and another is used to represent the computer's decision process. The second control panel (Panel2) is used to select game options. One group box contains radio buttons which are used to select number of players. A group box contains radio buttons to select the level of difficulty of the game, when playing against a computer. A small button is used to close the options panel. The default properties are set for one-player games with the easiest game difficulty. In chapter three, you will build Roasted Duck Delivery simulation. In this simulation, a number of decisions are needed. The basic idea is to read the order by incoming telephone and tell the delivery scooter to go to the location of the order. You also need to make sure that you always provide a roasted duck ready to be transported by the delivery scooter. The delivery area is a 20 by 20 square grid. The more roasted duck is sold, the more profit it gets. The panel control on the left side of the form contains the delivery grid. On the upper right are group boxes with two label controls to display the time or hour and sale results. The computer monitor (in a picture box) displays order and delivery status using a list box and label control. Another group box contains a roasting oven when the roasted ducks are displayed using eight picture box controls. Two button controls on the group box control the operation of the oven. Group boxes under the oven show how many ducks are ready to be delivered and how many are in the delivery scooter (a button control is to load the roasted duck into the scooter). The two button controls beneath are used to start/pause the game and to stop the game or exit the game. In the area under the form there are several timers for controlling a number of aspects in the program. The delivery grid consists of 400 label controls on 20 rows (marked with numbers) and 20 columns (marked with letters). Here, you will learn how to place controls on a form (or panel in this case) using code (when the program runs, not when designing the form). This mechanism can save time designing the form. In chapter four, you will build a Drone Simulation. In this simulation, you control both vertical and horizontal thrusters to maneuver the ride to the landing pad. You will adjust the landing speed so that it is slow enough so that no accident occurs. You build the form in two stages, the first stage creates two option group boxes, and then the second stage uses both those group boxes as landing controls. Two control panels are placed on the left side of the form: one panel for drawing and another panel for the edge. On the right side of the form, place the two group control boxes. In the first group box, five radio buttons and a check box are added. In the second group box, two radio buttons are placed. In the below section of the form, three buttons are added. Finally, one timer control is added. Then in the form, a group box is added overlap panel. Then, 11 label controls are added to the group box. After that, a progress bar is added. Under the bar, two control panels are added, one high panel and one short panel. In the second (short) panel control, two small label controls are added. Underneath, three button controls are placed. Under these three buttons, a label control is added. For each label control, set the AutoSize property to False to be resized and set (temporarily) the BorderStyle property to FixedSingle so that you can see the edges to facilitate the layout process. In this chapter, you will build Jumper game. In this game, you will move the jumper across the busy road, avoid the tiger, and cross the river with the changing current to get to house safely. You will place four label controls on the top part of the form (set the AutoSize property to False so that it can be resized and the BorderStyle property temporarily becomes FixedSingle so you can see the edges). Then, you use five panel controls below the labels. These panels will be a place for image graphics. Each panel has a width of 16 jumpers or 640 pixels, because one jumper will be given a width of 40 pixels. The first panel will be the jumper house, which will be given a height of 80 pixels. The next panel will become a river, with a height of 120 pixels. The next panel will be a place for tiger, 40 pixels high. Under the snake panel, there is a road panel. This panel will contain three boat lanes. Each boat has a height of 40 pixels, but you will give it a height of 140 pixels (not 120 pixels) to make room for lane markers. The fifth panel is the place where the jumper will begin its journey or leap. This panel will be given a height of 40 pixels. Add the last control panel below the form with three button controls. Then, finally, add four timer controls. Adjust the size of the form so that the panel controls can occupy according to the width of the form.
VISUAL C# .NET: A Step By Step, Project-Based Guide to Develop Desktop Applications by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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 build a project so that children can practice basic skills in addition, subtraction, multiplication, and division operations. This Math Game project can be used to choose the types of questions and what factors you want to use. This project has three timing options. Random math problems using values from 0 to 9 will be presented. Timing options are provided to measure accuracy and speed. There are many controls used. Two label controls are used for title information, two for displaying scores. There is a wide label in the middle of the form to display math questions. And, long skinny label is used as separator. Two button controls are used to start and stop question and one button to exit the project. There are three group control boxes. The first group box holds four check box controls that are used to select the type of questions. The second group box holds eleven radio buttons that are used to select values that are used as factors in calculations. The third group box contains three radio button controls for timing options. A scroll bar control rod is used to change the time. In chapter three, you will build Bank Code game. The storage box is locked and can only be opened if you enter the correct digit combination. Combinations can be 2 to 4 non-repetitive digits (range of digits from 1 to 9). After a guess is given, you will be notified of how many digits are right and how many digits are in the right position. Based on this information, you will give another guess. You continue to guess until you get the right combination or until you stop the game. On the left side of the form is a large picture box control. On the right side, two group box controls and two button controls are placed. In the picture box, a control panel is placed. In the panel, there are four label controls (set the AutoSize property to False) and nine button controls. In the first group box control, place three radio buttons. In the second group box control, a text box control is placed. The picture box contains an image of bank and a panel. The label controls in the panel are used to display the combinations entered (the BorderStyle property set to FixedSingle to display the label size). The nine buttons on the panel are used to enter combinations. Radio buttons are used to set options. The buttons (one to start and stop the game and another to exit the project) are used to control game operations. The text box displays the results of the combinations entered. In chapter four, you will build Horse Racing game. This is a simple game. Up to 10 horses will race to the finish line. You guessed two horses that you thought could win the race. By clicking on the Start button, the race will start. All horses will race speed to get to the finish line. Labels are used to display instructions and number of horses in a race. Four button controls are used: two buttons to change number of horses, one button to start the game, and one other button to stop the game. The picture box control is used to load the horse image. A timer control is used to update the horse's movement during the race. In chapter five, you will build Catching Ball game. The bird flew and dropped ball from the sky. Users are challenged to position man under the fallen ball to catch it. Labels are used for instructions and to display game information (remaining time, number of balls captured, and game difficulty level). Two buttons are used to change the game difficulty level, one button to start the game, and another button to stop the game. Picture box controls hold images for man, bird, and ball. In chapter six, you will build Smart Tic Tac Toe game. That said, this is the first game ever programmed on a computer and one that had been programmed by Bill Gates himself when he was a teenager while attending Lakeside School in Seattle. The aim of this game is to win the game on a 3 x 3 grid with the victory of three identical symbols (X or O) on horizontal, diagonal, or vertical lines. The players will play alternately. In this game given two game options: player 1 against player 2 or human player against computer. A smart but simple strategy will be developed for computer logic to be a formidable opponent for humans. In chapter seven, you will build Fighting Plane program. This program can be played by two human players or human player versus computer. The controls of the player are done via the keyboard. Player 1 presses A key to move up, Z key to move down, and S key to throw rudal. When you choose Two players from the Options button, this game can be played by two human players. Player 1 presses the same keys, while player 2 presses key K to move up, M to move down, and key J to throw rudal. All label controls are used for titles and provide scoring and game information. The large panel (Panel1) is the playing field. Three button controls are used to start / stop a program, set options, and exit the program. One timer control is used to control game animation and another is used to represent the computer's decision process. The second control panel (Panel2) is used to select game options. One group box contains radio buttons which are used to select number of players. A group box contains radio buttons to select the level of difficulty of the game, when playing against a computer. A small button is used to close the options panel. The default properties are set for one-player games with the easiest game difficulty.
Database Management System Using Visual C# .NET: MySQL, SQL Server, and Access by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
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 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. Book 2: Visual C# .NET For Programmers: A Progressive Tutorial to Develop Desktop Applications 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 Microsoft Access and SQL Server. 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. If the small lock symbol is not displayed next to the ClientID row, then you need to place it there. Right click on ClientID row and select Primary Key. A small key is now displayed next to the entry indicating it is the primary key. You will define FamilyName as an index. Select the FamilyName line. On the General tab, set the Indexed property to Yes (Duplicates OK). 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. In chapter three, you will build a Visual C# interface for the database. 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 four, 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 five, you will build an application that can be used to track daily high and low pollutant PM2.5 and air quality level. You will do this in stages, from database development to creation of distribution packages. These steps are the same as those used in developing a commercial database application. 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 six, you will perform the steps necessary to build a SQL Server book inventory database that contains 4 tables using Microsoft Visual Studio 2019. 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.
Mastering Visual C# .NET by Jason Price,Mike Gunderloy Pdf
Get Everything You Can Out of Visual C# and the .NET Framework Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient and your applications more powerful. You'll learn how to create stand-alone applications, as well as build Windows, web, and database applications. You'll even see how to develop web services—a technology that holds great promise for the future of distributed application. Coverage includes: Mastering the fundamentals and advanced aspects of the C# language Using Visual Studio .NET for increased coding productivity and debugging Creating distributed applications with remoting and web services Understanding object-oriented concepts Delivering data across the Internet with web services Using XML to communicate with other applications Accessing databases with ADO.NET Building Windows applications Creating web applications using ASP.NET Reading and writing data from/to files or the Internet Using advanced data structures to store and manipulate information Using multi-threading for greater application efficiency Using reflection to manipulate running code Building distributed applications with remoting and web services Securing code and authenticating users Using built-in encryption facilities Making your applications world-ready Parsing strings with regular expressions Using delegates to handle runtime events Programming defensively with exception handling
Two Books In One: LEARN FROM SCRATCH VISUAL BASIC .NET WITH MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
BOOK 1: VISUAL BASIC .NET AND DATABASE: PRACTICAL TUTORIALS This book aims to develop a MySQL-driven desktop application that readers can develop for their own purposes to implement library project using Visual Basic .NET. In Tutorial 1, you will build a Visual Basic interface for the database. This interface will used as the main terminal in accessing other forms. This tutorial will also discuss how to create login form and login table. You will create login form. Place on the form one picture box, two labels, one combo box, one text box, and two buttons. In Tutorial 2, you will build a school inventory project where you can store information about valuables in school. The table will have nine fields: Item (description of the item), Quantity, 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). In Tutorial 3, you will perform the steps necessary to add 5 new tables using phpMyAdmin into Academy database. You will build each table and add the associated fields as needed. Every table in the database will need input form. In this tutorial, you will build such a form for Author table. Although this table is quite simple (only four fields: AuthorID, Name, BirthDate, and PhotoFile), it provides a basis for illustrating the many steps in interface design. SQL statement is required by the Command object to read fields (sorted by Name). Then, you will build an interface so that the user can maintain the Publisher table in the database (Academy). The Publisher table interface is more or less the same as Author table interface. This Publisher table interface only requires more input fields. So you will use the interface for the Author table and modify it for the Publisher table. In Tutorial 4, you will perform the steps necessary to design and implement title form, library member form, and book borrowal form. You start by designing and testing the basic entry form for book titles. The Title table has nine fields: BookTitle, PublishYear, ISBN, PublisherID, AuthorID, Description, Note, Subject, and Comment. Then, you will build such a form for Member table. This table has twelve fields: MemberID, FirstName, LastName, BirthDate, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, and PhotoFile). You need thirteen label controls, one picture box, six text boxes, four comboxes, one check box, one date time picker, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, six buttons for controlling editing features, one button for searching member’s name, and one button to upload member’s photo. Finally, you will build such a form for Borrow table. This table has seven fields: BorrowID, MemberID, BorrowCode, ISBN, BorrowDate, ReturnDate, and Penalty. In this form, you need fourteen label controls, seven text boxes, two comboxes, two date time pickers, and one printpreviewdialog. You also need four buttons for navigation, seven buttons for other utilities, one button to generate borrowal code, and one button to return book. BOOK 2: LEARN FROM SCRATCH VISUAL BASIC .NET WITH MYSQL This book will teach you with step-by-step approach to develop from scratch a MySQL-driven desktop application that readers can develop for their own purposes to implement school database project using Visual Basic .NET. In Tutorial 1, you will perform the steps necessary to add 8 tables using phpMyAdmin into School database that you will create. You will build each table and add the associated fields as needed. In this tutorial, you will also build login form and main form. In Tutorial 2, you will build such a form for Parent table. This table has thirteen fields: ParentID, FirstName, LastName, BirthDate, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need fourteen label controls, two picture boxes, six text boxes, four comboxes, one check box, one date time picker, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, six buttons for other utilities, one button for searching member’s name, one button to upload parent’s photo, and button to upload parent’s finger. Place these controls on the form. In Tutorial 3, you will build such a form for Student table. This table has fifteen fields: StudentID, ParentID, FirstName, LastName, BirthDate, YearEntry, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need sixteen label controls, two picture boxes, six text boxes, five comboxes, one check box, two date time pickers, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, seven buttons for controlling editing features, one button for searching parent’s name, one button to open parent form, one button to upload student’s photo, and one button to upload student’s finger. In Tutorial 4, you will build a form for Teacher table. This table has fifteen fields: TeacherID, RegNumber, FirstName, LastName, BirthDate, Rank, Status, Ethnicity, Nationality, Mobile, Phone, Religion, Gender, PhotoFile, and FingerFile). You need an input form so that user can edit existing records, delete records, or add new records. The form will also have the capability of navigating from one record to another. You need sixteen label controls, one picture box, seven text boxes, five comboxes, one check box, one date time picker, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, six buttons for controlling editing features, one button for searching teacher’s name, and one button to upload teacher’s photo. In Tutorial 5, you will build a form for Subject table. This table has only three fields: SubjectID, Name, and Description. You need four label controls, four text boxes, one openfiledialog, and one printpreviewdialog. You also need four buttons for navigation, secen buttons for utilities, and one button for searching subject name. Place these controls on the form. You will also build a form for Grade table. This table has seven fields: GradeID, Name, SubjectID, TeacherID, SchoolYear, TimaStart, and TimeFinish. You need to add seven label controls, one text box, four comboxes, and two date time pickers. You also need four buttons for navigation, seven buttons for controlling editing features, one button to open subject form, and one button to open teacher form. In Tutorial 6, you will build a form for Grade_Student table. This table has only three fields: Grade_StudentID, GradeID, and StudentID. You need an input form so that user can edit existing records, delete records, or add new records. The form will also have the capability of navigating from one record to another. You need two label controls and two comboxes. You also need four buttons for navigation, seven buttons for controlling editing features, one button to open grade form, and one button to open student form.
VISUAL BASIC .NET FOR STUDENTS by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
In chapter one, you will get to know the properties and events of each control in a Windows Visual Basic application. You need to learn and know in order to be more familiar when applying them to some desktop applications in this book. In Tutorial 1.1, you will build a dual-mode stopwatch. The stopwatch can be started and stopped whenever desired. Two time traces: the running time when the stopwatch is active (running time) and the total time since the first stopwatch was activated. Two label controls are used to display the time (two more labels to display title information). Two button controls are used to start/stop and reset the application, one more button to exit the application. The timer control is used to periodically (every second) update the displayed time. In Tutorial 1.2, you will build a project so that children can practice basic skills in addition, subtraction, multiplication, and division operations. This Math Game project can be used to choose the types of questions and what factor you want to use. This project has three timing options. In Tutorial 1.3, you will build Bank Code game. The storage box is locked and can only be opened if you enter the correct digit combination. Combinations can be 2 to 4 non-repetitive digits (range of digits from 1 to 9). After a guess is given, you will be notified of how many digits are right and how many digits are in the right position. Based on this information, you will give another guess. You continue to guess until you get the right combination or until you stop the game. In Tutorial 1.4, you will build Horse Racing game. This is a simple game. Up to 10 horses will race to the finish line. You guessed two horses that you thought could win the race. By clicking on the Start button, the race will start. All horses will race speed to get to the finish line. In chapter two, you will learn the basic concepts of classes and objects. Next, it will demonstrate how to define class and type of enumeration, which shows how both are used in the application. In Tutorial 2.1, you will create a two-level application that uses a form to pass input user to the People class. The form class is the level of representation and the People class is the middle level. You will add controls to the form so people can enter ID, last name, and their height. When the user clicks the Save button, the code will assign input values to the People class properties. Finally, you will display the People object on a label. Figure below shows the form after the user clicks the Save button. In Tutorial 2.2, you will add a parameterized constructor to the People class. The application will ask the user to enter values, which will then be passed to the People constructor. Then, the application will display the values stored on the People object. In Tutorial 2.3, you will create an application that utilizes enumeration type. The user will choose one type of account that is listed in a ListBox control and what he chooses is then displayed in a Label control. In Tutorial 2.4, you will create a simple Bank application. This application has one class, BankAcc, and a startup form. In Tutorial 2.5, you will improve the simple Bank application, by implementing the following two properties in the BankAcc class: TotalDeposit- Total money saved in current account; TotalWithdraw- Total funds that have been withdrawn from current account. In Tutorial 2.6, you will create an application to calculate the time needed for a particular aircraft to reach takeoff speed. You will also calculate how long the runway will be required. For each type of aircraft, you are given (1) the name of the aircraft, (2) the required take-off speed (feet/sec), and (3) how fast the plane accelerates (feet/sec2). In Tutorial 2.7, you will provide a number of programming training for those who want to improve their programming skills. Your task here is to write an object-oriented application so that training manager can display and edit the training services offered. There are several training categories: (1) Application Development, (2) Database, (3) Networking, and (4) System Administration. The training itself consists of: (1) title, (2) training days, (3) category, and (4) cost. Create a class named Training that contains this information, along with its properties and a ToString() method. In chapter three, several tutorials will be presented to build more complex projects. You will build them gradually and step by step. In Tutorial 3.1, you will build Catching Ball game. The bird flew and dropped ball from the sky. User is challenged to position man under the fallen ball to catch it. In Tutorial 3.2, you will build Smart Tic Tac Toe game. The aim of this game is to win the game on a 3 x 3 grid with the victory of three identical symbols (X or O) on horizontal, diagonal, or vertical lines. The players will play alternately. In this game given two game options: player 1 against player 2 or human player against computer. A smart but simple strategy will be developed for computer logic to be a formidable opponent for human. In Tutorial 3.3, you will build a Matching Images game. Ten pairs of images hidden on the game board. The object of the game is to find image pairs. In Two Players mode, players will get turns in turn. In One Player mode, there are two options to choose from: Playing Alone or Against Computer. When Play Alone option is selected, the player will play alone without an opponent. If Against Computer option is selected, then the level of computer intelligence is given with several levels according to the level of difficulty of the game. In Tutorial 3.4, you will build Throwing Fire program. This program can be played by two human players or human player versus computer. In chapter four, tutorials will be presented to build two advanced projects. You will build them gradually and step by step. In Tutorial 4.1, you will build Roasted Duck Delivery simulation. In this simulation, a number of decisions are needed. The basic idea is to read the order by incoming telephone and tell the delivery scooter to go to the location of the order. You also need to make sure that you always provide a roasted duck ready to be transported by the delivery scooter. The delivery area is a 20 by 20 square grid. The more roasted duck is sold, the more profit it gets. In Tutorial 4.2, you will build a Drone Simulation. In this simulation, you control both vertical and horizontal thrusters to maneuver the ride to the landing pad. You will adjust the landing speed so that it is slow enough so that no accident occurs.
BUILDING THREE DESKTOP APPLICATIONS USING JAVA GUI AND MYSQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
In this book, you will learn how to build from scratch a MySQL database management system using Java. In designing a GUI and as an IDE, you will make use of the NetBeans tool. Gradually and step by step, you will be taught how to use MySQL in Java. In the first chapter, you will learn: How to install NetBeans, JDK 11, and MySQL Connector/J; How to integrate external libraries into projects; How the basic MySQL commands are used; How to query statements to create databases, create tables, fill tables, and manipulate table contents is done. In the second chapter, you will study: Creating the initial three table projects in the school database: Teacher table, TClass table, and Subject table; Creating database configuration files; Creating a Java GUI for viewing and navigating the contents of each table; Creating a Java GUI for inserting and editing tables; and Creating a Java GUI to join and query the three tables. In the third chapter, you will learn: Creating the main form to connect all forms; Creating a project will add three more tables to the school database: the Student table, the Parent table, and Tuition table; Creating a Java GUI to view and navigate the contents of each table; Creating a Java GUI for editing, inserting, and deleting records in each table; Creating a Java GUI to join and query the three tables and all six. In chapter four, you will study how to query the six tables. In chapter five, you will learn the basics of cryptography using Java. Here, you will learn how to write a Java program to count Hash, MAC (Message Authentication Code), store keys in a KeyStore, generate PrivateKey and PublicKey, encrypt / decrypt data, and generate and verify digital prints. In chapter six, you will learn how to create and store salt passwords and verify them. You will create a Login table. In this case, you will see how to create a Java GUI using NetBeans to implement it. In addition to the Login table, in this chapter you will also create a Client table. In the case of the Client table, you will learn how to generate and save public and private keys into a database. You will also learn how to encrypt / decrypt data and save the results into a database. In chapter seven, you will create an Login table. This account table has the following ten fields: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In this case, you will learn how to implement generating and verifying digital prints and storing the results into a database. In chapter eight, you create a table with the name of the Account, which has ten columns: account_id (primary key), client_id (primarykey), account_number, account_date, account_type, plain_balance, cipher_balance, decipher_balance, digital_signature, and signature_verification. In chapter nine, you will create a Client_Data table, which has the following seven fields: client_data_id (primary key), account_id (primary_key), birth_date, address, mother_name, telephone, and photo_path. In chapter ten, you will be taught how to extract image features, utilizing BufferedImage class, in Java GUI. In chapter eleven, you will be taught how to create Crime database and its tables. In chapter twelve, you will be taught to create Java GUI to view, edit, insert, and delete Suspect table data. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. In chapter thirteen, you will be taught to create Java GUI to view, edit, insert, and delete Feature_Extraction table data. This table has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. All six fields (except keys) will have a BLOB data type, so that the image of the feature will be directly saved into this table. In chapter fourteen, you will add two tables: Police_Station and Investigator. These two tables will later be joined to Suspect table through another table, File_Case, which will be built in the seventh chapter. The Police_Station has six columns: police_station_id (primary key), location, city, province, telephone, and photo. The Investigator has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. Here, you will design a Java GUI to display, edit, fill, and delete data in both tables. In chapter fifteen, you will add two tables: Victim and File_Case. The File_Case table will connect four other tables: Suspect, Police_Station, Investigator and Victim. The Victim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The File_Case has seven columns: file_case_id (primary key), suspect_id (foreign key), police_station_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. Here, you will also design a Java GUI to display, edit, fill, and delete data in both tables.
Building Two Desktop Applications Using Python GUI and MySQL by Vivian Siahaan,Rismon Hasiholan Sianipar Pdf
In this book, you will create two desktop applications using Python GUI and MySQL. In this book, you will learn how to build from scratch a MySQL database management system using PyQt. In designing a GUI, you will make use of the Qt Designer tool. Gradually and step by step, you will be taught how to use MySQL in Python. In the first three chapters, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators. Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters. In the fourth chapter, you will learn: How PyQt and Qt Designer are used to create Python GUIs; How to create a basic Python GUI that utilizes a Line Edit and a Push Button. In the fifth chapter, you will study: Creating the initial three table in the School database project: Teacher table, Class table, and Subject table; Creating database configuration files; Creating a Python GUI for viewing and navigating the contents of each table. Creating a Python GUI for inserting and editing tables; and Creating a Python GUI to merge and query the three tables. In chapter six, you will learn: Creating the main form to connect all forms; Creating a project that will add three more tables to the school database: the Student table, the Parent table, and the Tuition table; Creating a Python GUI to view and navigate the contents of each table; Creating a Python GUI for editing, inserting, and deleting records in each table; Create a Python GUI to merge and query the three tables and all six tables. In chapter seven, you will create new database dan configure it. In this chapter, you will create Suspect table in crime database. This table has eleven columns: suspect_id (primary key), suspect_name, birth_date, case_date, report_date, suspect_ status, arrest_date, mother_name, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for this table. In chapter eight, you will create a table with the name Feature_Extraction, which has eight columns: feature_id (primary key), suspect_id (foreign key), feature1, feature2, feature3, feature4, feature5, and feature6. The six fields (except keys) will have a VARCHAR data type (200). You will also create GUI to display, edit, insert, and delete for this table. In chapter nine, you will create two tables, Police and Investigator. The Police table has six columns: police_id (primary key), province, city, address, telephone, and photo. The Investigator table has eight columns: investigator_id (primary key), investigator_name, rank, birth_date, gender, address, telephone, and photo. You will also create GUI to display, edit, insert, and delete for both tables. In chapter ten, you will create two tables, Victim and Case_File. The Vicbtim table has nine columns: victim_id (primary key), victim_name, crime_type, birth_date, crime_date, gender, address, telephone, and photo. The Case_File table has seven columns: case_file_id (primary key), suspect_id (foreign key), police_id (foreign key), investigator_id (foreign key), victim_id (foreign key), status, and description. You will create GUI to display, edit, insert, and delete for both tables as well.
