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: …
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. …
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 …
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 …
Synopsis: Understanding how the Visual Studio Code View and Designer View function together. Visual Studio operates in a hand shaking technique. There are two layers commonly used with each form: The Designer View and the Code View. Programming with Visual Studio requires a basic understanding on how the data is processed between the two. The …
Synopsis: How to drive the connection string for database applications. Perquisite: Download Microsoft SQL Server, Free Edition and Microsoft SQL Server Management Studio Starting a program which utilizes a database, a connection string is required. The connection string can be derived from the Visual Studio programming software. Detail 1: The first requirement is the database …
Synopsis: A discussion of migrating a document formatted businesses to an integrated program and database flow. As a suggested prerequisite, before reading the Programming series, review the post under menu title Material Handling, Concept of Material Handling. The intent of the blog is not to discuss programming specifics, like tools, function, subroutines, or code, but …
Speculative Purchasing in this context is considering the organization does not want to keep an inventory (tax issue & storage space) and does not want to overburden projects costs. In a custom panel-building environment, where Programable Logic Controllers (PLC) are utilized, an organization will eventually evolve to where many of the components have a general …
I have been developing a software package for managing project-based material. The software includes importing an existing Excel spreadsheet bill of material (BOM) into either a BOM worksheet (custom software) or into a requisitions’ worksheet (custom software). The difference between a BOM and a requisition worksheet is the supplier is not defined and the cost …
