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 »
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
Visual Studio : Handshaking Read More »
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
Visual Studio : SQL Connection String 1 Read More »
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
Concept of Programming Read More »
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
Speculative Purchasing – Concept (1) Read More »
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
Concept of Material Handling Read More »
