I try to filter/search in all nodes, but it does not work (no records):
XmlDataSource1.XPath = "NewDataSet/tbl_arenden_kw/@*[contains(.,'" + TextBox1.Text + "')]"
Do you have any ideas ?
Thanks in advance
Clas
"NewDataSet/tbl_arenden_kw//*[contains(.,'" + TextBox1.Text + "')]" - searches/filters elements located inside of tbl_arenden_kw elements
Search: "snow"
XmlDataSource1.XPath = "NewDataSet/tbl_arenden_kw//*[contains(.,'" + TextBox1.Text + "')]"
Result: No record, emty (I use a Repeater)
When I changed to:
XmlDataSource1.XPath = "NewDataSet/tbl_arenden_kw[contains(@arendetext, '" + TextBox1.Text + "']"
Result: A powerful......
Part of XML-file:
<NewDataSet>
<tbl_arenden_kw>
<rubrik_kw>WEATHER</rubrik_kw>
<rubrik_egen>Winter storm brings snow to Colorado mountains</rubrik_egen>
<arendetext>A powerful snowstorm that dropped up to 20 inches of snow in parts of Colorado</arendetext>
</tbl_arenden_kw>
</NewDataSet>
This do not work
XmlDataSource1.XPath = "NewDataSet/tbl_arenden_kw[contains(@*, '" + TextBox.Value + "']"
Or
XmlDataSource1.XPath = "NewDataSet/tbl_arenden_kw/@*[contains(.,'" + TextBox1.Text + "')]"
xsl:template
<xsl:for-each select="NewDataSet">
<xsl:element name="NewDataSet">
<xsl:for-each select="tbl_arenden_kw">
<xsl:element name="tbl_arenden_kw">
<
xsl:attribute name="rubrik_kw"><
xsl:attribute name="rubrik_egen"><
xsl:attribute name="arendetext">//tbl_arenden_kw[contains(arendetext, 'snow')] |
//tbl_arenden_kw matches all tbl_arenden_kw elements
use [] to restrict the selected nodes
the xpath contains function accepts only strings as a parameter, so if you want to 'search' multiple child-elements, the solution is to create an or-statement
e.g.
//tbl_arenden_kw[contains(arendetext, 'snow') or contains(rubrik_egen, 'snow')] |
XmlDataSource1.XPath = "//tbl_arenden_kw[contains(@arendetext, '" + TextBox1.Text + "') or contains(@rubrik_egen, '" + TextBox1.Text + "')]"
Thanks, The XML Man and Joost Ploegmaster for your help !
