i want to put my database layer in the web service. This works fine BUT there is a problem when i am access these methods
GetSPData(Byval arg As SqlComman, argCmdText as string, ByVal argSqlConnection as SqlConnection) As DataTable
I want to acces the aforesaid method in my Desktop application and i have to send SqlCommand as parament. When i try to acces this (GetSPData) method the follow exception occured
"There was an error generating the XML document."
Now the problem is to converting DataTable in xmlDocument Or xml node (i dont know about it very much).
Can anyone tell me How to send SqlCommand as parament ??
How to convert DataTable into XmlDocument?? When i try to test this method the following Error occurs
" test form is only available for methods with primitive types as parameters. "
The following are my Web Service Method code in which i try to Get Data Using Stored Procedure and then convert DataTable into XmlDocument and return.
Dim XmlDoc As New XmlDocument
Dim ds As New DataSet
Dim oDBLibrary As New DataBaseLibrary.DatabaseClass
Dim dt As DataTable = oDBLibrary.GetSPData(objCommand1, cmdText, msqlConnection)
Dim sw As New StringWriter
Dim tableXml As String = sw.ToString
Now can anyone tell me what is wrong with that c
View Complete Post