VB.Net: connect to remote webservice and display results in csv fm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on VB.Net application. I have a GUI where the user logs on and
gets SessionId. Once, the connection is successful, the user is redirected to
another screen where he choses which table and the starttime and end time to
select the data from the database on the remote server. I create a reference
to the remote web service. How do I query this database based on the
selections and display the results in .csv format either in the browser in
new window or in the text files.
 
The function in the webService(Reference.vb) for querying the Positions table
is as follows:

Public Function ExportPositions(ByVal SessionID As String, ByVal
StartDateTime As Date, ByVal EndDateTime As Date,
<System.Xml.Serialization.XmlArrayItemAttribute("AssetID",
IsNullable:=false)> ByVal AssetList() As Long) As Position()
Dim results() As Object = Me.Invoke("ExportPositions", New
Object() {SessionID, StartDateTime, EndDateTime, AssetList})
Return CType(results(0),Position())
End Function


This fn returns the array.
 
Back
Top