MySQL .NET and Labview 2017 64bit

[Nicholas Holland]

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