Accessing .NET dataset returned from a web service

[BERJOA]

I have used the Labview import web service tool and accessing a service, which is returning a dataset table with the format System.Data.Datatable. The VI in the block diagram is returning an .NET class object reference, but it doesn´t associate the expected methods and properties for a Datatable class. The only available methods are Equals(Object obj), GetHashCode(), GetType() and ToString(). The only properties is Any, Any1, namespace and tableTypeName.

Is it possible for LabView to handle dataset objects? 

[Ynyr]

Hi,

I am also looking for a solution to a similar problem.

Rather than directly writing SQL commands to/from the database as suggested using LabSQL http://www.jeffreytravis.com/lost/labsql.html or LabView connectivity toolkit http://sine.ni.com/nips/cds/view/p/lang/en/nid/6429   I want to be able to call a webservice or a .dll (created using Visual Studio .NET) from LabView. 

The webservice or dll will have a method such as insertTestResult that will take a number of inputs passed to it from Labview, create a SQL command object and perform the INSERT command into the underlying database.  From what I have read this is perfectly doable, as it is straightforward to reference webservices or dll's from LabView. 

What I'm slightly unsure about is the ability of Labview to retrieve data back from the database via the webservice or dll.  A method such as getTestResult would return a DataSet object.  Can this object be used within LabView? E.g. binding it to a control such as a table, or reading through the dataset rows like a cursor? (Read Only Forward only) and getting the data out into an array?

I would appreciate any feedback.

Regards,

Ynyr

[Dennis_Knutson]

This question does not belong in the Multifunction DAQ board. You should post to the LabVIEW board.