StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC# .net Web Service Web Method Returning < and > in View Source
primarykey
Id
5371175
data
AcceptedAnswerId
5371205
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-03-20T20:09:48.913
FavoriteCount
0
LastActivityDate
2012-11-13T20:30:46.157
LastEditDate
LastEditorUserId
0
OwnerUserId
668515
ParentId
0
PostTypeId
1
Score
1
ViewCount
5841
LastEditorDisplayName
text
Body
I have a stored procedure returning a datatable with a stored procedure in a Web Service Web Method. I'm trying to then convert the datatable to XML, however, when I view source of the returned XML (Which looks fine in the browser window) instead of <> it's returning <code>&lt;</code> and <code>&gt;</code> around the XML nodes. I've looked at the similar questions and I have tried using HTMLEncode or HTMLDecode to no avail. Here is my Web Service Code. <pre><code>using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Text; using System.Web; using System.Web.Services; using System.Xml; namespace DAL { [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] public class iPhoneWebServices : System.Web.Services.WebService { [WebMethod(Description="Return All Current Makes")] public string ReturnMakes() { // Get All Records with NAME Parameter DataTable dataTable = DataAccessLayer.ExecuteDataTable("ipa_ReturnMakes"); StringBuilder sbrXML = new StringBuilder(); if (dataTable.Rows.Count > 0) { sbrXML.AppendLine("<MakeList>"); foreach (DataRow objRow in dataTable.Rows) { sbrXML.AppendLine("<Make><MakeID>[makeID]</MakeID><MakeName>[makeName]</MakeName></Make>"); sbrXML.Replace("[makeID]", objRow["MakeID"].ToString()); sbrXML.Replace("[makeName]", objRow["MakeName"].ToString()); } sbrXML.AppendLine("</MakeList>"); } else { // no data sbrXML.AppendLine("<makeList>"); sbrXML.AppendLine("no data"); sbrXML.AppendLine("</makeList>"); } return sbrXML.ToString(); } //Return Models From Make ID [WebMethod(Description="Returns Models From Make ID")] public string ReturnModels(int MakeID) { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("MakeID", SqlDbType.Int); param[0].Value = MakeID; // Get All Records with NAME Parameter DataTable dataTable = DataAccessLayer.ExecuteDataTable("ipa_ReturnModelsForMake", param); StringBuilder sbrXML = new StringBuilder(); if (dataTable.Rows.Count > 0) { sbrXML.AppendLine("<ModelList>"); foreach (DataRow objRow in dataTable.Rows) { sbrXML.AppendLine("<Model><ModelID>[modelID]</ModelID><ModelName>[modelName]</ModelName></Model>"); sbrXML.Replace("[modelID]", objRow["ModelID"].ToString()); sbrXML.Replace("[modelName]", objRow["ModelName"].ToString()); } sbrXML.AppendLine("</ModelList>"); } else { // no data sbrXML.AppendLine("<ModelList>"); sbrXML.AppendLine("no data"); sbrXML.AppendLine("</ModelList>"); } return sbrXML.ToString(); } } </code></pre> } What it's returning in the view source for Web Method "ReturnModels" <pre><code> <?xml version="1.0" encoding="utf-8"?> <string xmlns="http://tempuri.org/">&lt;ModelList&gt; &lt;Model&gt;&lt;ModelID&gt;20945&lt;/ModelID&gt;&lt;ModelName&gt;Anglia&lt;/ModelName&gt;&lt;/Model&gt; &lt;Model&gt;&lt;ModelID&gt;11006&lt;/ModelID&gt;&lt;ModelName&gt;Transit&lt;/ModelName&gt;&lt;/Model&gt; &lt;Model&gt;&lt;ModelID&gt;21952&lt;/ModelID&gt;&lt;ModelName&gt;Zodiac Mark III&lt;/ModelName&gt;&lt;/Model&gt; &lt;/ModelList&gt; </string> </code></pre> It is showing properly in the browser window: <pre><code><string> <ModelList> <Model><ModelID>20945</ModelID><ModelName>Anglia</ModelName></Model> <Model><ModelID>15881</ModelID><ModelName>C-Max</ModelName></Model> <Model><ModelID>20303</ModelID><ModelName>Capri</ModelName></Model> <Model><ModelID>11006</ModelID><ModelName>Transit</ModelName></Model> <Model><ModelID>21952</ModelID><ModelName>Zodiac Mark III</ModelName></Model> </ModelList> </string> </code></pre> Just need to get what's showing in the browser window into the view source as well. Thank you for your help and time in advance!
Tags
<c#><.net><xml><service>
Title
C# .net Web Service Web Method Returning < and > in View Source
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTravelingAdMan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POC# .net Web Service Web Method Returning < and > in View Source
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COIf you want to output XML then you should really be creating XML, not just writing it yourself.
 singulars
 PostPostId
 POC# .net Web Service Web Method Returning < and > in View Source
 UserUserId
 USPrisoner
2. CO@Prisoner You are totally right. Replace is not the way to make XML documents. Either Xelement, ToArray, ToList should be used or heaven forbid String.Format.
 singulars
 PostPostId
 POC# .net Web Service Web Method Returning < and > in View Source
 UserUserId
 USJeremy

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.