ASP.NET AJAX MultiHandleSliderExtender - Slide by Year and Month
page 2 of 5
by Bryian Tan
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 28066/ 25

Getting Started

1.    Download AJAX Control Toolkit Release Notes - May 2009 Release

2.    Download Samples Environment for Chart Controls

3.    Here is the snapshot of the project solution explorer. You are welcome to download this demo.

Figure 2


Back-end Database

First, add a new column to the table, name it YearMonth and populate it with the concatenation of the Year and Month data. See figure 3. The original table is on the left. With this setup, we can easily select data within the desired year and month range from the table.

Figure 3

Use ROW_NUMBER function to generate row number for each row of the result set. Then we can use the row number to populate the slider range of values. The query shown below returns sixty two rows and this means that the slider range of values goes from one to sixty two. In other words we can set the minimum and maximum properties of the slider to one and sixty two respectively.

Figure 4


View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2023  |  Page Processed at 2023-06-09 3:37:00 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search