Download AJAX Control
Toolkit Release Notes - May 2009 Release
Environment for Chart Controls
Here is the snapshot of the project solution explorer. You are welcome
to download this demo.
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.
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.