
After watching this video, students should be able to answer the following questions:
1.(a) The number of parts a Software has and be able to name those parts.
2). To name at least four database examples.
(3). To name 3 User Interface types
(4). To name data type examples
(5). To give example of each data type
After completion, students will be able to do the following:
Create a database in Microsoft SQL Server
Create tables
Create fields with the respective data types
After successfully designing a database, the way to build the UI(User Interface) is basically transferring the fields to where the user can see and in a language they(users) understand.
In this video, we are exploring the User controls for different data types that we designed in lecture 2.
In this video, we are going to align and format controls . The controls we are talking about include Labels, TextBoxes, DatePickers and CheckBoxes. Such controls is what form User Interface (UI) and hence should be beautifully placed on the forms.
Students will be able to have the Forms/Interface from C# "talk" to the database. It teaches how to use a connection string and related objects
Students will be able to send data from the interface into a table that has been created in Microsoft SQL Server
After successfully saving information into the database, it is time to read and display using a list view.
Once the items are listed on to a List View Control, you may want to highlight and select one item for editing or for viewing more details. In this video, I am breaking down in a very easy way how that is achieved.
On double-clicking an item from the list view, you will want to display the details. This video shows you exactly how to do that.
This video shows how to edit values of a selected item and update in the database.
This is a course like no other. This course takes you from zero to hero in 14 simple steps
I have broken down the basics of Software development , designed a simple database and build an application from scratch to the end. In this course , we are doing the following:
A discussion of what content you may want to store in a database of Covid-19 patients.
Create a database
Create a table
Create fields to hold different attributes of a patient e.g. Name, Date of Birth etc.
Create a form. This is the user interface where records can be captured. In this section, you will learn how to relate a database and the interface
Finally, we are handling the famous CRUD acronym
- Create
- Retrieve
- Update
- Delete
Create - This is inserting records into the database. A user captures information into a form and clicks on the save button. The INSERT commands sends that information to the database.
Retrieve - Once the data is stored. You will want to display it somewhere. SELECT command is responsible for the same.
Update - Sometimes, the data that is in the database needs to be changed or updated. UPDATE statement is used for that purpose.
Delete - The unwanted records have to be removed. DELETE command in this case is used.