XML / XSL

Re: How to dispaly attributes of xml nested repeater..(if XML not followed hierarchical structure)

15-Nov-07 0:36

Hello every one I am facing a problem to display attribute of parent node and corresponding child

nodes.Suppose I have to display Label attributes of all <ScreenToSupport>. There can be multiple

<ScreenToSupport> inside parent node <ScreensToSupport>.
In this case I have to display Label 'rediffHomePage' and 'rediffHomePage1' of both

<ScreenToSupport> node. There is no issue to diplay these two Label. I done this by taking a

repeater control.
But problem arrises when I have to display corresponding Label of 'FieldsToSupport/FieldToSupport'

of <ScreenToSupport>..
For example on click an Item like rediffHomePage from a repeater It should display like 'HotJobs'

and 'Game'. How can I display Label of corresponding FieldsToSupport/FieldToSupport on click on

corresponding Label of <ScreenToSupport>.. Should I take Repeater inside Repeater or I Repeater

inside DataList.

following is the structure of XML file
--------------------------------------------------------------------
<ScreensToSupport>
<ScreenToSupport>
<ScreenUniqueId>199d1dfd-63ca-4271-b234-77da0f579e0e</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>1</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
...
<Label>HotJobs</Label>
...
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Game</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage</Label>

</ScreenToSupport>
<ScreenToSupport>
<ScreenUniqueId>e62abc49-efc7-4a5d-908f-33f2f4df070b</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
...
<RefId>2</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
..
<Label>Images</Label>
..
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
...
<Label>Air Tickets</Label>
...
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>rediffHomePage1</Label>
</ScreenToSupport>
</ScreensToSupport>
--------------------------------------------------------------------
and following is my .cs file
--------------------------------------------------------------------
<%@ Page Language="C#" MasterPageFile="~/BaydonHeader.master" AutoEventWireup="true"

CodeFile="list_labels.aspx.cs" Inherits="list_labels" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="Baydon"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<asp:Content ID="Content2" ContentPlaceHolderID="cphDetail" runat="Server">
<script runat="server">

public void Page_Load(Object sender, EventArgs e){
string AlbumPath = Request.QueryString["AlbumPath"];
string AlbumName = Request.QueryString["AlbumName"];
string path=AlbumPath + "/" + AlbumName + ".linkinfo.xml";
XmlDataSource1.DataFile = path;
// XmlDataSource2.DataFile = path;

XmlDataSource2.Data = "<FieldsToSupport><FieldToSupport><Label>Just To Test

1</Label></FieldToSupport><FieldToSupport><Label>Just To Test

2</Label></FieldToSupport></FieldsToSupport>";

if (!IsPostBack) {
string xmlFilePath = @path;
UpdateXml();
//XmlDocument doc = new XmlDocument();
//doc.Load(xmlFilePath);
System.Data.DataSet objDataSet = new DataSet();
objDataSet.ReadXml(path);
}
}

public void UpdateXml()
{
try
{

string AlbumPath = Request.QueryString["AlbumPath"];
string AlbumName = Request.QueryString["AlbumName"];
string path = AlbumPath + "\\" + AlbumName + ".linkinfo.xml";
XmlDocument doc = new XmlDocument();
doc.Load(path);
System.Data.DataSet objDataSet = new DataSet();
objDataSet.ReadXml(path);

int intRefId = 1; //Request.QueryString["RefId"].ToString();

/*ls*/
string strXPathLS =

"/LinkInformation/ScreensToSupport/ScreenToSupport/SupportItems/ScreenSupportItem[RefId='" +

intRefId + "']";
XmlNode newParentLS = doc.SelectSingleNode(strXPathLS).ParentNode.NextSibling;

/*
Repeater repeaterLS = new Repeater();
repeaterLS=(Repeater)Repeater1.FindControl("Repeater2");
Repeater3.DataSource = newParentLS;
Repeater3.DataBind();
*/

/*
foreach (System.Xml.XmlNode node1LS in newParentLS)
{
Response.Write(node1LS["Label"].InnerText + "<br>");
}
*/
/*ls*/
}
catch (Exception err)
{
Response.Write(err);
//lblError.Text = "ERROR:" + err.Message.ToString();
//txtUrlTitle.Focus();
}

}

</script>

<script type="text/javascript">

function showCD(str)
{
// var strXML=document.getElementById("scid").value;
// alert(strXML);
var imgId=str;

function getURLParam(strParamName){

var strPath = "";
var strName = "";
var strHref = window.location.href;
if ( strHref.indexOf("?") > -1 ){
var strQueryString = strHref.substr(strHref.indexOf("?")).toLowerCase();
var aQueryString = strQueryString.split("&");
strPath = aQueryString[0];
strName = aQueryString[1];
var url="list_labels.aspx"+strPath+"&"+strName+"&ImgId="+imgId;
window.location=url;
}
}
getURLParam("AlbumPath");

}
</script>
<div align="center">
<fieldset class="fieldset1" style="border-bottom-color:#6699ff;

border-left-color:#6699ff;border-right-color:#6699ff; border-top-color:#6699ff;

border-style:groove;">

<table style="width: 100%; height: 100%">

<tr>
<td align="left" style="width: 19%; height: 100%" valign="top">

<table style="border-right: #6699ff thin solid; border-top: #6699ff thin solid;

padding-left: 4px;
border-left: #6699ff thin solid; width: 87%; border-bottom: #6699ff thin

solid;
height: 90%">
<tr>
<td align="left" style="width: 216px; height: 100px" valign="top">
<table style="height: 40%">
<tr>
<td style="height: 18px; background-color: #0099cc;"

valign="top">

<asp:Label ID="Label4" runat="server" ForeColor="Black"

Text="Labels" BackColor="Transparent" Font-Bold="True" Font-Size="Medium" Width="216px"></asp:Label>
</td>
</tr>

<tr>
<td style="height: 175px" valign="top">
<asp:XmlDataSource runat="server" id="XmlDataSource1"

XPath="LinkInformation/ScreensToSupport" />
<asp:XmlDataSource runat="server" id="XmlDataSource2"

XPath="FieldsToSupport" />

<asp:Repeater ID="Repeater1" runat="server"

DataSourceID="XmlDataSource1">
<ItemTemplate>
<asp:Repeater ID="Repeater2"

DataSource='<%#XPathSelect("ScreenToSupport")%>' runat="server">

<ItemTemplate>
<%--<a href="#"

onclick="showCustomer(<%#XPath(SupportItems/ScreenSupportItem/RefId)%>)"><b><%#XPath("Label")%></b><

/a>--%>
<input type="button"

onclick="showCD(<%#XPath("SupportItems/ScreenSupportItem/RefId")%>)" value="<%#XPath("Label")%>"

style="border-right: #66ffff thin ridge; border-top: #66ffff thin ridge; font-weight: bold;

font-size: 12px; vertical-align: middle; text-transform: capitalize; border-left: #66ffff thin

ridge; cursor: hand; color: Black; border-bottom: #66ffff thin ridge; font-family: Verdana;

background-color: #E2EBED; text-align: left;width:100%" />
<asp:Repeater ID="Repeater3" runat="server"

DataSourceID="XmlDataSource2">
<ItemTemplate>
<asp:Repeater ID="Repeater9" DataSource='<%#XPathSelect("FieldToSupport")%>' runat="server">

<ItemTemplate>
<%#XPath("Label")%> <br />
</ItemTemplate>
</asp:Repeater>
</ItemTemplate>
</asp:Repeater>
</ItemTemplate>
</asp:Repeater>
</ItemTemplate>
</asp:Repeater>
</td>
</tr>
</table>
</td>
</tr>
</table>

<table style="border-right: #6699ff thin solid; padding-left: 4px; border-left:

#6699ff thin solid; width: 100%; border-bottom: #6699ff thin solid; height: 90%">
<tr>
<td style="width: 218px" valign="top">
<table style="height: 30%">
<tr>
<td valign="top" style="width: 264px">
<asp:Label ID="Label7" runat="server" ForeColor="Black"

Text="Actions"></asp:Label></td>
</tr>
<tr>
<td valign="top" style="width: 264px; height: 18px">
    
</td>
</tr>
<tr>
<td align="left" valign="middle" style="width: 264px">
<asp:ImageButton ID="ImageButton2" runat="server"

ImageUrl="~/images/new.png"

OnClientClick="document.getElementById('helptypediv').style.visibility='visible';return false;"

/> <asp:ImageButton ID="ImageButton7" runat="server" ImageUrl="~/images/Edit.png"

/> <asp:ImageButton ID="ImageButton8" runat="server" ImageUrl="~/images/Delete.png" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td style="width: 75%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-right: #6699ff

thin solid; border-top: #6699ff thin solid; padding-left: 4px; border-left: #6699ff thin solid;

width: 50%; border-bottom: #6699ff thin solid; height: 50%">
<tr>
<td colspan="2" style="height: 23px">
<asp:ImageButton ID="ImageButton1" runat="server"

ImageUrl="~/images/Page-View-hover.png" />
<asp:ImageButton ID="ImageButton6" runat="server"

ImageUrl="~/images/Browser-View.png" /></td>
</tr>

<tr style="color: #000000">
<td align="left" colspan="2" style="width: 50%; height: 40%;

background-color: #ffffff">

<div style="border-right: green 1px solid; border-top: green 1px

solid; z-index: 1; left: 400px; visibility: hidden; border-left: green 1px solid; width: 200px;

border-bottom: green 1px solid;position: absolute; top: 250px; background-color: #e2ebed"

id="helptypediv">
<table style="height: 100%; width: 100%;">
<tr style="background-color: #365f91">
<td align="center" colspan="3">
<asp:Label ID="Label1" runat="server"

ForeColor="White" Text="Select Action"></asp:Label> </td>

</tr>
<tr style="background-color: #95b3d7">
<td colspan="3">
Link     
<input id="radLink" type="radio"

name="choosebox" /></td>
</tr>
<tr style="background-color: #c6d9f1">
<td colspan="3">
Popup  
<input id="radPopup" type="radio"

name="choosebox" /></td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
<tr>
<td align="center" colspan="3">
<input id="Button2" type="button" value=" Ok "

/>
<input id="Button1"

onclick="document.getElementById('helptypediv').style.visibility='hidden'" type="button"

value="Cancel" />
</td>
</tr>
</table>
</div>
<div style="width: 700px; height: 400px; overflow: auto;

font-family: Verdana, Tahoma, Helvetica, sans-serif; font-size: 11px; color: #000000;">
<asp:Image ID="Image1" runat="server" /></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</fieldset>
</div>
</asp:Content>
--------------------------------------------------------------------
I am not very familiar with how displaying XML contents.. I tried this way..
But stuck on that point please help me ..
I will very thankful for that..

Vishnu

-- modified at 9:01 Thursday 15th November, 2007

pmarfleet15-Nov-07 10:33

Re: How to dispaly attributes of xml nested repeater..(if XML not followed hierarchical structure)

15-Nov-07 10:33

You should look at using nested Repeater controls[^] to solve your problem.

BTW, why are you mixing your server-side code and markup in the same file? You should really consider splitting the server-side code out into a code-behind file for the sake of maintainability. I haven't seen code mixed like this since the bad old days of ASP...

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Vishnu Narayan Mishra15-Nov-07 19:16

Re: How to dispaly attributes of xml nested repeater..(if XML not followed hierarchical structure)

15-Nov-07 19:16

Sir, can you give me any solution to how can i do this. I will very thankful to you..

pmarfleet15-Nov-07 19:41

How to give a unique id like that 15b85c2b-83ca-44ec-8741-22a4dc64f64d in using c#

15-Nov-07 19:41

Have you looked at the examples I suggested? Have you attempted to solve the problem yourself? Seriously, if you can't be bothered to help yourself then I can't give you any further advice.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Vishnu Narayan Mishra14-Nov-07 20:19

Re: How to give a unique id like that 15b85c2b-83ca-44ec-8741-22a4dc64f64d in using c#

14-Nov-07 20:19

I have a little query of generting unique id for creating node ,
Is there is any way to generate random no ...
I have to genarate a random no for FieldUniqueId attribute in the
<FieldToSupport> each time when I create a new node
<FieldToSupport>..
I tried it by using Session.SessionID but the no string genarated
for example 'hzskur45zxzh4jiwq5lsp3j3' this is same during for
the logged user .... also i have to generate random no string in
the format like '15b85c2b-83ca-44ec-8741-22a4dc64f64d' ..
following is the strucuture of XML file
<FieldsToSupport>
<FieldToSupport>
<Caption>Blank</Caption>
<Url>Blank</Url>
<Label>NewField1</Label>
<HtmlName />
<HtmlId />
<FieldUniqueId>15b85c2b-83ca-44ec-8741-22a4dc64f64d</FieldUniqueId>
<LinkHref>http://careers.msn.com/</LinkHref>
<InnerHTML>Careers &amp; Jobs</InnerHTML>
<OuterHTML><A href="http://careers.msn.com">Careers &amp;
Jobs</A></OuterHTML>
<PopupHTML />
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
......
</FieldToSupport>

<FieldToSupport>
......
</FieldToSupport>

</FieldsToSupport>

Vishnu Narayan Mishra14-Nov-07 22:23

how to fetch child nodes of parent node in XML .. using c#...

14-Nov-07 22:23

I got the answer..there is a method in System namespace called Guid().
we can use it as
string newID = Guid.NewGuid().ToString();
its genarate every time a uniue Id according to my requirement..

Thanks

Vishnu Narayan Mishra14-Nov-07 2:03

Re: how to fetch child nodes of parent node in XML .. using c#...

14-Nov-07 2:03

hello every one... I am tried to retrieve a node FieldsToSupport/FieldToSuport in a xml..
Following is the structure of my xml file.....there can be multiple <FieldToSuport> into

<FieldsToSupport> in a <ScreenToSupport>. Also <ScreenToSupport> can be multiple..
------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<LinkInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<LinkToolId>0</LinkToolId>
<LinkToolVersion>1.0.1</LinkToolVersion>
<ScreensToSupport>
<ScreenToSupport>
<ScreenUniqueId>e7dfee93-14f0-4775-baef-c7246dfae902</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
<LinkDate>2007-10-25T11:47:10.515625+05:30</LinkDate>
<LinkAuthor>SUBHASH\Login Subhash</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\iframeCopy.html</LinkURL>
<LinkText>Updating Adding New Row</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreenSupportItem>
</SupportItems>
<FieldsToSupport>
<FieldToSupport>
<Caption>Blank</Caption>
<Url>Blank</Url>
<Label>NewField1</Label>
<HtmlName />
<HtmlId />
<FieldUniqueId>15b85c2b-83ca-44ec-8741-22a4dc64f64d</FieldUniqueId>
<LinkHref>http://careers.msn.com/</LinkHref>
<InnerHTML>Careers &amp; Jobs</InnerHTML>
<OuterHTML><A href="http://careers.msn.com">Careers &amp;

Jobs</A></OuterHTML>
<PopupHTML />
<FieldSupportItems />
</FieldToSupport>
<FieldToSupport>
<Caption>Blank</Caption>
<Url>Blank</Url>
<Label>Screen2</Label>
<HtmlName />
<HtmlId />
<FieldUniqueId>97d5c477-a5f4-4496-8084-19a537d85e29</FieldUniqueId>
<LinkHref>http://slate.com/</LinkHref>
<InnerHTML>Slate Magazine</InnerHTML>
<OuterHTML><A href="http://slate.com">Slate Magazine</A></OuterHTML>
<PopupHTML />
<FieldSupportItems />
</FieldToSupport>
</FieldsToSupport>
<Label>label3</Label>
<ScreenMatchProbabilityLevel>172.0934</ScreenMatchProbabilityLevel>
</ScreenToSupport>
</ScreensToSupport>
</LinkInformation>
------------------------------------------------------------
and following is my code in c#. I am try to fetch node <ScreenToSupport> by its ScreenUniqueId

attribute..

string strScreenId = Convert.ToInt32(Request.QueryString["ScreenId"]);
string strXPath =

"/LinkInformation/ScreensToSupport/ScreenToSupport/[ScreenUniqueId='"+strScreenId+"']";

XmlNode newParent = doc.SelectSingleNode(strXPath);
------------------------------------------------------------
but it giving error "Expression must evaluate to a node-set." new parent comming null here..
------------------------------------------------------------
after that I have to fetch corressponding

"FieldsToSupport/FieldToSupport[FieldUniqueId='"+strFieldId+"']" of <ScreenToSupport> node..
How can fecth FieldsToSupport/FieldToSupport need help any ones..
Please reply me soon sir. I will very thankful for th

led mike14-Nov-07 5:02

Re: how to fetch child nodes of parent node in XML .. using c#...

14-Nov-07 5:02

Well I have some suggestions for you.

First I recommend, it's what I use, www.w3schools.com as an excellent reference for things like XPath etc.

Second, find yourself a method of testing XPath statements before you try to integrate them into code. I mean you just type a statement and execute it in some environment to see that you obtain the node or node set desired. There might be something you can get for free and it's not that difficult to write a little command line utility or even a Windows Forms application for testing XPath statements.

Lastly, when you want to create a paramaterized XPath statement don't use string concatination, use String.Format(...) with format strings that have placeholders for the parameters. It's far simpler to get the XPath statement syntax correct when you do that. Let's use your statement as an example:

"/LinkInformation/ScreensToSupport/ScreenToSupport/[ScreenUniqueId='"+strScreenId+"']";<br />

The format string would be:

"/LinkInformation/ScreensToSupport/ScreenToSupport/[ScreenUniqueId='{0}']";

then use it in String.Format and pass the parameter to fill in the placeholder.

Now to your problem. You XPath statement syntax is incorrect, there should be no path separator before the expression

ScreenToSupport/[ScreenUniqueId

should be

<br />
ScreenToSupport[ScreenUniqueId

Vishnu Narayan Mishra19-Nov-07 20:03

Re: how to fetch child nodes of parent node in XML .. using c#...

19-Nov-07 20:03

hello sir
the way you tried to explain me is excellent..
But I am did'nt get you point 'then use it in String.Format and pass the parameter to fill in the placeholder.'
How we pass parameter into String.Format pls tell m?

Thanks a lot

led mike20-Nov-07 5:39

how can we go through such kinds of tag in xml like <PopupHTML />

20-Nov-07 5:39

Vishnu Narayan Mishra wrote:
How we pass parameter into String.Format pls tell m?

I don't think I understand your question. You have read the documentation[^] yes?

Vishnu Narayan Mishra13-Nov-07 23:17

Re: how can we go through such kinds of tag in xml like

13-Nov-07 23:17

hello every one...
can you help me to sort out a little problem of xml?
how can we go through such kinds of tag in xml like <PopupHTML />
and make it complete pair tag like that <PopupHTML> </PopupHTML> using c#
this is the sample structure of my XML file...

please reply me soon sir thank you...

--------------------------------------------------------------
<FieldsToSupport>
<FieldToSupport>
<Caption>Blank</Caption>
<Url>Blank</Url>
<Label>NewField1</Label>
<HtmlName />
<HtmlId />
<FieldUniqueId>15b85c2b-83ca-44ec-8741-22a4dc64f64d</FieldUniqueId>
<LinkHref>http://careers.msn.com/</LinkHref>
<InnerHTML>Careers &amp; Jobs</InnerHTML>
<OuterHTML><A href="http://careers.msn.com">Careers &amp; Jobs</A></OuterHTML>
<PopupHTML />
<FieldSupportItems />
</FieldToSupport>

<FieldToSupport>
...
</FieldToSupport>

<FieldToSupport>
...
</FieldToSupport>

<FieldToSupport>
...
</FieldToSupport>
<FieldsToSupport>
--------------------------------------------------------------

George L. Jackson14-Nov-07 1:53

George L. Jackson

14-Nov-07 1:53

You need to read the documentation, and there are a lot of examples available on Code Project and the rest of the internet. Anyways, here is an example:

using System;
using System.Xml;

namespace XmlExample
{
class Program
{
static void Main(string[] args)
{
string xml =
"<?xml version='1.0'?>\n"
+ "<nodes>\n"
+ "\t<node/>\n"
+ "</nodes>\n";

XmlDocument xml_doc = new XmlDocument();
xml_doc.PreserveWhitespace = true;
xml_doc.LoadXml(xml);

XmlNode node = xml_doc.SelectSingleNode("//nodes/node");

if (node != null)
{
XmlText text = xml_doc.CreateTextNode("Hello, World!");
node.AppendChild(text);
}

Console.WriteLine(xml_doc.InnerXml);
}
}
}

"We make a living by what we get, we make a life by what we give." --Winston Churchill

How to delete a xml node with all attributes and start, end tag of the xml node in c#-- urgent

Vishnu Narayan Mishra13-Nov-07 2:17

Re: How to delete a xml node with all attributes and start, end tag of the xml node in c#-- urgent

13-Nov-07 2:17

Hello every one! I have a little problem of deleting xml node. I have deleted successfully the

attributes of node <ScreenSupportItem> but opening and closing tag of node was not deleted

<ScreenSupportItem> and </ScreenSupportItem>.
But i have to delete also the opening and clsing tag ofthe node <ScreenSupportItem> means I have to

remove every thing of <ScreenSupportItem>.How can I do this.

following is the structure of my xml file
--------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<LinkInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<LinkToolId>0</LinkToolId>
<LinkToolVersion>1.0.1</LinkToolVersion>
<ScreensToSupport>
<ScreenToSupport>
<ScreenUniqueId>c1f13323-209b-4b0e-ad8d-d34f64d34c28</ScreenUniqueId>
<SupportItems>
<ScreenSupportItem>
<LinkDate>2007-10-25T11:47:10.515625+05:30</LinkDate>
<LinkAuthor>SUBHASH\Login Subhash</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\main.html</LinkURL>
<LinkText>Adding New Html Help</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreenSupportItem>
<ScreenSupportItem>
...
</ScreenSupportItem>
<ScreenSupportItem>
....
</ScreenSupportItem>
</SupportItems>
</ScreensToSupport>
</LinkInformation>
--------------------------------------------------------
following is my c# code
--------------------------------------------------------
//int intRefId = Convert.ToInt32(Request.QueryString["RefId"]);
int intRefId = 3;
string strXPath =

"/LinkInformation/ScreensToSupport/ScreenToSupport/SupportItems/ScreenSupportItem[RefId='" +

intRefId + "']";

XmlNode newParent = doc.SelectSingleNode(strXPath);
XmlNodeList newChildNodeList = newParent.ParentNode.ChildNodes;
foreach (XmlNode node1 in newChildNodeList)
{
foreach (XmlNode node in node1)
{
if (node.Name == "LinkURL" && node.InnerText == hdntxtUrlLink.Text)
{
intCount++;
}
if (node.Name == "LinkText" && node.InnerText == hdntxtUrlTitle.Text)
{
intCount++;
}
}
if (intCount == 2)
{
node1.RemoveAll();// This line deleted successfully the node but it left

start and end tag of the node <ScreenSupportItem> and </ScreenSupportItem>
lblError.Text = "Deleted successfully !";
break;
}
}
doc.Save(strXMLFile);
--------------------------------------------------------
please reply me soon.
Thanks in advance..
Vishnu

led mike13-Nov-07 6:18

Re: How to delete a xml node with all attributes and start, end tag of the xml node in c#-- urgent

13-Nov-07 6:18

Use an XPath statement to find the node you want to remove then call

node.ParentNode.RemoveChild(node)<br />
<br />

XmlNode node = doc.SelectSingleNode("//x/y/z/ScreenSupportItem");
node.ParentNode.RemoveChild(node);

Vishnu Narayan Mishra13-Nov-07 22:24

How can I go through all child nodes and attributes of child nodes of a parent node..

13-Nov-07 22:24

Thanks a lot sir, its working fine....

Vishnu Narayan Mishra12-Nov-07 22:22

How can I go through all child nodes and attributes of child nodes of a parent node.. [modified]

12-Nov-07 22:22

Hello sir

There is a little problem of xml again.
How can I go through all child nodes and attributes of child nodes of a parent node..

Suppose i have to go through all child nodes e.g.<ScreenSupportItem> of parent nodes

e.g.<SupportItems>. There can be mutiple <ScreenSupportItem> in a parent node <SupportItems>. I have

to check values of <LinkURL> and <LinkText> of all child nodes <ScreenSupportItem> and if it matches

with the supplied valus it gives a message 'LinkUrl/LinkText already exist' else insert new

<ScreenSupportItem> of <ScreenSupportItem> and set all attributes of <ScreenSupportItem> , which was

supplied by the user.
My code check only first child <ScreenSupportItem> of <SupportItems> if it values matches for

<LinkURL> and <LinkText> give a proper message else insert new <ScreenSupportItem>.
So how can I check all child <ScreenSupportItem> for values <LinkURL> and <LinkText> of

<SupportItems>

This is a sample struture of my XML file
----------------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?>
<LinkInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<LinkToolId>0</LinkToolId>
<LinkToolVersion>1.0.1</LinkToolVersion>

<ScreensToSupport>
<ScreenToSupport>
<LinkDate>2007-11-13T12:48:29.9687500+05:30</LinkDate>
<LinkAuthor>SUBHASH\vishnu</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\iframe.html</LinkURL>
<LinkText>HTML Help File</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreenToSupport>

<ScreenToSupport>
<LinkDate>2007-11-13T13:04:40.2656250+05:30</LinkDate>
<LinkAuthor>SUBHASH\vishnu</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\main.html</LinkURL>
<LinkText>Adding new Help Link</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreensToSupport>

<ScreenToSupport>
<LinkDate>2007-11-13T13:04:24.8437500+05:30</LinkDate>
<LinkAuthor>SUBHASH\vishnu</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\iframeCopy.html</LinkURL>
<LinkText>New Link Help</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreensToSupport>

<ScreenToSupport>
.....
</ScreenToSupport>

</ScreensToSupport>

</LinkInformation>
----------------------------------------------------------------

follwing is my code..
please reply me soon sir .. i will very thankful for that..
----------------------------------------------------------------
if (strAlbumName != "" && strAlbumPath != "")
{
strXMLFile = strAlbumPath + "\\" + strAlbumName + ".linkinfo.xml";
XmlDocument doc = new XmlDocument();
doc.Load(strXMLFile);

System.Data.DataSet objDataSet = new DataSet();

FileStream findata = new FileStream(strXMLFile, FileMode.Open, FileAccess.Read,

FileShare.ReadWrite);
objDataSet.ReadXml(findata);
findata.Close();
//int intRefId = Convert.ToInt32(Request.QueryString["RefId"]);
int intRefId = 3;
string strFilePath = FileUpload.PostedFile.FileName;
string strXPath =

"/LinkInformation/ScreensToSupport/ScreenToSupport/SupportItems/ScreenSupportItem[RefId='" +

intRefId + "']";

XmlNode newParent =

doc.SelectSingleNode(strXPath);//.ParentNode.NextSibling.ChildNodes;

foreach (XmlNode node in newParent)
{
if (node.Name == "LinkURL")
{
if (node.InnerText == FileUpload.PostedFile.FileName)
{
BaydonConstants.flag = true;
break;
}
}
else if (node.Name == "LinkText")
{
if (node.InnerText == txtUrlTitle.Text)
{
BaydonConstants.flag = true;
break;
}
}
}
if (BaydonConstants.flag == true)
{
lblError.Text = "LinkUrl/LinkText already exist !";
BaydonConstants.flag = false;
}
else
{
string strMachineName = System.Environment.MachineName + "\\";
XmlNode newRootParent = doc.SelectSingleNode(strXPath).ParentNode;
int intNodeCount = newRootParent.ChildNodes.Count;
if (intNodeCount == 1 && (newParent["LinkURL"].InnerText.ToString() == "" &&

newParent["LinkText"].InnerText.ToString() == ""))
{
newParent["LinkDate"].InnerText = DateTime.Now.ToString("o");
newParent["LinkAuthor"].InnerText = strMachineName +

Session["UserId"].ToString();
newParent["LinkURL"].InnerText = FileUpload.PostedFile.FileName;
newParent["LinkText"].InnerText = txtUrlTitle.Text;
lblError.Text = "Inserted successfully !";
}
else
{
XmlNode newScreenToSupport = newParent.Clone();
newScreenToSupport["LinkDate"].InnerText = DateTime.Now.ToString("o");
newScreenToSupport["LinkAuthor"].InnerText = strMachineName +

Session["UserId"].ToString();
newScreenToSupport["LinkURL"].InnerText = FileUpload.PostedFile.FileName;
newScreenToSupport["LinkText"].InnerText = txtUrlTitle.Text;

newRootParent.InsertBefore(newScreenToSupport, newParent);
lblError.Text = "Inserted successfully !";
}
doc.Save(strXMLFile);
}
}
}
----------------------------------------------------------------

Vishnu Narayan

Vishnu Narayan Mishra12-Nov-07 21:14

Re: Edititng the tag of XML

12-Nov-07 21:14

Hello every one..
There is a little problem of xml..?
How can I go through all child nodes and attributes of child nodes of a parent node..

Suppose i have to go through all child nodes e.g.<ScreenSupportItem> of parent nodes e.g.<SupportItems>. There can be mutiple <ScreenSupportItem> in a parent node <SupportItems>. I have to check values of <LinkURL> and <LinkText> of all child nodes <ScreenSupportItem> and if it matches with the supplied valus it gives a message 'LinkUrl/LinkText already exist' else insert new
<ScreenSupportItem> of <ScreenSupportItem> and set all attributes of <ScreenSupportItem> , which was supplied by the user.
My code check only first child <ScreenSupportItem> of <SupportItems> if it values matches for <LinkURL> and <LinkText> give a proper message else insert new <ScreenSupportItem>. So how can I check all child <ScreenSupportItem> for values <LinkURL> and <LinkText> of <SupportItems>

This is a sample struture of my XML file
--------------------------
<?xml version="1.0" encoding="utf-8"?>
<LinkInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<LinkToolId>0</LinkToolId>
<LinkToolVersion>1.0.1</LinkToolVersion>
<ScreensToSupport>
<ScreenToSupport>
<LinkDate>2007-11-13T12:48:29.9687500+05:30</LinkDate>
<LinkAuthor>SUBHASH\vishnu</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\iframe.html</LinkURL>
<LinkText>HTML Help File</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId>
</ScreenToSupport>

<ScreenToSupport>
<LinkDate>2007-11-13T13:04:40.2656250+05:30</LinkDate>
<LinkAuthor>SUBHASH\vishnu</LinkAuthor>
<LinkURL>C:\Documents and Settings\Login Subhash\Desktop\main.html</LinkURL>
<LinkText>Adding new Help Link</LinkText>
<OptionalSupportInstruction />
<RefId>3</RefId> //can be same for two or more childs
</ScreensToSupport>

<ScreenToSupport>
....
</ScreensToSupport>

<ScreenToSupport>
.....
</ScreenToSupport>

</ScreensToSupport>

</LinkInformation>
-----------------------------
following is my code..
please reply me soon sir .. i will very thankful for that..
-----------------------------
int intRefId = Convert.ToInt32(Request.QueryString["RefId"]);
string strFilePath = FileUpload.PostedFile.FileName;
string strXPath =

"/LinkInformation/ScreensToSupport/ScreenToSupport/SupportItems/ScreenSupportItem[RefId='" + intRefId + "']";
XmlNode newParent =
doc.SelectSingleNode(strXPath);//.ParentNode.NextSibling.ChildNodes;
foreach (XmlNode node in newParent)
{
if (node.Name == "LinkURL")
{
if (node.InnerText == FileUpload.PostedFile.FileName)
{
BaydonConstants.flag = true;
break;
}
}
else if (node.Name == "LinkText")
{
if (node.InnerText == txtUrlTitle.Text)
{
BaydonConstants.flag = true;
break;
}
}
}
if (BaydonConstants.flag == true)
{
lblError.Text = "LinkUrl/LinkText already exist !";
BaydonConstants.flag = false;
}
else
{
//insert new <ScreenSupportItem>...
doc.Save(strXMLFile);
}
}
}
-------------------------------

-- modified at 3:28 Tuesday 13th November, 2007

Edititng the tag of XML

SreejithAchutan8-Nov-07 17:04

SreejithAchutan

8-Nov-07 17:04

<?xml version="1.0"?>

<configuration>
<appSettings />
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>

<compilation debug="true" />
<roleManager enabled="true" />
<authentication mode="Forms">
<forms loginUrl="Login.aspx" path="/" defaultUrl="Default.aspx" cookieless="UseDeviceProfile">
</forms>
</authentication>
<authorization>
<deny users="?" />
</authorization>
</system.web>
<location path="UnauthorizedAccess.aspx">
<system.web>
<authorization>
<allow roles="Administrator" />
<deny users="*" />
</authorization>
</system.web>
</location>
<location path="Admin">
<system.web>
<authorization>
<allow roles="Manager" />
<deny users="?" />
</authorization>
</system.web>
</location>
</configuration>

How we select dynamically the location tag from a web.config if we have 2 0r 3 location tag is avilable.In the above webconfig file we have 2 location tag.I want to change the path of the location tag dynamically.Please help to overcome this problem.

led mike9-Nov-07 5:19

how to append node with attributes after an node in XML + C# [modified]

9-Nov-07 5:19

Try the XML tutorial at www.w3schools.com

Vishnu Narayan Mishra7-Nov-07 20:52

Re: how to append node with attributes after an node in XML + C#

7-Nov-07 20:52

hello every one I am tried to update an XML file but its not working according to my requirement. I have to create a new child node <screensupportitem> below the parent node <supportitems> with matching condition --where attribute of <screensupportitem> e.g <refid> is equal to 3 (comes from query string). Also new <screensupportitem> child have different attributes except <refid>. So I have to create a <screensupportitem> with setting new values of all the attributes.

This is the structure of XML file
-----------------------------------------------------------------
<screenstosupport>
<screentosupport>
........all have same structure <screentosupport>

<screentosupport>
<screenuniqueid>c1f13323-209b-4b0e-ad8d-d34f64d34c28
<supportitems>
<linkurl>C:\Documents and Settings\Login Subhash\Desktop\iframe.html
<linktext>New Link Help
<screensupportitem>
<linkdate>2007-10-25T11:47:10.515625+05:30
<linkauthor>SUBHASH\Login Subhash
<linkurl>C:\Documents and Settings\Login Subhash\Desktop\main.html
<linktext>Adding New Html Help
<optionalsupportinstruction>
<refid>3

<fieldstosupport>
<linkurl>C:\Documents and Settings\Login Subhash\Desktop\iframe.html
<linktext>New Link Help

<screentosupport>
........all have same structure <screentosupport>

And this is my sample code
-----------------------------------------------------------------
strXMLFile = strAlbumPath + "\\" + strAlbumName + ".linkinfo.xml";
XmlDocument doc = new XmlDocument();
doc.Load(strXMLFile);
FileStream findata = new FileStream(strXMLFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
objDataSet.ReadXml(findata);
findata.Close();
//int intRefId = Convert.ToInt32(Request.QueryString["RefId"]);
int intRefId = 3;
string strFilePath = FileUpload.PostedFile.FileName;
string strXPath = "/LinkInformation/ScreensToSupport/ScreenToSupport/SupportItems/ScreenSupportItem[RefId='" + intRefId + "']";

XmlNode newParent = doc.SelectSingleNode(strXPath);//.ParentNode.NextSibling.ChildNodes;

XmlNode newRootParent = doc.SelectSingleNode(strXPath).ParentNode;

XmlNode newScreenToSupport = newParent.Clone();
newRootParent.InsertAfter(newRootParent, newScreenToSupport);
doc.Save(strXMLFile);
-----------------------------------------------------------------
It giving error 'ERROR:Cannot insert a node or any ancestor of that node as a child of itself.'
I am very new in xml please help me to solved my problem. I will very thankful for your valuable cooperation.
Please reply me soon....

pmarfleet8-Nov-07 9:51

Sending XML Soap Messages, C#

8-Nov-07 9:51

Vishnu Narayan Mishra wrote:
newRootParent.InsertAfter(newRootParent, newScreenToSupport);

As the error message explains, you are adding a node as a child of itself here. Read the MSDN documentation[^] on this method if you are unsure how to use it.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

AssemblySoft5-Nov-07 6:18

AssemblySoft

5-Nov-07 6:18

am writing an app that uses the .Net classes TCPClient and NetworkStream to read and write data between 2 machines. All works fine.

I have recently found a need to be able to send Http 1.1 with a SOAP message as the Http body. Currently i am using an XmlDocument to load and parse the SOAP data. However to do this i first have to read in the HTTP header, search for the beginning of the body and construct my own XmlDocument.

There must be a better way. I don't want to call a web service, i just want to send http with a soap body and receive the same.

I am looking for a means of loading in the NetworkStream into some kind of HTTP object to read the http stuff and also load the body into some simple Soap object that can be used to pull out/ set values.

Comments, Suggestions Welcomed.

Carl

Double post

pmarfleet5-Nov-07 6:54