[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

the getxml method used to get the xml d

I am new to generating XML using vb.net. I have a SQL database and have a stored procedure which pulls out approximately 700 rows and has 5 columns.  I use a SQl dataadapter and then fill the data in the dataset
exampl

Dim 1dataset as DataDs = New DataDS

DataSession.Fill(1dataset , New SqlDataAdapter()  {MyData})
I use
dim strXML as string
strXML =MyData.GetXML()
Now my strXML has my data in  a xml from. But when I  pass this to my service and see the data in view source all the <> brackets become   &lt; &gt; passed remain in XML format.



How do iget the data set in an XML format



Regards without creating a file locally. Any help would be appreciated.

Regards

YRKS
0
ChanderMadhaviGmail
Asked:
ChanderMadhaviGmail
1 Solution
 
Bob LearnedCommented:
You can use the System.Web.HttpUtility.HtmlDecode method to convert the encoded text back to XML.

HttpUtility.HtmlDecode Method (String)
http://msdn.microsoft.com/en-us/library/7c5fyk1k(v=vs.110).aspx

Imports System
Imports System.Web
Imports System.IO

Class MyNewClass
   Public Shared Sub Main()
      Dim myString As String
      Console.WriteLine("Enter a string having '&' or '""'  in it: ")
      myString = Console.ReadLine()
      Dim myEncodedString As String 
      ' Encode the string.
      myEncodedString = HttpUtility.HtmlEncode(myString)
      Console.WriteLine("HTML Encoded string is " + myEncodedString)
      Dim myWriter As New StringWriter()
      ' Decode the encoded string.
      HttpUtility.HtmlDecode(myEncodedString, myWriter)
      Console.Write("Decoded string of the above encoded string is " + myWriter.ToString())
   End Sub 'Main
End Class 'MyNewClass

Open in new window

0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now