|
hello guys,
I am reading xml file and showing in grid in c# but now i want to read specific record(node) of that xml file like where clouse in sqlserver
Example
<Root>
<Data id="1" Name="aaa" Phone="852963" Gender="Male" />
<Data id="2" Name="bbb" Phone="123456789" Gender="Female" />
<Data id="3" Name="ccc" Phone="987654" Gender="Male" />
<Data id="3" Name="ddd" Phone="7676767" Gender="Male" />
</Root>
i need to read the first(TOP)id record and who's Gender="male".
how to do this
Regards
Shafiq
|
|
|
|
|
Try Bipin Joshi's book "Beginning XML with C# 2008" by Apress. I think thats there.
~GER
Ger
|
|
|
|
|
|
Here is the Answer!
XmlDocument xmlDoc =new XmlDocument;
xmlDoc.Load("C:\MyXml");
string myXPath="/Root/Data[@Gender='Male']";
XmlNodeList NodeList=xmlDoc.SelectNodes(myXPath);
XmlNode xmlNod=NodeList(0);
Int myId=xmlNod.Attributes("id").Value;
Cheers! 
|
|
|
|
|
It would be much better if you use XQuery or LINQ which has the same querying pattern like that of SQL. But i am still in the learning phase, so once i get a good hold in it, i shall write my answer.
|
|
|
|
|
XPath is easy to use, uses a hierarchical syntax and is available in many languages.
LINQ is far more flexible, but is .NET-centric.
|
|
|
|
|
hi i am new to xml but i wrote the xml file using xml writer . but the header information is not oming properly. i need the output like this.
<Class xmlns:tns="http://www....." xmlns:xsi="http//...." xsi:text="http://www......">
|
|
|
|
|
Hi All,
I am creating xsd files by using Datasets in my application. I have three datasets, when I create them using dt.WriteXMLSchema, all three datasets are cerating xsd with same class name inside. When I include them in my application its giving me error that same functions are defined.
Is there any way to resolve this problem so that all three xsd should come with their own table names or different names. Here the class names should come differently than "NewDatset".
Any links or any suggestion would be great helpfull. Thanks in advance.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
Hi All,
I got it done it was simple, just name the dataset with proper name that you want and create the xsd, it will create for you.
But if anybody is having idea of creating the relationships on the xsd as such in the database. If anybody has this idea please help me out by giving links or any suggestions.
It would be great and helpfull for me.
Please help me out. Thanks in advance. In this mean time I will google the things.
Thanks & Regards,
Md. Abdul Aleem
NIIT technologies
|
|
|
|
|
Is there any way I can get the information I'm using from an xml source to be updated while the program is running?
|
|
|
|
|
Hi,
if your source is an xml file, you could use the FileSystemWatcher[^]-class.
Register for the event of modification and reread the file if the event triggers.
Regards
Sebastian
|
|
|
|
|
[edit]nvm, got it.
modified on Thursday, August 26, 2010 4:27 AM
|
|
|
|
|
Im stuck and need help.. 
I using the following code to attempt to format a decimal number into £1000.99 for example
<pre>
<fo:table-cell>
<fo:block>
<xsl:value-of select='format-number(".//AmountPaid","#.00")' >
</fo:block>
</fo:table-cell>
</pre>
sample of the XML file is below
<ClaimsHistory>
<LossDate>26/12/2006</LossDate>
<OR>0.0000</OR>
<TypeOfLoss>HA</TypeOfLoss>
<LossDescription>Fire</LossDescription>
<Status>C</Status>
<AmountPaid>41414.4900</AmountPaid>
</ClaimsHistory>
as you can see Im trying to convert the 41414.49 into £41414.90 but all i get is NaN and im stuck can someone please point me in the right direction?
Thanks
Simon
As barmey as a sack of badgers
|
|
|
|
|
In
format-number(".//AmountPaid","#.00")
remove the quotes around .//AmountPaid - with quotes, it won't get interpreted as an XPath expression,rather as a string
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
can anyone tell me how to append xsl output to a file which already has some lines of data.
the quieter u become more u hear
|
|
|
|
|
Get your XSL processor to output to a string and append the string to the existing file
Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p
CodeProject MVP for 2010 - who'd'a thunk it!
|
|
|
|
|
XML Schema-
<?xml version="1.0"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://www.w3schools.com"
xmlns="http://www.w3schools.com"
elementFormDefault="qualified">
<xs:element name="note">
<xs:complexType>
<xs:sequence>
<xs:element name="to" type="xs:string"/>
<xs:element name="from" type="xs:string"/>
<xs:element name="heading" type="xs:string"/>
<xs:element name="body" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
XML referencing XML Schema-
<?xml version="1.0"?>
<note xmlns="http://www.w3schools.com"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="note.xsd">
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>
I want to know if in xml file I use xsi:noNamespaceSchemaLocation attribute then what elements or attributes should remove from xml schema.
Also please explain
targetNamespace="http://www.w3schools.com"
xmlns="http://www.w3schools.com"
elementFormDefault="qualified"
in xml schema.
Thanks in adv.
|
|
|
|
|
Dear All,
I am facing a problem while using XSLT. My requiremnt is to read an "**.ini" file and display based on the XML value. But the problem is I am not able to get the path of "*.ini" file dynamically.
I tried Window.location of Javascript. But unfortunatly the javascript is not being "processed" by the XSLT.
<msxsl:script xmlns:msxsl="urn:schemas-microsoft-com:xslt" language="JavaScript" implements-prefix="dx">
<![CDATA[
function GetRecordFolder()
{
var paths = window.location.pathname;
…….
…….
}
]]>
Any other suggestions to solve this problem?
Regards,
Rathish P S
|
|
|
|
|
hi to all,
Is there any tool which validate or check an ODX xml file whether it is according to ASAM standard or not.
Plz suggest if anybody know..
Thanks in adv..
|
|
|
|
|
Hello to all,
I have already created this post before in C# section, but I am not able to solve that problem.Thats why I am again raising the same question.
Problem is , when I deserialize a valid xml with xsi:type attribute, it i.e. deserialization fails occurs.
Plz let me to know how this deserialization will process in C#.
Thanks in adv..
|
|
|
|
|
guys how to set global variable in xsl using javascript
and also tell me is there any get method and set method in xsl for declaring global variables and getting them back
the quieter u become more u hear
|
|
|
|
|
<tracerData>
<tracerBrand>Unknown</tracerBrand>
<tracerType>Weco 3DFT+</tracerType>
<tracerVersion>?</tracerVersion>
<binaries format="OMA">1C414E533D3030310D4A4F423D223F220D5354415455533D300D545243464D543D333B313030303B453B523B440D523D911B891B831B841B841B831B851B841B851B841B851B851B851B841B841B851B841B851B851B851B851B851B851B851B841B851B851B851B861B851B851B851B841B851B861B851B861B851B851B851B851B851B861B851B851B851B841B851B851B841B841B841B851B831B831B821B811B81FF1B80FFFEFCFAF9F7F7F5F4F3F2F1F0EFEFEDEEEDEDEDECEEEEEEF0EFEEEEEFEFF0F0F0F1F1F2F2F2F2F2F1F2F3F2F4F3F4F3F5F5F5F5F5F5F6F6F5F5F6F5F6F6F7F7F7F7F7F8F7F7F7F7F8F7F8F8F8F9F8F9F9F9F9F9F9FAF8FAF9F9FAFAF9FAFAFAFBFAFBFAFBFBFBFBFCFBFBFCFCFCFBFBFCFCFBFCFCFCFCFCFCFDFCFDFDFCFDFDFDFDFDFDFCFDFDFDFDFEFDFDFDFEFDFEFEFEFEFDFFFEFEFFFEFEFFFEFFFFFFFEFEFFFFFEFFFFFEFF1B80FFFE1B80FFFF1B80FF1B80FF1B80FF1B801B801B801B801B801B801B811B801B801B801B81FF1B811B801B801B811B801B801B811B801B811B811B811B811B801B811B811B811B821B811B811B821B811B821B821B811B821B821B811B811B821B821B811B821B821B821B821B821B821B821B831B821B821B831B831B821B831B831B831B831B831B831B831B831B831B831B831B831B831B831B841B841B831B841B841B841B841B841B841B841B851B841B851B851B841B851B851B841B841B851B851B851B851B851B861B851B851B861B861B861B861B861B871B861B871B861B871B871B861B861B871B871B871B871B871B881B871B881B881B881B891B881B891B891B891B891B8A1B881B891B891B891B8A1B891B8B1B8A1B8A1B8B1B8B1B8B1B8C1B8B1B8C1B8C1B8C1B8B1B8C1B8C1B8C1B8D1B8D1B8D1B8E1B8E1B8E1B8F1B8F1B8E1B8E1B8F1B8F1B8F1B8F1B901B911B911B911B8F1B901B911B911B921B921B921B931B921B921B911B911B911B901B8F1B8F1B8D1B8C1B8D1B8B1B8A1B8A1B871B881B871B851B841B841B821B801B811B811B80FFFFFFFEFDFEFDFDFDFCFDFDFDFCFCFCFDFCFCFCFCFCFCFDFCFDFDFDFDFEFDFCFDFDFDFDFDFEFEFDFEFEFFFEFFFEFEFDFEFFFEFEFFFEFF1B80FFFFFF1B801B80FEFFFFFFFF1B801B801B801B801B801B801B801B811B811B801B811B801B801B811B801B801B811B811B811B821B811B811B821B811B821B801B811B821B811B811B821B821B821B821B821B831B821B821B821B821B821B821B831B821B831B831B831B821B821B831B821B821B831B831B821B821B821B821B831B821B821B801B801B81FFFEFDFDFCFAF8F6F6F3F1F0EFEDEDEEEEEFEEEDEEEFEEF0EFF1F1EFF0F0F0F1F1F2F2F2F3F3F3F3F2F3F3F3F3F5F4F4F5F5F5F6F5F6F5F5F6F5F6F6F7F6F7F7F8F7F8F8F8F8F7F7F8F8F8F8F9F8F9FAF9F9F9FAF9FAFAF9FAFAF9FAFAFAFAFAFBFBFBFAFBFBFCFBFBFCFCFCFCFCFCFBFDFCFDFBFCFDFCFCFDFCFDFCFDFDFDFDFDFDFDFEFEFDFEFEFDFEFDFDFEFEFDFEFEFEFEFEFEFEFFFEFEFFFFFFFEFFFEFEFFFFFEFFFFFE1B80FFFFFFFFFF1B80FFFF1B801B80FF1B801B801B801B801B801B801B801B801B811B801B801B811B801B801B801B811B801B811B801B811B801B811B811B801B811B811B811B811B811B821B811B811B821B811B821B821B821B811B821B821B821B811B821B821B811B821B821B821B821B821B831B821B821B831B831B821B831B831B831B831B831B831B831B841B831B841B831B831B831B831B841B831B841B831B841B841B841B841B841B851B841B841B851B851B841B851B851B861B851B841B851B841B851B861B851B851B861B851B861B861B861B861B871B861B861B871B871B871B871B871B861B871B871B871B871B871B881B881B881B871B891B881B891B891B891B891B881B891B891B881B891B8A1B8A1B891B8A1B8B1B8B1B8A1B8B1B8B1B8B1B8A1B8B1B8B1B8B1B8C1B8C1B8C1B8C1B8C1B8B1B8C1B8C1B8C1B8B1B8B1B8B1B8C1B8A1B8B1B8A1B8A1B881B871B851B841B841B841B831B841B831B831B821B821B831B821B811B821B811B811B821B821B811B811B811B821B811B811B821B821B811B821B811B811B811B821B821B811B821B821B811B811B821B821B811B821B821B821B821B831B821B821B821B811B821B821B821B831B831B821B831B821B821B831B821B821B831B821B831B831B841B831B841B821B831B821B841B831B831B831B841B831B841B841B841B841B831B831B841B841B841B841B841B800D523D1B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B801B800D5A464D543D333B3235303B453B523B440D5A3D0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000D5A464D543D333B3235303B453B4C3B440D5A3D0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000D5A54494C543D302E30303B302E30300D464352563D302E30303B302E30300D434952433D3134302E32343B302E30300D48424F583D35312E31333B35312E31330D56424F583D32372E38353B32372E38350D1E4352433D353337</binaries>
</tracerData>
|
|
|
|
|
tgbd1970 wrote: How to Convert XML to Image File,thanks
Usually by writing a program.
It's time for a new signature.
|
|
|
|
|
Hi all,
Please suggest me how to convert a word document to xsl/xslt (.doc file to xsl file). Please provide me some sample code or URL from where I can do this using C# 2.0 without using any third party tools.
Below is sample template document, in this Date, Name, Age, Address are merge field. I have to convert this template document to XLS.
<Date>
<Name>, <Age>
<Address>
Dear <Dr./Mr./Ms. Last Name>:
Below is the sample XLS for above template. (We created this manually)
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format"
xmlns:ibex="http://www.xmlpdf.com/2003/ibex/Format">
<xsl:template match="InvitationContemplateInfo">
<fo:block margin-left="0.785in" margin-top="0.7in" margin-right="0.88in" color="gray" font-family="'Times New Roman'" font-size="11.5pt" letter-spacing="0.15pt"><xsl:value-of select="//Date"/>
<xsl:if test="//Name[. != '']"> <xsl:value-of select="//Name"/></xsl:if>
<xsl:if test="//Age[. != '']"> <xsl:value-of select="//Age"/></xsl:if>
</fo:block>
</xsl:template>
</xsl:stylesheet>
Like this we have to create for all different kind of template documents dynamically.
Thanks in advance.
Know is Drop, Unknown is Ocean
|
|
|
|
|
DO NOT CROSS POST, choose what you think is the best forum and stick with it.
Please follow this link[^] if you want to answer this question or take this thread further.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
