|
hi i have a problem but could not find its solutions i hope you people can help me,
i am fetching data from SQL2000 using XMLSQL so now data is in XML format and then i am accessing that data through XSLT and displaying into a web page in HTML table format and now i want to Export that selected info [that is in HTML table format] in Excel file. how can i do that.
note: i dont want to export the whole info that comes directly from the Query i want to do some manipulation on resulted query data and then want to export new info into Excel file.
regards
I love .NET
|
|
|
|
|
Store the manipulated data in another dataset and then transfer that data alone.
|
|
|
|
|
Hi,
Heres a sample XML document:
<?xml version="1.0" encoding="utf-8"?>
<Sample>
<Name>
<!--Indicates the first name-->
<FName>A</FName>
<!--Indicates the Middle name-->
<MName>M</MName>
<!--Indicates the last name-->
<LName>B</LName>
</Name>
<ID>1</ID>
</Sample>
If i get the count of childnodes of the node <name>, using the following statement: xmlNamenode.Childnodes.count, it returns 6 (i.e) it also includes the comments as a child node. Is there any way to directly get the count of number of elemets (excluding comment nodes) instead of alll the childnodes?
Thanks and Regards
Madhu
|
|
|
|
|
Maybe this one document.SelectNodes("/*").Count
"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
|
|
|
|
|
Hi,
Thanks. it solved the issue...
Thanks and Regards
Madhu
|
|
|
|
|
I am using XmlTextWriter in a function to create a Document element. The function returns e.g. the following:
<Document>
<UserID>ID blah blah</UserID>
</Document>
Now I call this function once for each document inside another method that creates one single XML message containing all <Document> elements. I would like to know how I can insert the text returned from the Document function into the XML message, and keep the correct indenting, as happens when I call WriteElementString.
|
|
|
|
|
Would it be an option to pass an XmlTextWriter into the method that writes the document element, so in the method that creates the overall xml message you instanciate one XmlTextWriter and pass it to the method together with each document.?
"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
|
|
|
|
|
We are trying to enforce a couple of business constrainrs with XPATH .
A sample xml node is as follows:
.....
.....
<event>
<element>IE</element>
<elementtype>browser</elementtype>
<eventtype>Navigate</eventtype>
<value>http://www.....com/</value>
</event>
.......
.......
If we need to ensure that the XML has ATLEAST one 'element' node containing text as "IE" we do:
<xsl:template match="element[count(IE) < 1]" >
<xsl:text>ERROR: Atleast one IE element needed</xsl:text>
</xsl:template>
But we need to ensure that ATLEAST one of the IE 'event' nodes has a combination of 'element' as IE and 'value' node containing the text "Logout" i.e.
<event>
<element>IE</element>
<elementtype>....</elementtype>
<eventtype>Navigate</eventtype>
<value>...Logout...</value>
</event>
How do we enforce this occuurrence constraint through template?
|
|
|
|
|
What's a good rule of thumb to use when deciding to add an element or attribute to a datatable?
|
|
|
|
|
Maybe this can help: USING ELEMENTS VS. ATTRIBUTES[^]
"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
|
|
|
|
|
|
Nice.
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
XimpleWare is proud to announce the release of version 2.0 of
VTD-XML, the next generation XML parser/indexer. The new
features introduced in this version are:
* VTD+XML version 1.0: the world's first true native XML index
that is simple, general-purpose and back-compatible with XML.
* NodeRecorder Class that saves VTDNav's cursor location for
later sequential access.
* Overwrite capability
* Lexically comparisons between VTD and strings
To download the software, please go to
http://sourceforge.net/project/showfiles.php?group_id=110612
To read the latest benchmark report please go to
http://vtd-xml.sf.net/benchmark1.html
To get the latest API overview
http://www.ximpleware.com/vtd-xml_intro.pdf
|
|
|
|
|
i am fetching some data from SQL based on JOINs [from 2 tables] and then utilizing that XML file and transforming through XSLT and now i need another JOIN and then to compare some fields returned from 1st Query to 2nd Query and then need to display that data through XSLT. how can i achieve.
.NET
|
|
|
|
|
Maybe this can help: Multiple Source Documents[^]
"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
|
|
|
|
|
hi i am taking some data from xml file through xslt and then displaying selected data in HTML table format on a page and now i want to export that HTML table into excel how can do that.
I love .NET
|
|
|
|
|
|
Hello!
I'm trying to use an XSL stylesheet to transform an XML document into a CSV file. This works
quite fine, except one problem: XSL outputs an XML header:
<?xml version="1.0" encoding="utf-8"?>
"Item 1","Sub-Item 1.1","SubItem 1.2"
"Item 2","Sub-Item 2.1","SubItem 2.2"
"Item 3","Sub-Item 3.1","SubItem 3.2"
"Item 4","Sub-Item 4.1","SubItem 4.2"
Is there any XSL command that prevents the output of the first line?
Best regards
Dominik
|
|
|
|
|
XSLT <xsl:output> Element[^] You're looking for the omit-xml-declaration attribute.
"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
|
|
|
|
|
Exactly what I was looking for, thanks a lot! 
|
|
|
|
|
hi
how i can convert RMS database to XML File or SQL Server or any type of database ?
and ho i can connect my application witt RMS Files ?
|
|
|
|
|
Greetings.
I have a method that takes two XmlElement objects. I want to find out if the XmlSchemaSet I have a reference to allows the first element to be a child of the second element.
What's the best way to do queary a schema to find out if an element type can be a valid child of another element type?
Thanks!
Ian
|
|
|
|
|
hello sir,
Please tell me the easiest way to learn .net framework,c#
vb,asp.net in effient way.
|
|
|
|
|
First, you need a development environment with Visual Studio .Net.
Second, you need to decide which language you would like to learn first. Once you get that figured out, you need to get some books. Check Amazon.com for books on your desired topic and be sure to read the customer reviews.
As for C# and the .Net Framework, I highly recommend two books:
Microsoft Visual C# Step by Step - this is an excellent book for learning the C# language.
CLR via C# - This is quite possibly the best technical book I've ever read and is an absolute requirement for anyone who wants to develop .net applications.
Also, if you want people to reply to your questions, it is best to pay close attention to the forum you are posting in and keep your questions to the specified topic. This forum is for XML/XSL related questions.
Good luck!
Ian
|
|
|
|
|
How about asking in the appropriate forum?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
