|
Thank George,
I know how to create a xsl now. but how can we bind it to the existing xml file?
Donkaiser
|
|
|
|
|
I am assuming you are using C# 2.0. My example above shows you how. Anyway, I will make a commented snippet:
// Sorting using XSLT
string xslt =
"<xsl:stylesheet version='1.0' " +
"xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>" +
"<xsl:template match='/ | @* | node()'>" +
"<xsl:copy>" +
"<xsl:apply-templates select='@* | node()'>" +
"<xsl:sort select='Title'/>" +
"</xsl:apply-templates>" +
"</xsl:copy>" +
"</xsl:template>" +
"</xsl:stylesheet>";
XslCompiledTransform xct = new XslCompiledTransform(); // The XSLT Compiler/Transformer
StringReader strXslStr = new StringReader(xslt); // Create a XmlReader stream using a string source (the string = XSLT)
XmlReader rdrXsl = XmlReader.Create(strXslStr);
xct.Load(rdrXsl); // the XSLT Transformer reads the XSLT and compiles it.
rdrXsl.Close(); // Closing Streams
strXslStr.Close();
XPathNavigator xpnav = doc.CreateNavigator(); // Create the XPathNavigator from a XmlDocument Object
StringBuilder sbXml = new StringBuilder(); // Create a XmlWriter stream with a StringBuilder output buffer
XmlWriter sortedXml = XmlWriter.Create(sbXml);
xct.Transform(xpnav, sortedXml); // The actual transformation of the XML using the above XSLT document
doc.LoadXml(sbXml.ToString()); // The Transformed XML output is in the StringBuilder object.
sortedXml.Close(); // Close the stream.
|
|
|
|
|
Sroun Ngo wrote: Any suggestion will be great.
ok, then....
Sroun Ngo wrote: I assume
Don't make assumptions. 
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
Hi All,
Could any one please provide me with the sample or example code for updating the data of XML files to MS Access database tables.?, Actually i need to make a vc++ dll which can read all xml files in a particular directory and update the data to coresponding table in MS Access database, I couldn't find any useful information on INTERNET or any articles for the same, if somebody have programmed a code for such a functionality, please help vc++ guru's!!..Thanks in Advance.!
Regards,
princenrj23
____________
|
|
|
|
|
nrj23 wrote: I couldn't find any useful information on INTERNET or any articles for the same
You are not likely to find code or an article providing you with a complete solution. However if you recursively break the overall problem domain down to it's constituent parts you will find samples and details of those smaller problems.
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
Dude what i am confused with is, how to open all xml files one by one from a single directory, parse the file and how do i know which element is to be updated to which column of which table(MS-Access Database)??, i am newbee to xml and vc++???, what is surprising to me is that there is no single tutorial or example code for this on internet?? dude if you have done such a programming in past plz post something useful?. It will be a great help...Thanks in Advance!!
|
|
|
|
|
There is nothing new in your second post. Please go back and read mine again. If there is anything in my post that you don't understand please tell me, specifically, and I will try to clarify it.
nrj23 wrote: dude if you have done such a programming in past plz post something useful?
I will be glad to help you with specific questions about a small parts of your code, one at a time, that you have a question about. So far I see no code from you.
I am not going to write your program for you and post it so you can copy and paste it into your solution. If you think that is how programming works you are headed in the wrong direction already.
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
I agree with led mike. You have several issues here without any example code displayed.
Nevertheless, I am assuming you are using native C++ and not Managed C++ or C++/CLI. Thus,search using "MSXML C++" at http://www.google.com/microsoft to find basic information on how to use the MSXML COM object. You will need to learn how to parse an XML document to obtain the data to place in the Access database (the table's columns should correspond with the XML document's element or attribute names).
Also, you may need to know how to update an Access database via native C++ code. You might want to search on the above site using 'OLEDB C++". There are some ATL OLEDB attributes that will make your programming efforts easier.
So, come back later and ask some specific questions. If they are more C++ related, you might get better results posting in the C++ forum.
|
|
|
|
|
Hi,
I tried to read XML data from a string. Suppose that I get a string like this:
<root><node1>567</node1><node2>Andbf</node2></root>.
I want to get the data contained within the xml elements. A little help can be useful. Thanks
Do your best to be the best
|
|
|
|
|
assign the string to a xmldocument and u can pass thro the nodes easily
eg:
string s= // your xmlstring here
XmlDocument doc = new XmlDocument();
doc.innerXml = s;
sathy
|
|
|
|
|
This works:
XmlDocument doc = new XmlDocument();
doc.LoadXml("<item><name>wrench</name></item>");
-- modified at 8:34 Tuesday 16th May, 2006
|
|
|
|
|
How do you save data from a form in C# to XML?
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
System.Xml.XmlDocument.Save( string filePath)
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
|
I have an xsd (One of the elements in it is defined by an xs:enumeration). This xsd will change from time to time. So, my code should work even when the xsd changes.
My Tasks (on a winform):
1. Build a dataset from xsd (easily achieved ds.ReadXmlSchema("sample.xsd"))
2. Bind a datagrid to this dataset (dataGrid1.DataSource = ds.Tables[0])
3. Display a combobox in the column (which defined by an enum in the xsd) and display the enum values in the combo box(Problem)
I am looping through the columns of the datatable and trying to figure out if it was defined by an xs:enumeration in the xsd. During runtime, I can see that ds.Tables[0].Columns[2].SimpleType.enumeration contains the list of enumerator values. But, I am unable to figure out how to get to it during design time.
It would really if someone could tell me how to determine if a datacolumn is supposed to be taking only enumeration values provided in the xsd, and how to get access to these values so I can bind them to a combobox
I really appreciate the time you took to reply to this post!
Extract from a Sample XSD defining three columns:
<my:element name="ID" type="xs:decimal" minOccurs="0"/>
<my:element name="StartDate" type="xs:date" default="1990-01-01" minOccurs="0"/>
<my:element name="Employee">
<my:simpleType id="EmployeeName">
<my:restriction base="xs:string">
<my:enumeration value="Cinderella"/>
<my:enumeration value="Rupenzel"/>
<my:enumeration value="Black Beauty"/>
</my:restriction>
</my:simpleType>
</my:element>
|
|
|
|
|
My company uses XML received by email all the time to receive information from different sources everyday. I'm looking to improve the speed a little bit more as email has normally a delay. What's the best way to receive those forms? I created a webservice, however some of our providers do not want to spend the time building a solution. I would like something I can provide to them in order to received those forms.
Any ideas?
Al
My eMail control
My Blog
|
|
|
|
|
Hard to say what is "best" when you don't have all the information. Here is a wild guess. If you have a Web Server you could supply a web page that allows the user to Upload the file to your server.
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
Or really splash the cash and invest in biztalk...
|
|
|
|
|
No doubt. However I was guessing that his concern about the time lag was due in large part to the SMTP lag that sometimes occurs. Biztalk would have no effect on that.
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
Hello,
I tried searching the net but I couldn't find this info... Does an xs:time attribute have an upper limit? Like, maybe the maximum value is 23:59? or can it contain time values which are greater than 1000:00 ? This is for an attribute that is more of a duration time attribute than a date time attribute and I'm wondering whether I should use xs:time or xs:string instead.
Thanks,
~Rafferty
|
|
|
|
|
perhaps you could use xs:long and have the value be the duration in milliseconds?
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
I just found out that there's an xs:duration datatype. That'll work very well.
but just out of curiousity, does xs:time handle time values that is more than 24 hrs?
Thanks,
~Rafferty
|
|
|
|
|
Rafferty Uy wrote: does xs:time handle time values that is more than 24 hrs?
No. from the W3C[^]
[Definition:] '00:00:00', up to but not including '24:00:00'
(which is identical with '00:00:00' of the next day).
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
|
Hello, everybody. Sorry to disturb you all.
Currently, I have a speech recording and playback software developed by Microsoft Visual C++ 6.0. The software is used to train children with speech problem and scores will be calculated and showed at the end of each practice session. The software is able to record and playback real-time.
Children use this software at home and save their practice records in a single floppy disk. Then, children will bring the floppy disk with practice records inside when they return to our centre.
I have two problems with the xml programming part. My software automatically created history file (in XML format) to display the scores of the children’s practices. The history file (in XML format) is saved by the children in floppy disk when they return to our centre.
But, the data or information in the XML is in a mess where all data are put together. Do you mind to tell me what should I do to create more organized XML format? The therapist needs to scroll in order to read the scores. I have the program codes of XML in four of my cpp files.
The second question is how to call or open XML file (the history file) from my software?
My codes are as below. After I execute the program, it is error free and the File Open dialog box is popped up but no XML file came out after I select the desired XML file. My codes are as below:
void CSpeechDlg::OnScore() <br />
{<br />
CFileDialog openfile(TRUE,NULL,NULL,OFN_OVERWRITEPROMPT,"XML File (*.xml)|*.xml|");<br />
if (openfile.DoModal()==IDOK)<br />
{<br />
CString cs=openfile.GetFileName();<br />
char* filename=new char[cs.GetLength()+1];<br />
strcpy(filename,cs);<br />
}<br />
<br />
}<br />
I promise I wont disturb you a lot, I promise I will do my best. Can you please help me?
I am totally new to this as the software is written by one of my previous friend who worked together with me in a voluntary speech rehabilitation centre. We need this software to train children in the centre. I work part time there.
Hope you can give me some guidances on how to do it. I promise I can learn as independent as possible but I really need your guidance at this very beginning, please.
Please, I really appreciate all your help.
|
|
|
|
|
bella_11041988 wrote: The second question is how to call or open XML file (the history file) from my software?
From VC 6 you will want to use an XML library (parser). Probably the most widely used in VC 6 applications will be the MSXML library that is located in msxml(n).dll where "(n)" is the installed version on a given computer.
YOu can find many articles on using MSXML from VC++ on MSDN, CodeProject and many other sources.
Good luck.
"What classes are you using ? You shouldn't call stuff if you have no idea what it does"
Christian Graus in the C# forum
led mike
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
