Price list slider price for e-Commerce Website
Dynamic slider by using sqlserver , ajax , asp.net
Dynamic slider by using sqlserver , ajax , asp.net
create table prod(prodid int
identity(1,1),prodname varchar(100),price decimal(10,2))
insert into prod
values('Hamam',20)
insert into prod
values('Dhall',68)
insert into prod values('Axe',150)
select * from Prod
ajaxSlider.aspx
<%@
Page Language="C#" AutoEventWireup="true" CodeFile="ajaxSlider.aspx.cs" Inherits="ajaxSlider"
%>
<%@
Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit"
TagPrefix="asp"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@
Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit"
TagPrefix="asp"
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style
type="text/css">
.btn
{
background-color:
#033280;
color: White;
font-size:
12px;
font-weight:
bold;
}
.style1
{
height:
40px;
}
</style>
</head><body>
<form
id="form1"
runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:MultiHandleSliderExtender ID="multiHandleSliderExtender1" runat="server"
TargetControlID="TextBox1"
BehaviorID="multiHandleSliderOne" Minimum="1" Maximum="100"
BoundControlID="TextBox2"
Steps="5" Length="100" TooltipText="{0}">
</asp:MultiHandleSliderExtender>
<table width="600" cellpadding="0" cellspacing="0" align="center">
<tr>
<td colspan="2"><b>Single slider
Extender</b></td>
</tr>
<tr>
<td height="40">Select price to be search</td>
<td style="padding-left:10px;"><asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox></td>
</tr>
<tr>
<td height="40">Selected Value</td>
<td style="padding-left:10px;"><asp:TextBox ID="TextBox2"
runat="server"></asp:TextBox></td>
</tr>
<tr>
<td height="40" align="center" colspan="2"><asp:Button ID="Button1"
runat="server"
Text="Search" CssClass="btn" onclick="Button1_Click" /></td>
</tr>
<tr>
<td height="40" align="center" colspan="2">
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
ajaxSlider.aspx.cs
using System;
using
System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using
System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public partial class ajaxSlider : System.Web.UI.Page
{
SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString.ToString());
SqlCommand sqlcmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
protected void
Page_Load(object sender, EventArgs e)
{
}
protected void
Button1_Click(object sender, EventArgs e)
{
sqlcon.Open();
sqlcmd = new
SqlCommand("select
* from prod where price between 0 and " + TextBox2.Text, sqlcon);
da = new
SqlDataAdapter(sqlcmd);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
sqlcon.Close();
}
}
#SradhaWebCreations
Contact : +91-9040573923, +91-7008182025
http://sradhawebcreations.com/
http://sradhawebcreations.blogspot.in/
https://facebook.com/sradhawebcreations
https://www.facebook.com/Sradhawebeducation/
No comments:
Post a Comment