Parsing Locally Registered SQL Server names XML file using Vb .Net -
i need retrieve names of locally registered ms sql servers stored in xml file. located @ "c:\users\xyz\appdata\roaming\microsoft\microsoft sql server\100\tools\shell\regsrvr.xml"
once retrieved, need populate these in combobox. using below code. not figure out tag use xml "m_xmld.selectnodes" code. advise appreciated.
if system.io.file.exists(regsrvrfile) dim m_xmld xmldocument dim m_nodelist xmlnodelist dim m_node xmlnode 'create xml document m_xmld = new xmldocument() 'load xml file m_xmld.load(regsrvrfile) 'get list of name nodes m_nodelist = m_xmld.selectnodes("/model/instances/document/data/registeredservers") end if end if
sample xml attached.
<?xml version="1.0"?> <model xmlns="http://schemas.serviceml.org/smlif/2007/02"> <identity> <name>urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1</name> <baseuri>http://documentcollection/</baseuri> </identity> <xs:bufferschema xmlns:xs="http://www.w3.org/2001/xmlschema"> <definitions xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"> <document> <docinfo> <aliases> <alias>/system/schema/registeredservers</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <xs:schema targetnamespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema" elementformdefault="qualified"> <xs:element name="registeredserversstore"> <xs:complextype> <xs:sequence> <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" /> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="servergroup"> <xs:complextype> <xs:sequence> <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" /> </xs:sequence> </xs:complextype> </xs:element> <xs:element name="registeredserver"> <xs:complextype> <xs:sequence> <xs:any namespace="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" processcontents="skip" minoccurs="0" maxoccurs="unbounded" /> </xs:sequence> </xs:complextype> </xs:element> <registeredservers:bufferdata xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"> <instances xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"> <document> <docinfo> <aliases> <alias>/registeredserversstore</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:registeredserversstore xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:servergroups> <sfc:collection> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/analysisservicesservergroup</sml:uri> </sfc:reference> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/centralmanagementservergroup</sml:uri> </sfc:reference> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri> </sfc:reference> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri> </sfc:reference> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/reportingservicesservergroup</sml:uri> </sfc:reference> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</sml:uri> </sfc:reference> </sfc:collection> </registeredservers:servergroups> </registeredservers:registeredserversstore> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/analysisservicesservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">analysisservicesservergroup</registeredservers:name> <registeredservers:servertype type="servertype">analysisservices</registeredservers:servertype> </registeredservers:servergroup> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/centralmanagementservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">centralmanagementservergroup</registeredservers:name> <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype> </registeredservers:servergroup> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/databaseengineservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:registeredservers> <sfc:collection> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</sml:uri> </sfc:reference> </sfc:collection> </registeredservers:registeredservers> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">databaseengineservergroup</registeredservers:name> <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype> </registeredservers:servergroup> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:registeredserver xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">mysqlserver\dbinstance</registeredservers:name> <registeredservers:servername type="string">mysqlserver\dbinstance</registeredservers:servername> <registeredservers:usecustomconnectioncolor type="boolean">false</registeredservers:usecustomconnectioncolor> <registeredservers:customconnectioncolorargb type="int">0</registeredservers:customconnectioncolorargb> <registeredservers:servertype type="servertype">databaseengine</registeredservers:servertype> <registeredservers:connectionstringwithencryptedpassword type="string">data source=mysqlserver\dbinstance;integrated security=true;pooling=false;multipleactiveresultsets=false</registeredservers:connectionstringwithencryptedpassword> <registeredservers:credentialpersistencetype type="credentialpersistencetype">persistloginname</registeredservers:credentialpersistencetype> </registeredservers:registeredserver> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/integrationservicesservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:registeredservers> <sfc:collection> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</sml:uri> </sfc:reference> </sfc:collection> </registeredservers:registeredservers> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">integrationservicesservergroup</registeredservers:name> <registeredservers:servertype type="servertype">integrationservices</registeredservers:servertype> </registeredservers:servergroup> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:registeredserver xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">mysqlserver</registeredservers:name> <registeredservers:servername type="string">mysqlserver</registeredservers:servername> <registeredservers:usecustomconnectioncolor type="boolean">false</registeredservers:usecustomconnectioncolor> <registeredservers:customconnectioncolorargb type="int">0</registeredservers:customconnectioncolorargb> <registeredservers:servertype type="servertype">integrationservices</registeredservers:servertype> <registeredservers:connectionstringwithencryptedpassword type="string">server=mysqlserver</registeredservers:connectionstringwithencryptedpassword> <registeredservers:credentialpersistencetype type="credentialpersistencetype">persistloginname</registeredservers:credentialpersistencetype> </registeredservers:registeredserver> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/reportingservicesservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">reportingservicesservergroup</registeredservers:name> <registeredservers:servertype type="servertype">reportingservices</registeredservers:servertype> </registeredservers:servergroup> </data> </document> <document> <docinfo> <aliases> <alias>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</alias> </aliases> <sfc:version domainversion="1" /> </docinfo> <data> <registeredservers:servergroup xmlns:registeredservers="http://schemas.microsoft.com/sqlserver/registeredservers/2007/08" xmlns:sfc="http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08" xmlns:sml="http://schemas.serviceml.org/sml/2007/02" xmlns:xs="http://www.w3.org/2001/xmlschema"> <registeredservers:parent> <sfc:reference sml:ref="true"> <sml:uri>/registeredserversstore</sml:uri> </sfc:reference> </registeredservers:parent> <registeredservers:name type="string">sqlservercompacteditionservergroup</registeredservers:name> <registeredservers:servertype type="servertype">sqlservercompactedition</registeredservers:servertype> </registeredservers:servergroup> </data> </document> </instances> </registeredservers:bufferdata> </xs:schema> </data> </document> </definitions> </xs:bufferschema> </model>
your query missing namespaces, , doesn't seem point node. try this:
dim xml string = "<?xml version=""1.0""?><model xmlns=""http://schemas.serviceml.org/smlif/2007/02""><identity><name>urn:uuid:96fe1236-abf6-4a57-b54d-e9baab394fd1</name><baseuri>http://documentcollection/</baseuri></identity><xs:bufferschema xmlns:xs=""http://www.w3.org/2001/xmlschema""><definitions xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08""><document><docinfo><aliases><alias>/system/schema/registeredservers</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><xs:schema targetnamespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema"" elementformdefault=""qualified""><xs:element name=""registeredserversstore""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><xs:element name=""servergroup""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><xs:element name=""registeredserver""><xs:complextype><xs:sequence><xs:any namespace=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" processcontents=""skip"" minoccurs=""0"" maxoccurs=""unbounded"" /></xs:sequence></xs:complextype></xs:element><registeredservers:bufferdata xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08""><instances xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08""><document><docinfo><aliases><alias>/registeredserversstore</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserversstore xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:servergroups><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/analysisservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/centralmanagementservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/reportingservicesservergroup</sml:uri></sfc:reference><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</sml:uri></sfc:reference></sfc:collection></registeredservers:servergroups></registeredservers:registeredserversstore></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/analysisservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">analysisservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">analysisservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/centralmanagementservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">centralmanagementservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/databaseengineservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:registeredservers><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</sml:uri></sfc:reference></sfc:collection></registeredservers:registeredservers><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">databaseengineservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/databaseengineservergroup/registeredserver/mysqlserver\dbinstance</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserver xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/databaseengineservergroup</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">mysqlserver\dbinstance</registeredservers:name><registeredservers:servername type=""string"">mysqlserver\dbinstance</registeredservers:servername><registeredservers:usecustomconnectioncolor type=""boolean"">false</registeredservers:usecustomconnectioncolor><registeredservers:customconnectioncolorargb type=""int"">0</registeredservers:customconnectioncolorargb><registeredservers:servertype type=""servertype"">databaseengine</registeredservers:servertype><registeredservers:connectionstringwithencryptedpassword type=""string"">data source=mysqlserver\dbinstance;integrated security=true;pooling=false;multipleactiveresultsets=false</registeredservers:connectionstringwithencryptedpassword><registeredservers:credentialpersistencetype type=""credentialpersistencetype"">persistloginname</registeredservers:credentialpersistencetype></registeredservers:registeredserver></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/integrationservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:registeredservers><sfc:collection><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</sml:uri></sfc:reference></sfc:collection></registeredservers:registeredservers><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">integrationservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">integrationservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/integrationservicesservergroup/registeredserver/mysqlserver</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:registeredserver xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore/servergroup/integrationservicesservergroup</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">mysqlserver</registeredservers:name><registeredservers:servername type=""string"">mysqlserver</registeredservers:servername><registeredservers:usecustomconnectioncolor type=""boolean"">false</registeredservers:usecustomconnectioncolor><registeredservers:customconnectioncolorargb type=""int"">0</registeredservers:customconnectioncolorargb><registeredservers:servertype type=""servertype"">integrationservices</registeredservers:servertype><registeredservers:connectionstringwithencryptedpassword type=""string"">server=mysqlserver</registeredservers:connectionstringwithencryptedpassword><registeredservers:credentialpersistencetype type=""credentialpersistencetype"">persistloginname</registeredservers:credentialpersistencetype></registeredservers:registeredserver></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/reportingservicesservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">reportingservicesservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">reportingservices</registeredservers:servertype></registeredservers:servergroup></data></document><document><docinfo><aliases><alias>/registeredserversstore/servergroup/sqlservercompacteditionservergroup</alias></aliases><sfc:version domainversion=""1"" /></docinfo><data><registeredservers:servergroup xmlns:registeredservers=""http://schemas.microsoft.com/sqlserver/registeredservers/2007/08"" xmlns:sfc=""http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08"" xmlns:sml=""http://schemas.serviceml.org/sml/2007/02"" xmlns:xs=""http://www.w3.org/2001/xmlschema""><registeredservers:parent><sfc:reference sml:ref=""true""><sml:uri>/registeredserversstore</sml:uri></sfc:reference></registeredservers:parent><registeredservers:name type=""string"">sqlservercompacteditionservergroup</registeredservers:name><registeredservers:servertype type=""servertype"">sqlservercompactedition</registeredservers:servertype></registeredservers:servergroup></data></document></instances></registeredservers:bufferdata></xs:schema></data></document></definitions></xs:bufferschema></model>" dim m_xmld xmldocument dim m_nodelist xmlnodelist dim m_node xmlnode 'create xml document m_xmld = new xmldocument() 'load xml file m_xmld.loadxml(xml) dim m_xmlnsmgr xmlnamespacemanager m_xmlnsmgr = new xmlnamespacemanager(m_xmld.nametable) m_xmlnsmgr.addnamespace("rs", "http://schemas.microsoft.com/sqlserver/registeredservers/2007/08") m_xmlnsmgr.addnamespace("sfc", "http://schemas.microsoft.com/sqlserver/sfc/serialization/2007/08") m_xmlnsmgr.addnamespace("sml", "http://schemas.serviceml.org/sml/2007/02") 'get list of name nodes m_nodelist = m_xmld.selectnodes("//rs:registeredserver", m_xmlnsmgr) each el in m_nodelist console.writeline(el.selectsinglenode("rs:servername", m_xmlnsmgr).innertext) next console.readkey()
this select registeredserver
nodes in "registeredservers" namespace, , loop through them servername
node in same namespace.
Comments
Post a Comment