|
Hi,
I have the following code, which picks up 43 different nodes from my
XML document
XmlNodeList amortNodes = amortDoc.SelectNodes("//
TValueAmortizationSchedule/AmortizationLine");
each node looks like this:
<AmortizationLineType>8</AmortizationLineType>
<Date>09/01/2006</Date>
<Loan1Amount>100000000</Loan1Amount>
<Loan2Amount></Loan2Amount>
<Loan3Amount></Loan3Amount>
<Payment1Amount></Payment1Amount>
<Payment2Amount></Payment2Amount>
<Payment3Amount></Payment3Amount>
<InterestAccrued>0</InterestAccrued>
<InterestPaid>0</InterestPaid>
<PrincipalPaid>0</PrincipalPaid>
<UnpaidInterestBalance>0</UnpaidInterestBalance>
<PrincipalBalance>100000000</PrincipalBalance>
<TotalBalance>100000000</TotalBalance>
<RateChangeRate></RateChangeRate>
<RateChangeCompounding>13</RateChangeCompounding>
Now I am trying to loop through the node list to get get the nodes
with AmortizationLineType = 8
foreach (XmlNode amortNode in amortNodes)
{
amortType = amortNode.SelectSingleNode("//AmortizationLine/
AmortizationLineType").InnerText;
if (amortType.Equals("8"))
{
count++;
...........
}
}
Now I know from my debugging, that not all 43 nodes fulfil this
criteria (ie amortType=8). However, when I run this application, the
amortType always comes back as 8 (which is the value on only the first node), which
seems to tell me it is not picking up the values after that? Any ideas?
Thanks for your help.
|
|
|
|
|
The problem is the XPath expression passed to the SelectSingleNode method. The double slash at the beginning causes the selection of all nodes in the document from the current node that match the selection no matter where they are, so you're always selecting the first of the AmortizationLineType elements of all AmortizationLine elements. Try using the following XPath expression amortNode.SelectSingleNode("./AmortizationLineType") instead.
"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
|
|
|
|
|
Hello all,
I want to use XML to store some data in an app I'm writing. I've always used Access and DB programming prior to this but want to learn XML. Have a very limited knowledge of XML and would like to do some basic DB stuff like;
1) Read data in.
2) Modify it.
3) Write it back out (as needed)
Any help would be appreciated.
I've googled and have found a lot but unable to find anything simple and straight forward.
Thanks,
Mike
If you can't find time to do it right the first time how are you going to find time to do it again?
|
|
|
|
|
If you want to learn about XML and related technologies, I suggest visiting this site W3 Schools[^]
To work with XML in .NET you have to deal with the classes in the System.Xml namespace. Take a look at their documentation and the continuative links that contain many useful explainations. You can start with the XmlDocument , XmlReader and XmlWriter classes.
"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
|
|
|
|
|
Stefan,
Thank you very much for the info. W3 looks like a very good resource site!
Thanks,
Mike
If you can't find time to do it right the first time how are you going to find time to do it again?
|
|
|
|
|
Does anyone know how I can serialize a StringDictonary to XML? Failing that, is there another structure that I can use that is serializable? I'm trying to use WSRF.Net but my code gets halted as the structures are I use are not serializable.
I want to do so without having to use long complicated code and multi-dimensional string arrays.
My thanks in advance.
|
|
|
|
|
The StringDictionary has the SerializableAttribute , so you should be able to use the XmlSerializer in order to serialze or deserialize instances of the class to or from a XML document, respectively.
"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
|
|
|
|
|
I know that, but this is where it gets frustrating.
StringDictionary implements the IDictonary interface and the serializer aborts saying classes implementing that interface are not supported yet.
|
|
|
|
|
WiseHacker wrote: StringDictionary implements the IDictonary interface and the serializer aborts saying classes implementing that interface are not supported yet.
So I guess you have to do it on your own. Should not be to hard using the XmlTextWriter and XmlTextReader classes. Simply iterate over the dictionary and use the appropriate WriteXX or ReadXX methods to store or retrieve each dictionary entry. The resulting XML could look like that:
<dictionary>
<entry>
<key>key1</key>
<value>value1</value>
</entry>
<entry>
<key>key2</key>
<value>value2</value>
</entry>
...
</dictionary>
"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
|
|
|
|
|
How do i remove this attribute xmlns="" (blank namespace) from my XMLDocument
-- modified at 10:57 Monday 19th March, 2007
|
|
|
|
|
Hi Guys,
I have html tags in XSL in encoded format like "<:>:" (I am writing wrong myself), I want to implement these tags in browser. if anyone of you have solution or example please let me know I am struglling to fix it for last one week but still couldn't able to do it.
I can see tags <> in browser but in "View Source" they are still in "<:>:"
This is my second post but still haven't got any answer yet.
Regards,
Abubakar
|
|
|
|
|
good day...
i'm new to wml and wmlscript. i use nokia toolkit and its emulator to design a site. i want to know what are the requirements and procedure so i could display my wap site on mobile phones.
thank you in advance.
p.s. please forgive me if i didn't place my message on the correct section. i just thought that wml is xml-based that's why i post it in this section.
|
|
|
|
|
i have a XML file and need to update its data into MYSQL database. I using vb.net. How to i need to write it ?
Best regards,
Chee ken
|
|
|
|
|
I'm creating a XmlDocument from string, when I'm calling Load method I get an exception: Illegal characters in path.
Any suggestions?
thanks in advance
|
|
|
|
|
It would be very helpful to see the code you're talking about.
"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
|
|
|
|
|
shouldn't you be using loadXML ?
Russ
|
|
|
|
|
If he really want to get xml form string not from file - yes.
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
Hello.
I need to insert MS Word and MS Excell documents directly into html file. I use <object> tag for these perposes. Everything is ok and the whole documents can be viewed in IE through html file. But the problem is that these documents can not be printed currently from html file!
One possible reason is that version of server(office) to print these OLE objects must be exatly the same as the version of office they were created in.
Is there are any others ways to create printable html (or xml) document with office OLE objects inside?
|
|
|
|
|
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.
|
|
|
|