|
Hi,
I thought I would try using ReadXml and WriteXml with DataTable instead of DataSet...
It appears that I need to use "XmlWriteMode.WriteSchema" when saving a DataTable if I want to read the same xml file back into a DataTable?
dt1.WriteXml("settings.xml", XmlWriteMode.WriteSchema);
dt2.ReadXml("settings.xml");
If I don't I get this error message:
"DataTable does not support schema inference from Xml"
Any enlightenment would be appreciated
thanks,
Ron
|
|
|
|
|
Hi,
I am getting XML data through web service. I also have some html tags in data in the format of "<>" What I need that when I display this data to page by using style sheet It should display proper html tags not "<>". Please tell me solution if anyone of u knows. My requirement is same as you people are using here in codeproject Editor to write Messages (Enter tags in text format and get them in good way.
Also refer me a good forum for javascipt.
Regards,
Abubakar
|
|
|
|
|
Abubakarsb wrote: when I display this data to page by using style sheet It should display proper html tags not "<>".
Do You want that HTML tags should render and show ? or you want to show html tags like <html> in page ?
|
|
|
|
|
I want to implement html tags like if there are tags in data in the format of "<t;>t;" It should convert them to <> and also make them to affact as we have for bold It should be bold, Understand? If not plz ask me again
|
|
|
|
|
i want to change MSXML2 in MSXML6.
Dim xmlDoc As New MSXML2.DOMDocument6.0
Dim objNodeList As MSXML2.IXMLDOMNodeList6.0
Dim objNode As MSXML2.IXMLDOMNode6.0
the error: the type MSXML2.IXMLDOMNode is not defined.
i must use MSXML6.
thanks
|
|
|
|
|
Looks like a simple mistake in a definition.
It should look this way:
Dim xmlDoc As New Msxml2.DOMDocument30
Dim currNode As IXMLDOMNode Look at the 2nd code snippet at: http://msdn2.microsoft.com/en-us/library/ms765513.aspx
-------------------------
Don't worry, be happy )
|
|
|
|
|
We have an xml viz.
<element>
<component>....
<event>....
<event>....
<event>....
<event>....
The number of events will be dynamic.
For a relevant component,we need to return the cooresponding events pipe-delimited.
We arrive at the particular component through SelectNodes - is there a smart,concise XPATH expression which can allow me to return the set of events in the way we want,rather than recursing through the set.
Note that component and event nodes are parent(ed) by 'element'.
We are using javascript.
|
|
|
|
|
Hi Guys,
I am using XSLT to the format some XML into HTML, now in my XML that comes directly from the Database, I have an int Field that stores a numeric field . I want to format this field to display on the screen with comma's in separating the thousands etc. i.e 300000 to render like 300,000
Does anyone know of a way that I can achieve this in XSLT ?
|
|
|
|
|
<a href="http://www.w3schools.com/xsl/el_decimal-format.asp">http://www.w3schools.com/xsl/el_decimal-format.asp</a>[<a href="http://www.w3schools.com/xsl/el_decimal-format.asp" target="_blank" title="New Window">^</a>]
This Link would help u.........
With Best Regards,
Yogesh
|
|
|
|
|
Thanks so much, that definetly helped!!
|
|
|
|
|
i want to change xml version2 with version 6.0 but it doesn't work.
i installed the xml 6.0 ,and when i tryed to add references it doesn't work.
thanks
|
|
|
|
|
Leoapa wrote: change xml version2 with version 6.0
There is no XML version 2.0 or 6.0. Are you talking about Microsoft Core XML Services (MSXML)?
Leoapa wrote: it doesn't work.
What exactly does that mean; are you getting any error messages or exceptions?
"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
|
|
|
|
|
yes.
i want to change MSXML2 in MSXML6.
Dim xmlDoc As New MSXML2.DOMDocument6.0
Dim objNodeList As MSXML2.IXMLDOMNodeList6.0
Dim objNode As MSXML2.IXMLDOMNode6.0
the error: the type MSXML2.IXMLDOMNode is not defined.
i must use MSXML6.
thanks
|
|
|
|
|
I'm using this code to try to sum a column in some data:
<code><xsl:value-of select="sum(../../staff/stat[position()])"/></code>
<xsl:value-of select="position()"/> returns the position as expected
if i replace position() with 1 i get the sum of the first column as expected but when i put position() as the parameter i get the sum of all the columns.
I don't know how many columns there will be in the data so i can't hardcode it.
Have i made a really trivial error or am i not understanding how these things work?
Thanks
Russell
|
|
|
|
|
i found an answer.
I assign the value of position() to a variable called pos and use
<xsl:value-of select="sum(../../staff/stat[$pos])"/>
and now it's working fine.
Russ
|
|
|
|
|
Hi,
I want to declare a variable or param at the top of my XSL file then I want to assign its value inside <for:each> loop and in the end I want to use its value outside the loop may be template as well. I tried my best but could not fix. anyone of you knows about it? Please send me sample code.
Greetings,
Abubakar
|
|
|
|
|
XSL variables don't work like those in a normal programming language. You can't increment inside a loop for example. The way around this is to use recursion and pass the final result up the stack. When it all completes your variable is then populated with the final result. But from that point on it's static.
<xsl:template match="/">
<xsl:variable name="myVariable">
<xsl:call-template name="forLoop">
<xsl:with-param name="counter" select="10" />
</xsl:call-template>
</xsl:variable>
</xsl:template>
<xsl:template name="forLoop">
<xsl:param name="counter" />
<xsl:choose>
<xsl:when test="$counter!=0">
<!-- do some work -->
<xsl:variable name="stackResult">
<xsl:call-template name="forLoop">
<xsl:with-param name="counter" select="$counter-1" />
</xsl:call-template>
</xsl:variable>
<!-- do something with the result of the recursion "$stackResult" -->
<!-- return a result up the stack -->
<xsl:value-of select="new value" />
</xsl:when>
<xsl:otherwise>
<!-- return something to indicate you've reached the base case w/in the recursion -->
<xsl:value-of select="some value" />
</xsl:otherwise>
</xsl:choose>
</xsl:template>
|
|
|
|
|
Hi,
I don't want to increment in the value of param or variable. I just want to check in >for:each< loop that if records exists then make param value 'true' otherwise set it false. I just wanna do this and later want to use its value outside the loop may be template as well. I tried my best but could not fix. anyone of you knows about it? Please send me sample code.
Greetings,
Abubakar
|
|
|
|
|
Can you post an xml fragment and a snippet of what it is you're trying to do? Then it would be easier to provide you with an answer that suits your needs.
|
|
|
|
|
I am getting values from webservice and using xsl file to format it. hereby I am sending u xsl file code. I just want that
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:param name="ID"></xsl:param>
<xsl:param name="searchString"></xsl:param>
<xsl:template match="Category">
<xsl:for-each select="./Clip">
<xsl:choose>
<xsl:when test="Title = $searchString or ./MetaData/ArticleName = $searchString">
<!-- Set value of a param to 'true' which means record Found -->
</xsl:when>
<xsl:otherwise>
<!-- Set value of a param to 'false' which means record not Found -->
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
<!--Make a check here whether record found or not -->
<xsl:if test="$paramName='true'">
// do something
</xsl:if>
<xsl:if test="$paramName!='true'">
// do something else
</xsl:if>
</xsl:template>
</xsl:stylesheet>
|
|
|
|
|
Try this, it should return true or false:
<xsl:variable name="paramName" select="Clip[Title=$searchString] or Clip/MetaData[ArticleName=$serachString]" />
Then you should be able to use the value like in your example above.
|
|
|
|
|
i ma usin gthe extension object in XSLT and then passing a string to XSLT like this
for(int i=0;i<xmlnode.count;i++)
{
xmlattributecollection="" xmlattrc="xmlnode[i].Attributes;
"
="" all="" +="<br>" ;
=""
}
return="" all;
and="" then="" using="" it="" in="" xslt="" like="" this
<xsl:value-of="" select="RDisc:GetAllData()">
but is showing data in one line also included the how i can solve this. I have also tried as
all +=<br>
I love .NET
|
|
|
|
|
i am fetching some data from SQL and filling it through the Adapterto in DataSet, and then passing that DataSet to the XmlDataDocument Object, like
XmlDataDocument XMLDoc = new XmlDataDocument(dsOrders);
and then again i take SqlDataAdapteradapter2 with new Query and again fill the same Dataset. means there are now two results, resulted by 2 queries
XMLDoc.DataSet.EnforceConstraints = false;
and then i am accessing that data through XSLT and exporting it as Excel,
when i access the data of the First query in XSLT it shows the required result but it also repeat the rows for the seocnd result,
like suppose there are total 7 rows in out put 3 are for first query and 4 are for 2nd query and i need the print only first 3 [of first query] but it displays thw hwole 7, first 3 showing results but last 4 with no values.
why it is repeating.
I love .NET
|
|
|
|
|
Hi All,
Which option is good to use to increase the perfomance in xslt programming.
For-each
or
apply templates
Can any body guide me giving some tips of perfomance tuning in xslt.
Pls show me the right way...
Thanks,
RPM.
SoftwareDeveloper(.NET)
|
|
|
|
|
The XSL Elements, xsl:for-each and xsl:apply-templates, performance is not that important in my honest opinion. I use xsl:for-each for simple processing requirements, and xsl:apply-templates for more demanding functional processing. Overuse of xsl:for-each will complicate your code and make it harder to debug. Also, there are some things you cannot do with xsl:for-each but you can do with xsl:apply-templates.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|