xml- GetElementsByTagName

[EDN Admin]

<pre class="prettyprint <DataSets>
<DataSet Name="Station
<Query>
<DataSourceName>DataSource1</DataSourceName>
<QueryParameters>
<QueryParameter Name="@NTUSERID
<Value>=Parameters!NTUSERID.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandType>StoredProcedure</CommandType>
<CommandText>RepServices.usp_test_station</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="stnnum
<DataField>stnnum</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>[/code]
I am trying to get the Query Parameters,CommandType,command text
I am able to get the command text but do not know how to get the rest of the data:
<pre class="prettyprint lang-vb Dim node As XmlNode = xmlReportDoc.DocumentElement.SelectSingleNode("/rss:Report/rssataSets/rssataSet[@Name=" + row("Report_Param") + "]", nsmgr)
Dim str As String = Nothing

rptParams = xmlReportDoc.GetElementsByTagName("CommandText")


If Not node Is Nothing Then
str = node.InnerText
End If


For Each item As System.Xml.XmlElement In rptParams
Console.WriteLine(item.InnerText)
str = item.InnerText
Response.Write(str)
Next
[/code]
<br/>
<span style="font-size:small <span style="font-size:small Can anyone help me?
<
RJ
<br/>

View the full article