This application was developed to help our quality department to prepare reports for customers. It is simple application where they need to paste serial number of products and select product version, after pressing read data application will look into DB for reports and extract measurements to table. Then user can copy it to excel sheet. Application was written in C# to allow user without LabVIEW run-time engine access measurement data.
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