Hi,
i am using jquery menu control from the following site
ASP.NET Dynamic XML Web Menu Control based on JavaScript[
^]
but i am unable to view the data my code is
SqlConnection cn = new SqlConnection(connectionstring);
string str = "SELECT FormID as menuid,FormName as name,ParentID as root,URL as url FROM FormsMaster";
SqlDataAdapter da = new SqlDataAdapter(str, cn);
DataSet ds = new DataSet();
da.Fill(ds);
ds.DataSetName = "menu";
ds.Tables[0].TableName = "menuitem";
StreamWriter xmlDoc = new StreamWriter(Server.MapPath("~//menudata.xml"), false);
ds.WriteXml(xmlDoc);
xmlDoc.Close();
DataSet dsMenu = new DataSet();
dsMenu.ReadXml(Server.MapPath("~//menudata.xml"));
WebMenu1.DataSource = dsMenu;
and xml file is also generating with the data but not displaying in the menu control .my xml data is
<menu>
<menuitem>
<menuid>1</menuid>
<name>a1</name>
<root>""</root>
<url />
</menuitem>
<menuitem>
<menuid>2</menuid>
<name>a2</name>
<root>""</root>
<url />
</menuitem>
<menuitem>
<menuid>3</menuid>
<name>a21</name>
<root>1</root>
<url>http:
</menuitem>
<menuitem>
<menuid>4</menuid>
<name>a211</name>
<root>1</root>
<url>http:
</menuitem>
</menu>
but for testing when i keep the xml data from the site given above it is getting
<menu>
'Level 0 nodes
<menuitem root="" name="Search Sites" menuid="1" />
<menuitem root="" name="Webmail Sites" menuid="2" />
<menuitem root="" name="DotNet Sites" menuid="3" />
'Level 1 Items
<menuitem root="1" name="Google" url="http://www.google.com">
menuid="11"/>
<menuitem root="1" name="Altavista" url="http://www.Altavista.com">
menuid="12"/>
'Level 1 Items
<menuitem root="2" name="Hot-mail" url="" menuid="21" />
'Level 2 Items
<menuitem root="21" name="Hotmail" url="http://www.hotmail.com">
menuid="211"/>
<menuitem root="21" name="MSN" url="http://www.MSN.com">
menuid="212"/>
<menuitem root="2" name="Yahoo" url="http://www.yahoo.com">
menuid="22"/>
<menuitem root="2" name="Rediff" url="http://www.rediff.com">
menuid="23"/>
'Level 1 Items
<menuitem root="3" name="Microsoft" url="http://www.Microsoft.com">
menuid="31"/>
<menuitem root="3" name="GotDotNet" url="http://www.GotDotNet.com">
menuid="32"/>
<menuitem root="3" name="CodeProject" url="http://www.CodeProject.com">
menuid="33"/>
<menuitem root="3" name="ASpdotnet" url="http://www.ASpdotnet.com">
menuid="34"/>
</menuitem></menuitem></menuitem></menuitem></menuitem></menuitem></menuitem></menuitem></menuitem></menuitem></menu>
please help me as if it is format problem