TreeView Control & XML

[shafiqm]

I am using TreeLevel controls and getting the following error

The data at the root level is invalid. Line 1, position 1.

Main Page
=======
<IE:TreeView ID="treePO" AutoPostBack="True" TreeNodeSrc="PO.aspx" Runat="Server" />


Po.aspx
======
cmd = New SqlCommand("dbo.sp_List_PO", conn)
cmd.CommandType = CommandType.StoredProcedure

cmd.Parameters.Add("@IN_Language", Session("Language"))
dst = New DataSet()
dst.ReadXml(cmd.ExecuteXmlReader(), XmlReadMode.Fragment)
dst.DataSetName = "TREENODES"
dst.WriteXml(Response.OutputStream)

Stored Proc - SQL
Select Text , TreeNodeSrc from PO As TreeNode for XML auto, XMLDATA


Please guide
Shafiq

[Phil Weber]

What is the XML returned by your stored proc?

[shafiqm]

XML returned is valid. I am exactly copying the following example.

http://www.superexpert.com/default.aspx?id=186


<?xml version="1.0" standalone="yes" ?>
- <TREENODES>
<TreeNode Text="Beverages" TreeNodeSrc="products.aspx?catid=1" />
<TreeNode Text="Condiments" TreeNodeSrc="products.aspx?catid=2" />
<TreeNode Text="Confections" TreeNodeSrc="products.aspx?catid=3" />
<TreeNode Text="Dairy Products" TreeNodeSrc="products.aspx?catid=4" />
<TreeNode Text="Grains/Cereals" TreeNodeSrc="products.aspx?catid=5" />
<TreeNode Text="Meat/Poultry" TreeNodeSrc="products.aspx?catid=6" />
<TreeNode Text="Produce" TreeNodeSrc="products.aspx?catid=7" />
<TreeNode Text="Seafood" TreeNodeSrc="products.aspx?catid=8" />
</TREENODES>

Thanks
Shafiq

[oupoi]

Remove '<?xml version="1.0" standalone="yes" ?>'.

The example you provide from http://www.superexpert.com/default.aspx?id=186 gives the answer.
Try 'Listing 13 - Categories.aspx using VB.NET' and view the xml source . :o