xpath filter in xmldatasource control

[arst06d]

hi

I have an xml document as follows:

<?xml version="1.0" encoding="utf-8" ?>

<accounts>
  <account number="999999" type="Account" name="account name" ccy="GBP" balance="100.36" />
  <account number="888888" type="Account" name="account name2" ccy="GBP" balance="-999.36" />
  <account number="123456" type="CARD" name="Card name" ccy="GBP" balance="-258.99" />
</accounts>

Can someone priovide the syntax for the xpath property if I just want to show nodes where the type attribute is "Account"?

(is it just me, or is the MS help documentation pretty difficult to find anything helpful in ....?)

cheers

David

 

[jbenson001]

You would probably get a quicker response if you post this in the XML forum:

forum426

JIm

 

[arst06d]

Hi

I thought this was a better forum as it deals specifically with asp.net and I'm using the xmldatasource server control. I'll stick with this post rather than raise a dupe (for a while, anyway ...)

Anyway, here's what I have so far

<asp:XmlDataSource 
   ID="XmlDataSource1" 
   runat="server" DataFile="~/Accounts/Accounts.xml"
   XPath="accounts/account[type] = 'Account'">
</asp:XmlDataSource>

I get an error saying the expression must evaluate to a nodeset - so obviously have it wrong!

 

[arst06d]

My fault - had the ] in the wrong place

       <asp:XmlDataSource 
        ID="XmlDataSource1" 
        runat="server" 
        DataFile="~/Accounts/Accounts.xml" 
        XPath="accounts/account[@type='Account']" >
       </asp:XmlDataSource>