{"id":359,"date":"2018-02-07T14:23:56","date_gmt":"2018-02-07T12:23:56","guid":{"rendered":"http:\/\/www.krzysztofszewczyk.net\/?p=359"},"modified":"2018-02-07T14:23:56","modified_gmt":"2018-02-07T12:23:56","slug":"c-labview-64bit-sql-database-toolkit","status":"publish","type":"post","link":"https:\/\/kszewczy.webd.pl\/index.php\/2018\/02\/07\/c-labview-64bit-sql-database-toolkit\/","title":{"rendered":"C# LabVIEW 64bit SQL Database Toolkit"},"content":{"rendered":"<p>Example of my C# code for db connectivity, because LV 64bits don&#8217;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.<\/p>\n<p>Here is example of usage:<\/p>\n<p><a style=\"font-weight: bold; background-color: transparent;\" href=\"http:\/\/kszewczy.webd.pl\/wp-content\/uploads\/2018\/02\/labviewdatabase64bit-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-361\" src=\"http:\/\/kszewczy.webd.pl\/wp-content\/uploads\/2018\/02\/labviewdatabase64bit-1-300x96.png\" alt=\"\" width=\"300\" height=\"96\" srcset=\"https:\/\/kszewczy.webd.pl\/wp-content\/uploads\/2018\/02\/labviewdatabase64bit-1-300x96.png 300w, https:\/\/kszewczy.webd.pl\/wp-content\/uploads\/2018\/02\/labviewdatabase64bit-1-768x247.png 768w, https:\/\/kszewczy.webd.pl\/wp-content\/uploads\/2018\/02\/labviewdatabase64bit-1.png 906w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>LabView SQL DB<\/p>\n<p>DLL:<\/p>\n<p><a href=\"http:\/\/www.krzysztofszewczyk.net\/DB_DLL\/\">http:\/\/www.krzysztofszewczyk.net\/DB_DLL\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Example of my C# code for db connectivity, because LV 64bits don&#8217;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. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[4,7,17,18,21,33,54],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-news","tag-64bit","tag-c","tag-database","tag-db","tag-dll","tag-labview","tag-sql"],"_links":{"self":[{"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/comments?post=359"}],"version-history":[{"count":0,"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/posts\/359\/revisions"}],"wp:attachment":[{"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/media?parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/categories?post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kszewczy.webd.pl\/index.php\/wp-json\/wp\/v2\/tags?post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}