Solved

the getxml method used to get the xml d

Posted on 2014-07-25
1
325 Views
Last Modified: 2014-07-28
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
Comment
Question by:ChanderMadhaviGmail
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 40221347
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question