Populate jQuery menu from database ASP.Net

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on May 06, 2012 02:20 AM
Forum: ASP.Net Web Forms
Answer: 2
Views: 5031

hi every one

i have jQuery menu in my page this is code

<ul class="sf-menu">
			<li class="current">
				<a href=Furniture.aspx">Furniture</a>
				<ul>
				
					<li class="current">

						<ul>
							<li class="current"><a href="Furniture.aspx">kitchen</a></li>
							<li><a href="Furniture.aspx">Electric</a></li>
							<li><a href=Furniture.aspx">Furniture</a></li>

						
						</ul>
					</li>

I want when user click one of item from menubar it go to Furniture.aspx and when it go to that page in furniture.aspx show my product related to that item i have Product table in my DB

Id	Code	Name	Description	H_name
1	1112	Iron	This is test	Electric
2	1113	Pot	This is test	Kitchen
3	1114	Chair	This is test	Furniture
4	1115	Laundry	This is test	Electric
5	1116	Container	This is test	Kitchen
6	1117	Sofa	This is test	Furniture

I want when user click on Kitchen from menubar in furniture.aspx show product that have H_name=Kitchen or if they click on Electric item from menubarin furniture.aspx show my product that have H_name=Electric

how i can do it?

thanks

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 3

Reply
ANSWER
User: Mudassar
Replied: on May 06, 2012 05:37 AM
Report

In the menu

<li><a href="Furniture.aspx?h_name=electric">Electric</a></li>

Then on page

string code = Request.Form["h_name"];

Now pass this code to database and get the items using following query

select * from products where h_name=@h_name

nedash

0 16

Reply
ANSWER
User: nedash
Replied: on May 09, 2012 01:53 PM
Report

ok i find problem

this is correct code

  
    protected void Page_Load(object sender, EventArgs e)

    {


       string Code = Request.QueryString["H_name"];
        SqlCommand _cmd = new SqlCommand("select * from House_p where H_name=@H_name ", _cn);

        
      _cmd.Parameters.AddWithValue("@H_name", Code);

      _cn.Open();
       SqlDataReader _dr = _cmd.ExecuteReader();
       if (_dr.HasRows)
       {
           DataList1.DataSource = _dr;
          DataList1.DataBind();

       }
      _cn.Close();

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Populate jQuery menu from database ASP.Net

Company

Explore

Follow us

Contact Us