XML / XSL

2006-12-08 2006-12-10 2004-12-08 2006-01-17 2007-12-08 2007-12-09 String Comparison is less then "We make a living by what we get, we make a life by what we give." --Winston Churchill

You need to know more about XML. The following may be a good start: http://www.w3schools.com/xml/default.asp[^]. Also, you have given very little information about your issue. Since, you didn't give any information about your Table schema, the database or the programming language you are using, you are not going to get much help. "We make a living by what we get, we make a life by what we give." --Winston Churchill

Ever tried google: http://www.google.com/search?hl=en&q=javascript+xml&btnG=Google+Search[^] "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

Please refer this[^] for more information. Regards, Paresh.

Use ... Please refer this[^] for more information. Regards, Paresh.

Vote for my articles that you like, please :-) That will help a lot. ------------------------- Don't worry, be happy :o)

Did you add reference to the required .lib files?

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

It's really bad idea to store data in XML for performance reasons*. XML is great for files that should be easily readable and editable by both mashine and human - such as config files - but BIG table or whole database is probably not the case; and as format for data exchange between (possibly) different platforms. Affan Toor wrote: So what do you suggest i should use here....? As suggested by led mike, SQL server. [edit]*what I mean is that XML performance for large data is terrible[/edit] "Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe

I have escaped it in C# before it's written now thx!

To deserialize XML, you have to have a code model that is set up to mirror your XML structure (classes making use of the XMLSerializer attributes). Take a look at my article Using the XmlSerializer Attributes[^]. If that is what you are talking about, I have a tool that can help at BoneSoft.com[^]. Just drop in the XML you are dealing with, set the renderer to C# or VB.Net (whatever you are working with) and build it. It will produce an XML serializable class model you can use to deserialize you XML to. It will also produce a class that handles the serialization/deserialization for you. Hope that helps. Try code model generation tools at BoneSoft.com.

DTDs and XSDs (Xml Schema) are files that specify the allowable structure of XML files. They define the entities and relationships represented in XML files. So that you can validate XML against them to know that your XML conforms to the rules of the DTD/XSD. DTDs are the old standard for doing this. XSDs are the new standard. Google XSD and you'll find lots of references. If you don't really want to learn XSD right this minute, or you just need an XSD spec immediately, there are tools out there that can help. XMLSpy will generate an XSD from XML if you have sack loads of cash. Skeleton Crew[^] can also produce an XSD for you. Just drop in some XML that has all your possible nodes/attributes, set your renderer to XSD, and build. The XSD that's generated will likey need a little work (changing the optional/required attributes where appropriate), but it will give you a good starting schema. But like I said, google XSD, W3 Schools has a good XSD reference to help you finish your spec out. Hope that helps. Try code model generation tools at BoneSoft.com.

Those elements are not well-formed. Names must start with a Letter, an underscore, or a colon.

honeyss wrote: Now can i retrieve that xml file in browser when i click a button You do it all in a single request eliminating the writing to disk part. In the button handler event you create a memory rather than disk file XmlTextWriter and then set the Response Content-Type to XML and use Response.Write(...) to return the XML. led mike

Alright, I got it working by using a param with my template and calling it recursively as required. <xsl:template match="*"> <xsl:param name="Cont" select="."/> <xsl:if test="@Null='false'"> xsl:text"</xsl:text><xsl:value-of select="substring-before(concat($Cont,'"'),'"')"/>xsl:text"</xsl:text> <xsl:if test="contains($Cont,'"')"> <xsl:apply-templates select="."> <xsl:with-param name="Cont" select="substring-after($Cont,'"')"/> </xsl:apply-templates> </xsl:if> </xsl:if> </xsl:template> Note the use of concat() in the call to substring-before(). Here the param is named "Cont" and you can think of it as meaning either "contents" or "continuance". Given an initial value of: aaa "bbb" ccc 1) Output "aaa " 2) Recurse with bbb" ccc 3) Output "bbb" 4) Recurse with ccc 5) Output " ccc" Result: "aaa ""bbb"" ccc" I would appreciate any thoughts on this technique.