XML / XSL

You can directly read the xml file in DataSet using ds.ReadXML("xmlfilename.xml"); now you can get each Tag as Columns Best Regards, Chetan Patel

You need to know what the current node is since xsl:call-template does not change the current node. If the parent template matches with "/CallSequence/Call", then the current node is "Call". If the parent template matches with "/CallSequence", then the current node is "CallSequence"; you have access to the child nodes of CallSequence, and your xsl:for-each select would be "Call". "We make a living by what we get, we make a life by what we give." --Winston Churchill

Here is some sample code for XSLT Extension Object that I had playing around with recently: using namespace System; using namespace System::IO; using namespace System::Text; using namespace System::Xml; using namespace System::Xml::XPath; using namespace System::Xml::Xsl; public ref class ParseCdata { public: ParseCdata(String^ xmlText) : doc(gcnew XmlDocument) { doc->LoadXml(xmlText); } String^ GetCData(XPathNodeIterator^ nodes) { StringBuilder^ result = gcnew StringBuilder; while (nodes->MoveNext()) { XPathNavigator^ nodesNav = nodes->Current; String^ xpath = String::Format("/test/data[@id='{0}']", nodes->Current->GetAttribute("id", String::Empty)); XmlNodeList^ dataNodes = doc->SelectNodes(xpath); for each (XmlNode^ node in dataNodes) { for each (XmlNode^ child in node->ChildNodes) { if (child->NodeType == XmlNodeType::CDATA) result->AppendFormat("-!!!{0}!!!-", child->Value); } } } return result->ToString(); } private: XmlDocument^ doc; }; int main(array ^args) { String^ xmlText = "" "" " " ""; String^ xsltText = "" "" "" "\n" "\t\n" "\n" "" "" "" "" ""; StringReader^ strReader1; XmlReader^ xmlReader1; StringReader^ strReader2; XmlReader^ xmlReader2; try { strReader1 = gcnew StringReader(xsltText); xmlReader1 = XmlReader::Create(strReader1); XslCompiledTransform^ xslt = gcnew XslCompiledTransform; xslt->Load(xmlReader1); strReader2 = gcnew StringReader(xmlText); xmlReader2 = XmlReader::Create(strReader2); XPathDocument^ xml = gcnew XPathDocument(xmlReader2); XsltArgumentList^ xsltArgs = gcnew XsltArgumentList; ParseCdata^ cdata = gcnew ParseCdata(xmlText); xsltArgs->AddExtensionObject("urn:cdata-conv", cdata); xslt->Transform(xml, xsltArgs, Console::Out); } catch (Exception^ excp) { Console::WriteLine(excp->ToString()); } finally { if (xmlReader2 != nullptr) xmlReader2->Close(); if (strReade

Thanks very much u know I really appreciate this. I'll try and get hold of these books! Rocky You can't climb up a ladder with your hands in your pockets.

i got the solution tx Hardik Panchal

:laugh: Yeah and Google is culpable as well since they provide a perfectly usable Search Engine.

Thanks anyway :)

What do you mean? XPath is just a query. If you are talking about the resulting sequence or node set from an executed XPath query, what programming or mark-up language are you using? :~ "We make a living by what we get, we make a life by what we give." --Winston Churchill

You will need to display it as text. You will need to especially change "<" to "<"! Some other character combinations may give you trouble also. "We make a living by what we get, we make a life by what we give." --Winston Churchill

The ":" is used to add a namespace to an element, for example: <xsl:element/>, where xsl is the namespace. If you are not using ":" for this reason, it should not be embedded in an element. "We make a living by what we get, we make a life by what we give." --Winston Churchill

Thanks, I like that idea, but I've decided to go with a single collection of Field elements, all being output fields. The data source already provides input fields, so while RDL uses the extra indirection of mapping a set of report fields to data source fields, and then report elements, like textbox, to report fields, I don't need that. My 'report fields' are my output fields. I do not believe they are right who say that the defects of famous men should be ignored. I think it is better that we should know them. Then, though we are conscious of having faults as glaring as theirs, we can believe that that is no hindrance to our achieving also something of their virtues. - W. Somerset Maugham My New Blog

I find your post unclear. 1) Are you trying to generate a SQL statement using XSLT? if YES then... 2) as your data source for some of the SQL values you are using XML serialized from an object defined in Client.cs?

"We make a living by what we get, we make a life by what we give." --Winston Churchill

You're not checking the return value from CreateInstance(). What is it returning? --Mike-- Visual C++ MVP :cool: LINKS~! Ericahist | PimpFish | CP SearchBar v3.0 | C++ Forum FAQ Hungarian notation FTW

You already got an answer for this question in the C# forum (answer[^]). Instead of simply reposting the question in another forum, you should try to understand what you were told in the answer and work with that info. "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