I looking for get query result from sqldatasource by C#
because I want to custom something from query result and apply it to graph
some thing like this
How to built "getQueryResult(sqlDataSource1);"
I don't know how to get query result from sqldatasoce
Thank for your response
because I want to custom something from query result and apply it to graph
some thing like this
public class GraphItem{ public string name { get; set; } public double value { get; set; } public GraphItem(string name, double value) { this.name = name; this.value = value; }}private void chart1_NeedDataSource(object sender, EventArgs e){ //Prepare graph value List<GraphItem> graphItemList = getQueryResult(sqlDataSource1); //Plot Graph Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender; Telerik.Reporting.Chart defChart = (Telerik.Reporting.Chart)procChart.ItemDefinition; defChart.IntelligentLabelsEnabled = false; ChartSeries serie = new ChartSeries(); serie.Type = ChartSeriesType.Pie; serie.Clear(); serie.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels; foreach (GraphItem lst in graphItemList) { ChartSeriesItem item = new ChartSeriesItem(); item.YValue = (double)lst.value; item.Name = (string)lst.name; item.Appearance.Exploded = true; item.Label.TextBlock.Text = (string)lst.name + " - #%"; serie.Items.Add(item); } defChart.Series.Clear(); defChart.Series.Add(serie);}How to built "getQueryResult(sqlDataSource1);"
I don't know how to get query result from sqldatasoce
Thank for your response