C# LabVIEW 64bit SQL Database Toolkit

Example of my C# code for db connectivity, because LV 64bits don’t support DB toolkit I had to write .NET dll. DLL was developed in C# and it uses .net 4.0. It has Connect,Query,UpdateInsertDelete,Close functions. Query will read data to string array, update,insert,delete will output number of affected rows, close connection will just close it.

Here is example of usage:

LabView SQL DB






What is second most important ingredient for perfect manufacturing testing PIE? Yes it’s good tool for analysis of first ingredient (data from production floor). I have spent some time writing tools to check cpk/box plot, now its time to merge it into one. On screen shoot below you can see that we have Test/Step Name and time frame passed from caller. VI is reading data for specified measurement and then analysis is done to calculate CPK, trend and BOX Plot where we can see how each of machines are measuring our test. This last tool can help us determine which machine has to be repaired or adjusted. Analysis is done in few seconds, this way we are saving lots of time, and we can predict machine breakdown.