Skip to Content
avatar image
Former Member code to create XMLI

I am trying to create a web service in visual studio that xcelsius can connect to. I have built the web service using visual studio and the following method:

<WebMethod()> _

Public Function GetDataFromDB() As XmlDocument

Dim errorMessage As String = ""

Dim myDatas As XmlDocument = New XmlDocument()

Dim connectionString As String = ConfigurationManager.ConnectionStrings("LocalCon").ConnectionString

Dim dbConnection As SqlConnection = Nothing


dbConnection = New SqlConnection(connectionString)


Catch ex As Exception

errorMessage = ex.Message

End Try

If errorMessage = "" Then

Dim SQL As String = "select * From DepotMTD"

Dim GetCustomerCmd As SqlCommand = New SqlCommand(SQL, dbConnection)


Dim custDA As SqlDataAdapter = New SqlDataAdapter()

custDA.SelectCommand = GetCustomerCmd

Dim custDS As Data.DataSet = New Data.DataSet("Dataset")

custDA.Fill(custDS, "Data")



Catch ex As System.Exception

errorMessage = ex.Message



End Try

End If

Return myDatas

End Function

This produces the following xml:

<?xml version="1.0" encoding="utf-8" ?>

- <Dataset>

- <Data>

<Depot>North West</Depot>



- <Data>

<Depot>North East</Depot>



- <Data>




- <Data>

<Depot>South East</Depot>



- <Data>

<Depot>South West</Depot>



- <Data>





Xcelsius cannot read this what do I need to do to my code to correct this?

Any help appreciated.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Oct 06, 2008 at 04:32 PM

    Please post this query to the Xcelsius forum:

    SAP BusinessObjects Dashboards

    That forum is monitored by qualified technicians and you will get a faster response there.

    Thank you for your understanding,


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2008 at 09:25 AM

    I have sorted this issue out

    Add comment
    10|10000 characters needed characters exceeded