asked on

asp menu

hey guys i am building a menu from data base

here my code

<asp:Menu ID="mnu" runat="server" MaximumDynamicDisplayLevels="10" CssSelectorClass="myMenu" Orientation="Horizontal" OnMenuItemClick="mnu_MenuItemClick">
<DataBindings>
<asp:MenuItemBinding DataMember="MenuItem" TextField="Text" ToolTipField="ToolTip" NavigateUrlField="NavigateUrl" ValueField="Id" />
</DataBindings>
</asp:Menu>

the problem i am having the when i populate a node NavigateUrl == "" they is a problem?

the click method on my menu keep refreshing my page when the url coloum in my table is null.

please help me change that to nothing if the NavigateUrl is empty to #

here my view source code of my page

<div class="myMenu" id="ctl00_mnu">
	<div class="AspNet-Menu-Horizontal">
			<ul class="sf-menu">
				<li class="sf-with-ul">
					<a href="javascript:__doPostBack('ctl00$mnu','b1')" class="sf-menu-link" title="PRODUCTS">
						PRODUCTS</a>
					<ul style="visibility:hidden; display:none;">
						<li class="sf-with-ul">
							<a href="javascript:__doPostBack('ctl00$mnu','b1\\2')" class="sf-menu-link" title="Industrial / Domestic Gases">
								Industrial / Domestic Gases</a>
							<ul style="visibility:hidden; display:none;">
								<li class="sf-leaf">
									<a href="javascript:__doPostBack('ctl00$mnu','b1\\2\\183')" class="sf-menu-link" title="Industrial Gases">
										Industrial Gases</a>
								</li>
								<li class="sf-leaf">
									<a href="javascript:__doPostBack('ctl00$mnu','b1\\2\\184')" class="sf-menu-link" title="LP / Domestic Gases">
										LP / Domestic Gases</a>
								</li>
							</ul>
						</li>
						<li class="sf-with-ul">
							<a href="javascript:__doPostBack('ctl00$mnu','b1\\3')" class="sf-menu-link" title="Welding Machines / Torches /Spares">
								Welding Machines / Torches /Spares</a>
							<ul style="visibility:hidden; display:none;">
								<li class="sf-with-ul">
									<a href="javascript:__doPostBack('ctl00$mnu','b1\\3\\7')" class="sf-menu-link" title="MIG Welding Machines">
										MIG Welding Machines</a>
									<ul style="visibility:hidden; display:none;">
										<li class="sf-leaf">
											<a href="product.aspx?name=migmax-210-amp-/-220v-inverter-type&amp;category=mig-welding&amp;id=1" class="sf-menu-link" title="Migmax 210 amp / 220v Inverter type">
												Migmax 210 amp / 220v Inverter type</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=migmax-255-/-220v-(inverter-type)&amp;category=mig-welding&amp;id=2" class="sf-menu-link" title="Migmax 255 / 220v (Inverter type)">
												Migmax 255 / 220v (Inverter type)</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=mig-welder-250-amp-/-380v&amp;category=mig-welding&amp;id=3" class="sf-menu-link" title="Mig Welder 250 amp / 380v">
												Mig Welder 250 amp / 380v</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=mac022a&amp;category=mig-welding&amp;id=4" class="sf-menu-link" title="MAC022A">
												MAC022A</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=mac023&amp;category=mig-welding&amp;id=5" class="sf-menu-link" title="MAC023">
												MAC023</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=mac024&amp;category=mig-welding&amp;id=6" class="sf-menu-link" title="MAC024">
												MAC024</a>
										</li>
										<li class="sf-leaf">
											<a href="product.aspx?name=mac032&amp;category=mig-welding&amp;id=7" class="sf-menu-link" title="MAC032">
												MAC032</a>
										</li>

Open in new window

rajeeshmca

Hi,

While you retrieve from the Database, just make the null values to # like...

Select Isnull(NavigateUrl, '#') from tablename

Regards
Rajeesh

JCWEBHOST

ASKER

i tried that

select id, parent_id, title ,Isnull(url, '~/#') from menu

but none of my links are working

ASKER CERTIFIED SOLUTION

Roopesh Reddy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial