This question is locked. New answers and comments are not allowed.
Hi,
Good evening.
I need some technical help Regarding the chart.
I want to pass string value in the select parameter.
Link referred
http://demos.telerik.com/aspnet-ajax/htmlchart/examples/drilldownchart/defaultcs.aspx
In design:
here we have used the select parameter as year which is
integer(in my code I wnt to use string like ‘Monday’ and ‘july 2014’ how can I
achieve this),
<asp:SqlDataSource
ID="SqlDataSource2"
runat="server"
ConnectionString="<%$
ConnectionStrings:TelerikConnectionString %>"
SelectCommand="SELECT
Sum(Revenue) as Rev, Quarter FROM Revenue WHERE Year=@Year GROUP BY
Quarter">
<SelectParameters>
<asp:Parameter Name="Year"></asp:Parameter>
</SelectParameters>
</asp:SqlDataSource>
Code behind:
Here I want to use the string value in the highlighted area as
mentioned above.Please help to fix this issue.
public
int Year
{
get
{
if (ViewState["Year"]
== null)
{
return 2003;
}
return (int)ViewState["Year"];
}
set
{
ViewState["Year"]
= value;
}
}
protected
void RadAjaxManager1_AjaxRequest(object
sender,
AjaxRequestEventArgs e)
{
string
seriesName =
RadHtmlChart1.PlotArea.Series[0].Name;
if
(seriesName ==
"Years")
{
Year = int.Parse(e.Argument);
SqlDataSource2.SelectParameters[0].DefaultValue
= Year.ToString();
RadHtmlChart1.PlotArea.XAxis.DataLabelsField
= "Quarter";
RadHtmlChart1.PlotArea.Series[0].DataFieldY
= "Rev";
RadHtmlChart1.PlotArea.Series[0].Name
= "Quarters";
RadHtmlChart1.DataSourceID
= "SqlDataSource2";
}
Thanks
& Regards
Mysoona