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
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();
}
}
Thanks,
Imdadhusen