XPath Request

[SD]

Hi,

How can i get all the nodes with attribute Name = "Publisher" or
Name="Administr ator" using XPath query and C# for this xml doc?

<GetRoleCollect ionFromUser
xmlns=\"http://schemas.microso ft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826 \" Name=\"Reader\" Description=\". ...\"
Type=\"2\" />
<Role ID=\"1073741827 \" Name=\"Publishe r\" Description=\". ...\"
Type=\"3\" />
<Role ID=\"1073741828 \" Name=\"Administ rator\" Description=\". ...\"
Type=\"1\" />
</Roles>
</GetRoleCollecti onFromUser>

i tried:
*****
// XPATH query used
string sQuery = "//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrateu r']";

// load the complete XML node and all its child nodes into an
// XML document
XmlDocument Document = new XmlDocument();
string strXmlNodeToQue ry = "<GetRoleCollec tionFromUser xmlns=....";
Document.LoadXm l(strXmlNodeToQ uery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamesp acePrefix = "d";
const string DirectoryNamesp aceURI =
"http://schemas.microso ft.com/sharepoint/soap/directory/";

// now associate with the xmlns namespaces (part of all XML
// nodes returned from SharePoint), a namespace prefix that
// we then can use in the queries
XmlNamespaceMan ager NamespaceMngr = new
XmlNamespaceMan ager(Document.N ameTable);
NamespaceMngr.A ddNamespace(Dir ectoryNamespace Prefix,
DirectoryNamesp aceURI);

// run the XPath query and return the result nodes
XmlNodeList xnRolesList = Document.Select Nodes(sQuery , NamespaceMngr);

it didn't work, my "xnRolesList.Co unt" is always equal to 0.

Any ideas ?

Thanks

Best regards

SD

[Martin Honnen]

SD wrote:

<GetRoleCollect ionFromUser
xmlns=\"http://schemas.microso ft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826 \" Name=\"Reader\" Description=\". ...\"
Type=\"2\" />
<Role ID=\"1073741827 \" Name=\"Publishe r\" Description=\". ...\"
Type=\"3\" />
<Role ID=\"1073741828 \" Name=\"Administ rator\" Description=\". ...\"
Type=\"1\" />
</Roles>
</GetRoleCollecti onFromUser>

string sQuery = "//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrateu r']";

it didn't work, my "xnRolesList.Co unt" is always equal to 0.

With your sample and your XPath expression for me one node is found,
complete code:

string strXmlNodeToQue ry = @"<GetRoleColle ctionFromUser
xmlns=""http://schemas.microso ft.com/sharepoint/soap/directory/"">
<Roles>
<Role ID=""1073741826 "" Name=""Reader"" Description="". ...""
Type=""2"" />
<Role ID=""1073741827 "" Name=""Publishe r"" Description="". ...""
Type=""3"" />
<Role ID=""1073741828 "" Name=""Administ rator"" Description="". ...""
Type=""1"" />
</Roles>
</GetRoleCollecti onFromUser>";

string sQuery =
"//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrateu r']";

// load the complete XML node and all its child nodes into an
// XML document
XmlDocument Document = new XmlDocument();

Document.LoadXm l(strXmlNodeToQ uery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamesp acePrefix = "d";
const string DirectoryNamesp aceURI =
"http://schemas.microso ft.com/sharepoint/soap/directory/";

// now associate with the xmlns namespaces (part of all XML
// nodes returned from SharePoint), a namespace prefix that
// we then can use in the queries
XmlNamespaceMan ager NamespaceMngr = new
XmlNamespaceMan ager(Document.N ameTable);
NamespaceMngr.A ddNamespace(Dir ectoryNamespace Prefix,
DirectoryNamesp aceURI);

// run the XPath query and return the result nodes
XmlNodeList xnRolesList = Document.Select Nodes(sQuery , NamespaceMngr);

Console.WriteLi ne("Founds {0} node(s).", xnRolesList.Cou nt);

If you change the XPath expression to use the spelling "Administra tor"
instead of "Administrateur " e.g.

string sQuery =
"//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrator ']";

then two nodes are found.

So your C# code seems correct, only you have not shown us whether you
really load the XML sample. And the XPath when looking for the Name
attribute value has a different spelling for the attribute value than
the XML sample has.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[SD]

Sorry,
it was just a translation error:
my real code contained :
string sQuery = "//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrator ']";
and my "xnRolesList.Co unt" is always equal to 0.

"Martin Honnen" <ma*******@yaho o.dea écrit dans le message de news:
Oi************* *@TK2MSFTNGP03. phx.gbl...

>

SD wrote:

><GetRoleCollec tionFromUser
xmlns=\"http ://schemas.microso ft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826 \" Name=\"Reader\" Description=\". ...\"
Type=\"2\" />
<Role ID=\"1073741827 \" Name=\"Publishe r\" Description=\". ...\"
Type=\"3\" />
<Role ID=\"1073741828 \" Name=\"Administ rator\" Description=\". ...\"
Type=\"1\" />
</Roles>
</GetRoleCollecti onFromUser>

> string sQuery = "//d:Role[attribute::Name ='Publisher' or
attribute::Nam e='Administrate ur']";

> it didn't work, my "xnRolesList.Co unt" is always equal to 0.

With your sample and your XPath expression for me one node is found,
complete code:

string strXmlNodeToQue ry = @"<GetRoleColle ctionFromUser
xmlns=""http://schemas.microso ft.com/sharepoint/soap/directory/"">
<Roles>
<Role ID=""1073741826 "" Name=""Reader"" Description="". ...""
Type=""2"" />
<Role ID=""1073741827 "" Name=""Publishe r"" Description="". ...""
Type=""3"" />
<Role ID=""1073741828 "" Name=""Administ rator"" Description="". ...""
Type=""1"" />
</Roles>
</GetRoleCollecti onFromUser>";

string sQuery =
"//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrateu r']";

// load the complete XML node and all its child nodes into an
// XML document
XmlDocument Document = new XmlDocument();

Document.LoadXm l(strXmlNodeToQ uery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamesp acePrefix = "d";
const string DirectoryNamesp aceURI =
"http://schemas.microso ft.com/sharepoint/soap/directory/";

// now associate with the xmlns namespaces (part of all XML
// nodes returned from SharePoint), a namespace prefix that
// we then can use in the queries
XmlNamespaceMan ager NamespaceMngr = new
XmlNamespaceMan ager(Document.N ameTable);
NamespaceMngr.A ddNamespace(Dir ectoryNamespace Prefix,
DirectoryNamesp aceURI);

// run the XPath query and return the result nodes
XmlNodeList xnRolesList = Document.Select Nodes(sQuery ,
NamespaceMngr);

Console.WriteLi ne("Founds {0} node(s).", xnRolesList.Cou nt);

If you change the XPath expression to use the spelling "Administra tor"
instead of "Administrateur " e.g.

string sQuery =
"//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrator ']";

then two nodes are found.

So your C# code seems correct, only you have not shown us whether you
really load the XML sample. And the XPath when looking for the Name
attribute value has a different spelling for the attribute value than the
XML sample has.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Martin Honnen]

SD wrote:

my real code contained :
string sQuery = "//d:Role[attribute::Name ='Publisher' or
attribute::Name ='Administrator ']";
and my "xnRolesList.Co unt" is always equal to 0.

I have posted complete code which gives 1 (or 2 if the XPath is
adapted). It does not help to post some snippets to a newsgroup claiming
it gives certain results and then later to say the real code is
different. Post minimal but complete real code.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/