• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

c# xpath queries

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    c# xpath queries

    does anybody know how to pass in more than a single parameter to an xpath query?

    i have...(hope ezboard leaves the code alone)

    cmd.CommandType = SqlXmlCommandType.XPath;
    cmd.RootTag = "ROOT";
    cmd.Namespaces= "xmlns:x ='urn:myschema:PersonDetails'";
    cmd.SchemaPath= absPath + "\\referralSchemaForUpdates.xsd";
    cmd.CommandText = "PersonDetails[@PersonID=\"_personid\"[PersonDetails/ReferralDetails[@ReferralId=\"_referralid\"]]";

    i need to pass two parms into the commandtext.

    #2
    Bug

    Looks like a little bug has crept into your code :x

    If only they were that easy to spot.

    I have not idea what the answer is.

    Try MSDN, Google or somewhere like experts exchange.

    Good luck.

    Comment


      #3
      Bug

      yes - that particular bug is 'by design'

      Comment


        #4
        Re: Bug

        LOL, ScotsPine, any chance you could give a few good reasons _why_ to use XML/XSLT for a query???

        Comment


          #5
          Re: Bug

          1. i'm tired of t-sql
          2. diffgrams and updategrams are fun
          3. schema/datasets/classes in c# are new
          4. xml is native in .net data objects
          5. it's fast
          6. it's the future
          7. it's portable
          8. it's scalable
          9. it's good with firewalls
          10. the client wants it!

          Comment


            #6
            Re: Bug

            Comment


              #7
              Re: Bug

              fixed

              Comment

              Working...
              X