MySQL .NET and Labview 2017 64bit
Posted by: Nicholas Holland
Date: September 18, 2018 02:54AM

Good Morning all,

Can anyone help me with the implementation of the .NET connector in National Instruments Labview.

I`m trying to set up a simple VI to which I can pass an SQL statement and, depending on that statement, return a string array of data.

So far i`ve not had any luck using the .NET connector for this. Below is the sequence from my attempt so far; (dataSet is created using System.Data.DataSet(String dataSetName)

Constructor - MySQLConnection,
Property Node - MySQLConnection(ConnectionString),
Property Node - MySQLConnection(OpenAsync),
Property Node - SqlDataAdaptor(SelectCommandText,SelectConnectionString),
Property Node - SqlDataAdaptor(Fill,dataSet)

I`m not sure what I should do next to read the data? Should I use MySQLCommand.ExecuteReader ? I`m guessing I would also need to use .NetObject to Variant and then Variant to Data?

Any help would be greatly received,

Nick

Options: ReplyQuote


Subject
Written By
Posted
MySQL .NET and Labview 2017 64bit
September 18, 2018 02:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.