|
Hi,
I am populating DataSet from an XML Schema which has tables pointing to other tables.
All the Relations, column names, etc have been successfully retrieved in the DataSet.
But there is problem of nesting. Is there something I have to do to see that tables are nested properly. Like there is a column Call_Id that is added on it's own by the DataSet as it is a child table of Table Call.
Do I have to fill something in that for proper nesting of tables !?!
Any help would be highly appreciated !
Paul
|
|
|
|
|
Hi,
I am deriving a DataSet using ReadXMLSchema method from a XML Schema Definition file.
I want to fill values in the Tables of the Data Set. There are some Tables that are complex Types. How do I fill values in such columns.
For Ex:
Table A
-----Table B (Attributes: 1,2,3,4)
-----Table C (Attributes: Table D, complexType)
---------------Table D (Attributes: 1)
--------------------------Table E ((Attributes: 1,2)
B & C are child of A. D & E are child of C.
C only has one column which is a reference to Table D.
How do I fill the values for the column in Table C , which is Table D (complex type)?
Paul
|
|
|
|
|
Hi all,
Currently I am working on a template solution which transforms contents of a given section (which is in a xml format) with the help of preset XLST files assigned to those sections. The code goes something like this
/Default.aspx
<code>
.
.
.
.
// Get the sections data in XML format
string xmlData = DataLoader.GetSectionData(sectionName, sectionPath, articleId, pageNumber );
// Get that sections template file
string xslFile = Server.MapPath("/")+"Files\\Templates\\"+ templateFile +"\\Default.xsl";
System.IO.StringReader sr = new System.IO.StringReader(xmlData);
XPathDocument doc = new XPathDocument(sr);
XslTransform trans = new XslTransform();
trans.Load(xslFile);
//Transform it and output as HTML
XmlTextWriter writer = new XmlTextWriter(Response.Output);
writer.Formatting = Formatting.None;
trans.Transform(doc,null,writer);
/SectionData.xml
<Root>
<Article>
<Title>Wonders of life</Title>
<Content>
<!--
<u>Sometimes<u>, you wonder how a particular thing went wrong; < b>but most of the time</ b> you wonder how it worked at all
-->
</Content>
</Article></Root>
/SectionTemplate.xslt
.
.
.
<xsl:value-of select="/Root/Article/Title" />
<br />
<xsl:value-of select="/Root/Article/Content/comment()" disable-output-escaping="yes" />
.
.
.
What i expected of the tranformer was to spit the contents of the comment tag to the browser without any parsing/escaping so the html formatting of the given article can be maintained, but whatever is done (I even tried with copy-of xsl element to no effect) the output I get is like this in the article page (HTML VIEW of the generated code)
Wonders of life<br />
<u>Sometimes<u>, you wonder how a particular thing went wrong; <b>but most of the time</b> you wonder how it worked at all
I understand that we can accomplish this by embedding the html code inside CDATA section but that too didnt work out well. Any alternate suggestions are also welcome.
Thanking you
CreProDes
CreProDes
|
|
|
|
|
why are you putting your html in a comment
if you did not put it in a comment then you could use xsl:copy-of
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Hi,
thank you for the tip. actually previsouly i was having problems using the copy-of tag because the html generated by the client side editor was not perfectly xml compatible one, so i had to go to using the comment and stuff. but now iam making use of SgmlReader from gotdotnet.com and solved that issue as well. Thank you for posting.
Bye,
CreProDes
CreProDes
|
|
|
|
|
I am getting an XML record from a database and I needed to look up a value that it returns from another xml file. e.g.
< PATIENT_DATA>
...
<SERVICE_CODE>123</SERVICE_CODE>
...
</PATIENT_DATA>
i needed to cross reference the service_code field off of another XML file so that the transformed file can display the required SERVICE_CODE into something more meaningful such as "Radiology Services".
I am using an XSL file to format the XML into an HTML. The XML look up file consists of values such as
<root>
...
<key name="123" value="Radiology Services">
...
</root>
My question is how do i achieve this result. Do i have to include the xml file in the XSL file or is there a way to reference another file in the XSL.
Please note that I CANNOT pass more than one file to the xsl compiler. It has to be done in the XSL file.
|
|
|
|
|
|
|
|
I'm using an XML file to store user preferences, but I can't decide on what's the best format. The data would easily been stored in an INI file using sections, keys, and values, but I want to use XML instead. I'm come up with a couple of alternatives:
1.
<?xml version="1.0" encoding="utf-8"?>
<profile>
<section name="Some Section">
<key name="Some Key">Some Value</key>
<key name="Some Other Key">Another Value</key>
</section>
<section name="Some Other Section">
...
</section>
</profile>
2.
<?xml version="1.0" encoding="utf-8"?>
<profile>
<Some_Section>
<Some_Key>Some Value</Some_Key>
<Some_Other_Key>Another Value</Some_Other_Key>
</Some_Section>
<Some_Other_Section>
...
</Some_Other_Section>
</profile>
Which of these two would you choose and why? If you know of a better alternative, I'd love to hear it.
Thanks!
Alvaro
|
|
|
|
|
Out of those two, the first one. Easier to validate, also it's probably easier to enumerate/navigate via XPath, if that were an issue.
Generally, your XML element names should be drawn from a small set of fixed names, which is met by the first example.
HTH
Stuart Dootson
'Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p'
|
|
|
|
|
Yep, I was leaning toward the first one as well, although I originally wrote the code with the second format in mind. 
I'm just now barely getting my feet wet with XPath. I used it to retrieve the values for the second format using "section_name/key_name", which seemed pretty simple. For the first format, where attributes are involved, what's the proper XPath string I need? Also if you could provide a link or two that quickly gets me up to speed on the XPath basics, I'd appreciate it very much.
Thanks Stuart!
Regards,
Alvaro
Can I ask you a question?
|
|
|
|
|
To get a particular keys value, you'd use something like '//section[@name='section-name]/key[@name='key-name']/text()' - hmmm, doesn't look any easier, does it. I guess you're probably best going with what you've got - after all, you're not intending to exchange the data with any other application, are you?
The reason I tend to use the first form you presented was because I tend to parse the whole file using libxml2 - the platform I'm limited by doesn't have .NET or an up-to-date MSXML 
I'm not sure what the best starters guides to XPath are - I learnt it through learning XSLT from Michael Kay's XSLT reference book (published by Wrox).
Stuart Dootson
'Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p'
|
|
|
|
|
Hi,
I would strongly recommend that you get your basics right with XSL and XPath before jumping into the structure design, as knowing them even at a basic level would give you a clear idea about which is the easiest and efficient way to access and maintain your data.
I liked the following two articles from devshed, through which i learned abt those techs:
XSL - http://www.devshed.com/Server_Side/XML/XSLBasics/XSLBasics1/page1.html
XPath - http://www.devshed.com/Server_Side/XML/XPath/page1.html
All the best.
CreProDes
|
|
|
|
|
the choice depends on what you are trying to do with the xml.
if you want a very generic solution then the first is better.
however, if you want to have a very specific solution the second is better - for example by have different elements for different keys you can set up your xsd to be tighter...
also the second example is easier to understand (from a human point of view)
either way its going to be a {} war... so choose the one your prefer 
"When the only tool you have is a hammer, a sore thumb you will have."
|
|
|
|
|
Code along the lines of:
string value1 = currentNode.Attributes["value1"].Value;
However, if the Node does not contain an attribute named "value1", and exception would be thrown.
So, is there a way (without kludging with try..catch blocks) to determine if a given attribute exists for a node?
TIA
~Mike Stanbrook
|
|
|
|
|
IF NOT currentNode.Attributes.ItemOf("value1") IS NOTHING THEN
value1 = currentNode.Attributes.Item("value1")
END IF
|
|
|
|
|
There is an easier way by using XPath Queries.
...asuming you have an XMLDocument Open
Dim xNode As Xml.XmlNode = xDoc.SelectSingleNode("//Element[@Attribute='Value']")
If (Not IsNothing(xNode)) Then
'Do Something
End If
|
|
|
|
|
Are you sure this is easier/more efficient that the method previously suggested, especially given that the current element node is already known and sotred in a local variable?
~Mike Stanbrook
|
|
|
|
|
Hi ,
I want to create one xml document from a dataset where in some fields I am having null values.
can any one help me out?
thanks
|
|
|
|
|
Hey,
If you dont have values, xml generated from the dataset will be having blank values.
Let me know is this your problem ?
Regards
Sri
|
|
|
|
|
Hi ,
I have solved my problem .Actually if i am passing null values in dataset then it is not creating the xml element .
So instead of passing null i passed null string("").Then it worked fine for me .
Thanks
|
|
|
|
|
Hi,
I have solved my problem.
Actually if I am passing null values in dataset xml is not creating the xml element.
so instead of passing null I passed null string("").
After that it worked for me.
thanks
|
|
|
|
|
If u no of a site that can save me time, please send me the link.
I was wondering if u goes have an example on how I should build a lookup table for countries.
For a dropdownlist:
CountryName = "USA"
Value = 0
CountryName="Canada"
Value = 1
Should I change below the value to a an integer instead of text.
Say I want to build a lookup for sql server
Here is an example?
<countries>
<country>
<text>Canada
<value>Canada
<country>
<text>Afghanistan
<value>Afghanistan
<country>
<text>Albania
<value>Albania
<country>
<text>Algeria
<value>Algeria
<country>
<text>American Samoa
<value>American Samoa
<country>
<text>Andorra
<value>Andorra
<country>
<text>Angola
<value>Angola
<country>
<text>Anguilla
<value>Anguilla
<country>
<text>Antarctica
<value>Antarctica
<country>
<text>Antigua and Barbuda
<value>Antigua and Barbuda
<country>
<text>Argentina
<value>Argentina
<country>
<text>Armenia
<value>Armenia
<country>
<text>Aruba
<value>Aruba
<country>
<text>Australia
<value>Australia
<country>
<text>Austria
<value>Austria
<country>
<text>Azerbaijan
<value>Azerbaijan
<country>
<text>Bahrain
<value>Bahrain
<country>
<text>Bangladesh
<value>Bangladesh
<country>
<text>Barbados
<value>Barbados
<country>
<text>Belarus
<value>Belarus
<country>
<text>Belgium
<value>Belgium
<country>
<text>Belize
<value>Belize
<country>
<text>Benin
<value>Benin
<country>
<text>Bermuda
<value>Bermuda
<country>
<text>Bhutan
<value>Bhutan
<country>
<text>Bolivia
<value>Bolivia
<country>
<text>Bosnia and Herzegovina
<value>Bosnia and Herzegovina
<country>
<text>Botswana
<value>Botswana
<country>
<text>Bouvet Island
<value>Bouvet Island
<country>
<text>Brazil
<value>Brazil
<country>
<text>British Indian Ocean Territory
<value>British Indian Ocean Territory
<country>
<text>Brunei Darussalam
<value>Brunei Darussalam
<country>
<text>Bulgaria
<value>Bulgaria
<country>
<text>Burkina Faso
<value>Burkina Faso
<country>
<text>Burundi
<value>Burundi
<country>
<text>Cambodia
<value>Cambodia
<country>
<text>Cameroon
<value>Cameroon
<country>
<text>Cape Verde
<value>Cape Verde
...
|
|
|
|
|
I need something that correctly 'cleans' a string that exists in xml by removing all the & and other tags that translate into regular characters...
thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
