XPath Request

[SD]

Hi,

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

<GetRoleCollectionFromUser
xmlns=\"http://schemas.microsoft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826\" Name=\"Reader\" Description=\"....\"
Type=\"2\" />
<Role ID=\"1073741827\" Name=\"Publisher\" Description=\"....\"
Type=\"3\" />
<Role ID=\"1073741828\" Name=\"Administrator\" Description=\"....\"
Type=\"1\" />
</Roles>
</GetRoleCollectionFromUser>

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

// load the complete XML node and all its child nodes into an
// XML document
XmlDocument Document = new XmlDocument();
string strXmlNodeToQuery = "<GetRoleCollectionFromUser xmlns=....";
Document.LoadXml(strXmlNodeToQuery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamespacePrefix = "d";
const string DirectoryNamespaceURI =
"http://schemas.microsoft.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
XmlNamespaceManager NamespaceMngr = new
XmlNamespaceManager(Document.NameTable);
NamespaceMngr.AddNamespace(DirectoryNamespacePrefi x,
DirectoryNamespaceURI);

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

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

Any ideas ?

Thanks

Best regards

SD

[Martin Honnen]

SD wrote:

<GetRoleCollectionFromUser
xmlns=\"http://schemas.microsoft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826\" Name=\"Reader\" Description=\"....\"
Type=\"2\" />
<Role ID=\"1073741827\" Name=\"Publisher\" Description=\"....\"
Type=\"3\" />
<Role ID=\"1073741828\" Name=\"Administrator\" Description=\"....\"
Type=\"1\" />
</Roles>
</GetRoleCollectionFromUser>

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

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

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

string strXmlNodeToQuery = @"<GetRoleCollectionFromUser
xmlns=""http://schemas.microsoft.com/sharepoint/soap/directory/"">
<Roles>
<Role ID=""1073741826"" Name=""Reader"" Description=""....""
Type=""2"" />
<Role ID=""1073741827"" Name=""Publisher"" Description=""....""
Type=""3"" />
<Role ID=""1073741828"" Name=""Administrator"" Description=""....""
Type=""1"" />
</Roles>
</GetRoleCollectionFromUser>";

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

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

Document.LoadXml(strXmlNodeToQuery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamespacePrefix = "d";
const string DirectoryNamespaceURI =
"http://schemas.microsoft.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
XmlNamespaceManager NamespaceMngr = new
XmlNamespaceManager(Document.NameTable);
NamespaceMngr.AddNamespace(DirectoryNamespacePrefi x,
DirectoryNamespaceURI);

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

Console.WriteLine("Founds {0} node(s).", xnRolesList.Count);

If you change the XPath expression to use the spelling "Administrator"
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.Count" is always equal to 0.

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

>

SD wrote:

><GetRoleCollectionFromUser
xmlns=\"http://schemas.microsoft.com/sharepoint/soap/directory/\">
<Roles>
<Role ID=\"1073741826\" Name=\"Reader\" Description=\"....\"
Type=\"2\" />
<Role ID=\"1073741827\" Name=\"Publisher\" Description=\"....\"
Type=\"3\" />
<Role ID=\"1073741828\" Name=\"Administrator\" Description=\"....\"
Type=\"1\" />
</Roles>
</GetRoleCollectionFromUser>

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

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

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

string strXmlNodeToQuery = @"<GetRoleCollectionFromUser
xmlns=""http://schemas.microsoft.com/sharepoint/soap/directory/"">
<Roles>
<Role ID=""1073741826"" Name=""Reader"" Description=""....""
Type=""2"" />
<Role ID=""1073741827"" Name=""Publisher"" Description=""....""
Type=""3"" />
<Role ID=""1073741828"" Name=""Administrator"" Description=""....""
Type=""1"" />
</Roles>
</GetRoleCollectionFromUser>";

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

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

Document.LoadXml(strXmlNodeToQuery);

// namespaces used by SharePoint and
// choosen prefix
const string DirectoryNamespacePrefix = "d";
const string DirectoryNamespaceURI =
"http://schemas.microsoft.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
XmlNamespaceManager NamespaceMngr = new
XmlNamespaceManager(Document.NameTable);
NamespaceMngr.AddNamespace(DirectoryNamespacePrefi x,
DirectoryNamespaceURI);

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

Console.WriteLine("Founds {0} node(s).", xnRolesList.Count);

If you change the XPath expression to use the spelling "Administrator"
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.Count" 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/