Applying programming and a database to a material intensive and quick turn-around production environment.
Synopsis: An example of the handshaking between the code and the design along with form properties. The program used in this example has a multitude of errors. Can you find any? Some errors are listed at the bottom of the page. One hand of the handshake is the Design Form. The design form is the
Programming : The Form Read More »
Synopsis: If Visual Studio is already installed, skip this post. This is not insisting that MS Visual Studio be used. Any programming platform is suitable. All discussions on this website may revolve around Visual Basic which I have been using since 2007. Keep in mind, Visual Basic is used as the demonstration platform, but the
Download Microsoft Visual Studio Read More »
The RadioButton is a useful tool for distinct options which should not be selected together. Options that are selected together should be dealt with by using the CheckBox. Contrary to the visual behavior of the checkboxes and the radiobuttons, the programming utilizing the tools is totally programmer dependent whether in the AND or the OR
Visual Studio : The RadioButton Read More »
Find the SQL Server Management Studio (SSMS) icon and click to open. Detail 1: Find the SQL Server Management Studio icon and click to open. Clicking the icon will open a connection window. Detail 2: Clicking the icon will open a connection window (A). With the SSMS Connection window, if there are no databases attached,
Open the SQL Server Management Studio Read More »
Example 1b – Collecting the Unprocessed Requisitions Previously, the command ExecuteReader was used to collect a list of current projects because there was more than one record, along with more than one column. The same command will be used to collect a list of Requisitions by using the PK collected with the project numbers Referencing
SQL Command Executions : Example 1b Read More »
To date, the three most common execution commands used are ExecuteReader, ExecuteScalar, and ExecuteNonQuery. ExecuteReader can be used to retrieve a considerable quantity of data from the database. As its name implies, it is used to read the database by rows. Though ExecuteReader can return a single value, ExecuteReader may not be the best choice
SQL Command Executions : Intro Read More »
To date, the three most common execution commands I have used are ExecuteReader, ExecuteScalar, and ExecuteNonQuery. Reference the following detail for examples on using the three common SQL execution commands. As an example, the following will address the database tables handling information with the ExecuteReader method. The SQL Management Studio shows A: Table List, B:
SQL Command Executions : Example 1a Read More »
Incorporating a database in industrial programming allows for data retention and access. If the database is placed on the corporation server, back-up can be established by the IT department. Some of these examples will be on a local machine, such as a desktop or a laptop. Ensure the development machine has the following software installed.
SQL Server Database Startup Read More »
An understanding of the database tables will be developed herein. The following detail is a series of linked tables via Primary Keys referenced in stepped tables. Notice in Detail 1 below, the table in the top left is the beginning of the series of linked tables. Note the Primary Key is signified by the key
SQL – The Database Tables Read More »
Synopsis: An example of the usefulness of the function in programming. There are many sources and videos on the internet discussing the function. The function should be a single purpose program action. If the intent is to return more than one result, consider using a class. One aspect of a function is reuse of a
Visual Studio : The Function Read More »
