Page footer in xsl - XML / XSL Discussion Boards

Re: how to stote image file in xml ..

George L. Jackson20-Oct-06 11:53

George L. Jackson

20-Oct-06 11:53

One way is to store it as base64, http://en.wikipedia.org/wiki/Base64[^].

Re: tag error

Stefan Troschuetz18-Oct-06 5:21

Stefan Troschuetz

18-Oct-06 5:21

Check the NodeType to avoid endelement tags:

while(objXmlTextReader.Read())
{
  if (objXmlTextReader.NodeType != XmlNodeType.EndElement)
    Databasecb.Items.Add(objXmlTextReader.Name.ToString());
}

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

SOLVED

Saira Tanwir18-Oct-06 20:44

Saira Tanwir

18-Oct-06 20:44

thanks stefan
ur help was greatly valued and appreciated. Smile | :)

until next time Rose | [Rose]

goodbye

exception: The writer is closed

Saira Tanwir16-Oct-06 22:50

Saira Tanwir

16-Oct-06 22:50

hello friends

i'm trying to insert new tags into an already existing XML document.
but it is not working properly. i get the exception
"The writer is closed"
the code i'm using is:

<br />
doc.Load(Application.StartupPath + @"\Databases.xml");<br />
				<br />
XmlElement newElement=doc.CreateElement(Global.Instance.DBname); <br />
doc.DocumentElement.AppendChild(newElement);<br />
//write the document to disk<br />
dbTextFile.Formatting=Formatting.Indented;<br />
<br />
doc.WriteContentTo(dbTextFile);<big><---EXCEPTION GENERATES HERE</big><br />
<br />
dbTextFile.Close();<br />
MessageBox.Show("The following file has been successfully upgraded\r\n"+ sStartupPath+ @"\Databases.xml", "XML", MessageBoxButtons.OK,MessageBoxIcon.Information);

Re: exception: The writer is closed

Stefan Troschuetz17-Oct-06 4:39

Stefan Troschuetz

17-Oct-06 4:39

Where do you create the XmltextWriter passed to the WriteContentTo method? I seems you already called Close on this writer and need to create a new one.

Re: exception: The writer is closed [modified]

Saira Tanwir17-Oct-06 21:30

Saira Tanwir

17-Oct-06 21:30

heres another problem. i'm getting another exception that states that::

"the process cannot access the .....\Databases.xml" because it is being used by another process."

i've checked the process that are running but can't seem to find it.
the exception arises whenever i use the code
doc.Load(Application.StartupPath + @"\Databases.xml");

can u please tell me what the problem is??

thanks

-- modified at 4:36 Wednesday 18th October, 2006

Re: exception: The writer is closed

Stefan Troschuetz18-Oct-06 4:01

Stefan Troschuetz

18-Oct-06 4:01

Obviously something exclusively accesses the XML file. Maybe the XmlTextWriter that I saw in the code of your starting post. Hard to say without knowing the code.

Page footer in xsl

krishna1916-Oct-06 21:10

krishna19

16-Oct-06 21:10

Hi all,

We have an xsl file from which we are reading content and displaying it in a .aspx page.
We want to include a footer at the end of every page in the print preview.
We are facing a lot of problems in the positioning of the footer.

Is there any way to ensure that the footer comes at the end of the page irrespective of the page content ala footer in word?

Thanks in anticipation.

If you fail for the first time , call it version 1.0.

Problem creating XML Files

farhan197614-Oct-06 21:37

farhan1976

14-Oct-06 21:37

Hi,

I am trying to use XML file as an config file. The structure of the xml file is quite simple. It needs to have only

5 fields. This file stores information about 3 websites - so ideally structure should be like

<root>
<config>
<website 1="">
<url>test
<delay>23
<username>23
<password>32423

<website 2="">
<url>test
<delay>23
<username>23
<password>32423

I am using following code to create this Xml schema and xml file - but having some trouble (which i don't know WHY -

and I seek your guidence...)

public void create_Config_Table(string service_name, string url, string delay,
string freq, string username, string password)
{
string filename = "config.xml";
FileStream fs;
XmlTextWriter xtw;
XmlTextReader xtr;

string msg = "";

//create the table and then populate it
DataTable ret = new DataTable(service_name);

//Create the DataSet
DataSet ds = new DataSet("AutoMessage");

//first check if config.xml exists or not
//If it already exists then we don't have to recreate the XML schema for it
if( ! File.Exists(filename) )
{

//ret.Columns.Add("Service", Type.GetType("System.String"));
ret.Columns.Add("URL",Type.GetType("System.String"));
ret.Columns.Add("Delay", Type.GetType("System.String"));
ret.Columns.Add("Frequency",Type.GetType("System.String"));
ret.Columns.Add("Username",Type.GetType("System.String"));
ret.Columns.Add("Password",Type.GetType("System.String"));

//Now populate the data table
DataRow row = ret.NewRow();

//row["Service"] = service_name;
row["URL"] = url;
row["Delay"] = delay;
row["Frequency"] = freq;
row["Username"] = username;
row["Password"] = password;

ret.Rows.Add(row);
ds.Tables.Add(ret);

msg = "Config File Created";
}
else
{
//Read the XML File
try
{
fs = new FileStream(filename, FileMode.Open);
xtr = new XmlTextReader(fs);

ds.ReadXml(xtr);
xtr.Close();

DataTable dt = ds.Tables[0];

DataRow row = dt.NewRow();
//row["Service"] = service_name;
row["URL"] = url;
row["Delay"] = delay;
row["Frequency"] = freq;
row["Username"] = username;
row["Password"] = password;

dt.Rows.Add(row);
ds.Tables.Remove(ds.Tables[0].TableName);
ds.Tables.Add(dt);
msg = "Config File Updated";
}
catch(Exception ex) { Console.Error.WriteLine(ex.ToString() ) ; }

fs = null;
}

try
{
fs= new FileStream(filename, FileMode.Append,FileAccess.Write);
xtw = new XmlTextWriter(fs, System.Text.Encoding.Unicode);

ds.WriteXml(xtw);
xtw.Close();
Console.Write(msg);
}
catch(Exception ex) { Console.Error.WriteLine(ex.ToString() ); }
}

Logic here is that if file doesn't exists - it will create the xml schema and the xml file

if it does EXISTS - then it is read into an dataset - new values are appeneded to contents of this dataset it is
written back as a xml file.

- Major problem is that it creates a mal-formed XML (multiple root elements)
-- Any Suggestions

THanx in advance

Re: Problem creating XML Files

mnvkng7615-Oct-06 0:52

mnvkng76

15-Oct-06 0:52

System.IO.StringReader sr = new System.IO.StringReader(ds.GetXml());
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(sr);
ds.WriteXml("cpTest.xml");

Creates a file which looks like the following;

<AutoMessage>
<Services>
<URL>test.com</URL>
<Delay>5</Delay>
<Frequency>10</Frequency>
<Username>mnvkng76</Username>
<Password>aPassword</Password>
</Services>
</AutoMessage>

Is that what you needed?

Trying to create attrivbute xsi:schemaLocation [modified]

thomasa13-Oct-06 2:20

thomasa

13-Oct-06 2:20

This is what I want:

 ns0:Interchange xmlns:ns0="http://www.e2b.no/XMLSchema"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://www.e2b.no/XMLSchema e2b_Invoice_Interchange_v3p2.xsd"

The attribute schemaLocation I make with this code

<br />
XmlAttribute atrXsiSchemaLocation = null;<br />
atrXsiSchemaLocation = invoiceE2BDocument.CreateAttribute("xsi:schemaLocation");<br />
 atrXsiSchemaLocation.Value = "http://www.e2b.no/XMLSchema e2b_Invoice_Interchange_v3p2.xsd";<br />
elmInterchange.Attributes.Append(atrXsiSchemaLocation);<br />

But the "xsi:" is somehow gone and I get

schemaLocation="http://www.e2b.no/XMLSchema e2b_Invoice_Interchange_v3p2.xsd"

So I replaced the code with:

<br />
atrXsiSchemaLocation = invoiceE2BDocument.CreateAttribute("xsi", "schemaLocation", "xsi");<br />

but then I got:

d3p1:schemaLocation="http://www.e2b.no/XMLSchema e2b_Invoice_Interchange_v3p2.xsd" xmlns:d3p1="xsi"

Does anyone know how to fix this?

Thanks
Thomas

-- modified at 8:35 Friday 13th October, 2006

Re: Trying to create attrivbute xsi:schemaLocation

Stefan Troschuetz14-Oct-06 1:16

Stefan Troschuetz

14-Oct-06 1:16

Does the following work?

atrXsiSchemaLocation = invoiceE2BDocument.CreateAttribute("xsi", "schemaLocation", "http://www.w3.org/2001/XMLSchema-instance");

Re: Trying to create attrivbute xsi:schemaLocation

thomasa15-Oct-06 21:41

thomasa

15-Oct-06 21:41

No the result was:

d3p1:schemaLocation="" xmlns:d3p1="http://www.e2b.no/XMLSchema e2b_Invoice_Interchange_v3p2.xsd"

My solution

thomasa15-Oct-06 21:57

thomasa

15-Oct-06 21:57

Just before I save the xml file:

<br />
invoiceE2BDocument.InnerXml = invoiceE2BDocument.InnerXml.Replace("schemaLocation", "xsi:schemaLocation");<br />

It's not a good solution, but it works.

Re: where could be the problem?

Stefan Troschuetz12-Oct-06 21:08

Stefan Troschuetz

12-Oct-06 21:08

You should either check the "Ignore HTML tags in this message" box situated beneath the smilies or replace all opening tags with <, so we are able to see your xml.

Convert XML files to Chm

narayanagvs11-Oct-06 3:49

narayanagvs

11-Oct-06 3:49

Hi,

I need to generate documentation in the chm(compiled html) format.
what i did is I generated xml file from visual studio,now can you tell me any converter for XML to Chm.

Thanks

Today is a gift, that's why it is called the present.

Re: Convert XML files to Chm

Stefan Troschuetz12-Oct-06 21:06

Stefan Troschuetz

12-Oct-06 21:06

There is the open-source project NDOC but it's no longer active AFAIK and doesn't support .NET 2.0.
Microsoft has also released a help builder called Sandcastle they used to build framework documentation. Take a look at this article[^] which presents a nice GUI for it.

how to generate a filter encoded xml.

kalaveer10-Oct-06 20:14

kalaveer

10-Oct-06 20:14

hi
how can i convert the content specified in the parameters text box(parameter indicates that textbox can consist any parameter that is used to make query) to filter encoded xml.

thanx in advance.

SelectSingleNode '

Chris_Green10-Oct-06 4:23

Chris_Green

10-Oct-06 4:23

xn.OuterXml
"<doclibs text="\"Corporate" services\"="" url="\"http://sanpaula/CorporateServices\"" id="\"996bba7e-3d2a-406a-a0e5-90f39589ed9f\""><doclibs text="\"Secretary's" office\"="" url="\"http://sanpaula/C4/SecretaryOffice\"" id="\"23baa62f-5dd3-461a-875e-f37fa0035d71\""><doclib text="\"Dummy\"" id="\"-1\"">"

Corporate Services
Secretary's Office

xn.SelectSingleNode("*[@text='Secretary's Office']");

This is probably a stupid question. My xml contains a single quote in Secretary's Office. When searching, I tried replacing ' with ' but this did not work.

Is the answer simply that the XML is incorrect?

Re: SelectSingleNode &apos;

George L. Jackson10-Oct-06 7:16

George L. Jackson

10-Oct-06 7:16

C# does not understand entities! Use escape sequences.

xn.SelectSingleNode("*[@text=\"Secretary\'s Office\"]");

Re: SelectSingleNode &apos;

Chris_Green10-Oct-06 22:10

Chris_Green

10-Oct-06 22:10

Thanks, that did the trick. However you'd be up the creek if text contained both " and '

If the XML police saw the xml which contained ',",&,<,> wouldn't they give me a ticket?

XML to XML. XSLT conversion

shapper9-Oct-06 4:18

shapper

9-Oct-06 4:18

Hello,

I need to create a XML to XML conversion with XSLT.

Could someone help me out with this?

My original XML is:

<?xml version="1.0" encoding="utf-8" ?>
<siteMap xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode>
<siteMapNode
url = "~/Page01.aspx"
name = "Page01"
visible = "true" />
<siteMapNode
url = "~/Page02.aspx"
name = "Page02"
visible = "false" />
</siteMapNode>
</siteMap>

Would become:

<?xml version="1.0" encoding="UTF-8"?>
< urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
< url>
< loc>http://www.mydomain.com/Page01.aspx</loc>
< title>Page01</title>
</url>
</urlset>

So the following actions take place:

1. siteMap xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" becomes urlset xmlns="http://www.google.com/schemas/sitemap/0.84"

Node siteMap becomes node urlset.

2. The node "siteMapNode" becomes the node "url"

3. Only the nodes where attribute "visible" is "true" are copied to the new XML file.

4. Property visible is not copied to the new file.

5. Property "url" becomes node "loc" and "~" is replaced by "http://www.mydomain.com"

6. Property name becomes node title.

Well, I think I didn't forget anything.

Thank You Very Much
Miguel

Re: XML to XML. XSLT conversion

safat9-Oct-06 20:48

safat

9-Oct-06 20:48

I hope you got the idea but still what you are expecting from the people.. can you make it clear?

Sathik

Re: XML to XML. XSLT conversion

George L. Jackson10-Oct-06 7:27

George L. Jackson

10-Oct-06 7:27

The easiest way to transform XML to another hierarchy is to use a combination of xsl:copy and xsl:copy-of.

xslt showing up my PCDATA ...

2hdass8-Oct-06 18:47

2hdass

8-Oct-06 18:47

Hi all

I am having a problem in my xslt and xml

this is my xml file:
<a1>
<property owner="Wallace Chan1" id="p002" type="condominium">
<owner>Some company1</owner>
<address>
<streetno>35</streetno>
<streetname>Kingsbridge Garden Circlen</streetname>
<city>Mississauga</city>
<zipcode>L5r3z5</zipcode>
<state>Ontario</state>
<country>Canada</country>
</address>
</property></a1>

and here is my xsl file:
<xsl:template match="/">
<html>
<head><title>CSCC09 assignment 1, phase 1</title></head>
<body> <h2>List of properties:</h2>
<xsl:for-each select="a1/property[@type='condominium']">
<xsl:apply-templates/>
</xsl:for-each>
</table>
<br/>
<h3>House</h3>
<table>
</body></html>
</xsl:template>

<xsl:template match="property">
<tr>
<xsl:apply-templates/>
</tr>
</xsl:template>

<xsl:template match="owner">
<td>
<xsl:value-of select="text()"/>
</td>
</xsl:template>

</xsl:template>
</xsl:stylesheet>

I want to display the owner infomation in a table for each property. This xsl is working well, however it is showing all the other infomation in address as well...

its showing up all the PCDATA in <address>, with all spaces removed, and then showing up all the owner infomation correctly in the table.

how can i removed all the unwanted PCDATA?

thx thx

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.