Dropdown selected value should show the required data in dotnetcharting drilldown

Question

0.00/5 (No votes)

See more:

, +

Hi I am working on dotnetCharting Drildown and wile choosing year from the dropdown the selected year details should come on my chart.

What I have tried:

C#

<pre>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
using System.Drawing.Drawing2D;
using dotnetCHARTING;
using System.Configuration;
using System.Data.SqlClient;

namespace dotnetdrilldown03
{
    public partial class DrillDropdown : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Chart.DefaultSeries.ConnectionString = ConfigurationManager.ConnectionStrings["sqlconnection"].ConnectionString;
            if (!IsPostBack)
            {
                Bindddl();
            }
                Chart.YAxis.Label.Text = "No of Students";
                Chart.Title = "Progress Report";
                Chart.XAxis.Label.Text = "Years";
                Chart.Width = 750;
                Chart.Height = 550;
                Chart.Debug = true;
                Chart.DateGrouping = TimeInterval.Years;
                Chart.DrillDownChain = "Years,Quarters,Months,Full";
                Chart.DefaultSeries.DefaultElement.ToolTip = "%yvalue";
                Chart.Series.Name = "Bonus points";
                Chart.Series.StartDate = new System.DateTime(2014, 1, 1, 0, 0, 0);
                Chart.Series.EndDate = new System.DateTime(2017, 12, 31, 23, 59, 59);
                Chart.Series.SqlStatement = @"SELECT Duration,Total FROM Report WHERE Duration >= #STARTDATE#  ";

                Chart.SeriesCollection.Add();
            
        }

        protected void Bindddl()
        {
            Ddldrill.Items.Add("2014");
            Ddldrill.Items.Add("2015");
            Ddldrill.Items.Add("2016");
            Ddldrill.Items.Add("2017");
            if (Request.QueryString["limitMode"] != null)
                Ddldrill.SelectedIndex = (int)Enum.Parse(typeof(dotnetCHARTING.LimitMode), Request.QueryString["limitMode"], true);
            Chart.Series.LimitMode = (dotnetCHARTING.LimitMode)Enum.Parse(typeof(dotnetCHARTING.LimitMode), Ddldrill.SelectedItem.Value, true);
            Ddldrill.DataBind();
            Ddldrill.Items.Insert(0, new ListItem("--Select--"));

            if (Ddldrill.SelectedItem.Value = "")
            { 
            
            }
        }

        protected void Ddldrill_SelectedIndexChanged(object sender, EventArgs e)
        {
            Bindddl();
        }
        dotnetCHARTING.SeriesCollection Calculate()
        {
            dotnetCHARTING.SeriesCollection SC = new dotnetCHARTING.SeriesCollection();
            Random myR = new Random(1);
            for (int a = 0; a < 4; a++)
            {
                dotnetCHARTING.Series s = new dotnetCHARTING.Series();
                s.Name = "Series " + a.ToString();
                for (int b = 0; b < 1; b++)
                {
                    Element e = new Element();
                    e.Name = "Element " + b.ToString();
                    e.YValue = myR.Next(20);
                    s.Elements.Add(e);
                }

                SC.Add(s);
            }
            SC[0].Element.Color = Color.FromArgb(49, 255, 49);
            SC[0].Elements[0].Name = "English";
            SC[0].LegendEntry.Value = "13";
            SC[0].LegendEntry.Name = "Between 10-15";
            return SC;
        }
    }
}

Posted 5-Mar-17 19:39pm

Member 12605293

Updated 5-Mar-17 20:31pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2017-03-05T20:31:00

ASP.NET has both code in the page and a code-behind. You are missing an important part to help resolve your issue - the .ASPX page. You question is not describing the symptoms - eg: my car won't start. What happens when you turn the key? I hear a noise? what noise? etc... Without details, it is anyone's guess!

Now, I am a MVC dev, not a Asp.Net WebPage dev, so it took me a few moments to adjust. So, here is my stab-in-the-dark guess: I think that you are missing a property on your DropDownList:

AutoPostBack="True"

causing the DropDownList selected event in the code-behind to not fire.

To demonstrate the DropDownList peforming as I think you want it to, here is a working example:

1. Page:

ASP.NET

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">

        <div class="col-md-4">
            <h2>DropDown Test</h2>
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"></asp:DropDownList>
            <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        </div>

</asp:Content>

2. Code-behind

C#

using System;
using System.Collections.Generic;
using System.Web.UI;

namespace WebApplication1
{
    public partial class _Default : Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                InitData();
            }

        }

        public List<string> Options { get; set; }
        private void InitData()
        {
            Options = new List<string> { "AAA", "BBB", "CCC" };
            foreach (var item in Options)
            {
                DropDownList1.Items.Add(item);
            }
            DropDownList1.SelectedIndex = 0;
            SetLabel();

        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            SetLabel();
        }

        private void SetLabel()
        {
            Label1.Text = DropDownList1.SelectedItem.Text;
        }
    }
}