如何为项目符号列表onclick事件编写代码: [英] how to write coding for bulleted list onclick event:

问题描述

任何人都可以更正此代码:

在项目符号列表中，我有
1.低于Rs.500/-
2.Rs.500至Rs.1000/-

如果我单击任何一个，它将加载pro_id，价格.
在我的代码中无法加载详细信息...
好吧.或为此提供的代码.





编码:

Can Anyone correct this code:

in bulleted list i have
1.Below Rs.500/-
2.Between Rs.500 to Rs.1000/-

if i click any one it will load pro_id,price of it.
in my code can"t load detail...
ple crt it. or giv code for that.





coding:

protected void BulletedList3_Click(object sender, BulletedListEventArgs e)
    {
        price_range = BulletedList3.Items[e.Index].Value;
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
        SqlCommand cmd = new SqlCommand("select pro_img,pro_name,price from product where price = ''" + price_range + "'' and status=''A'' and type=''retail'' ", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DataList1.DataSource = ds;
        DataList1.DataBind();
        con.Close();
    }

推荐答案

纳玛莎

请在以下链接上查看我的答案:

根据tha的 asp.net代码选定范围? [

Hi,
Narmatha

Please check my Answer on following link:

asp.net code for display product according to tha selected ranges?[^]

Please do let me know, if you have any doubt

CODE:
.ASPX

<asp:BulletedList ID="blPriceRange"  runat="server"

           onclick="blPriceRange_Click" DisplayMode="LinkButton">
           <asp:ListItem Text="500" Value="Price = 500"></asp:ListItem>
           <asp:ListItem Text=">500" Value="Price > 500 AND Price < 1000"></asp:ListItem>
           <asp:ListItem Text=">1000" Value="Price > 1000 AND Price < 2000"></asp:ListItem>
           <asp:ListItem Text=">2000" Value="Price > 2000 "></asp:ListItem>
       </asp:BulletedList>

.ASPX.CS

.ASPX.CS

protected void blPriceRange_Click(object sender, BulletedListEventArgs e)
  {
      string filterCriteria = blPriceRange.Items[e.Index].Value;
      string SQLQuery = "SELECT * FROM Products WHERE " + filterCriteria;
      DataTable dt = new DataTable();
      dt = DB.ExecuteNonQuery(SQLQuery);
      if (dt.Rows.Count > 0)
      {
          GridView1.DataSource = dt;
          GridView1.DataBind();
      }
  }

谢谢，
Imdadhusen

Thanks,
Imdadhusen

这篇关于如何为项目符号列表onclick事件编写代码:的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！