how to bind data table with 3 columns to asp .net pie chart

Question

0.00/5 (No votes)

See more:

Hi experts,

I have a data table like
Name   percentahe   count
xxx    10%         1
yyy    40%       4

I wanted to bind name and percentage column to asp .net pie chart
as x and y value member and count column i wanted to show as tooltip of pie chart
presently am not able to bind the 3rd column

Plz help me
thanks in advance
(Keerthi Kumar)

Posted 10-Apr-14 23:02pm

Keerthi Kumar(Andar)

Updated 10-Apr-14 23:37pm

v2

Add a Solution

Comments

Naz_Firdouse 11-Apr-14 6:03am

you mean to say you want to display count in tooltip and others are working fine?

Keerthi Kumar(Andar) 11-Apr-14 6:07am

that count column values i want to show on tool tip on mouse over of each block

Keerthi Kumar(Andar) 11-Apr-14 6:05am

ya.

2 solutions

Solution 1

try this
http://www.intertech.com/Blog/create-asp-net-4-0-pie-chart-with-tooltips/[^]

Posted 11-Apr-14 0:12am

Naz_Firdouse

Comments

Keerthi Kumar(Andar) 11-Apr-14 6:22am

thanks a lot for ur answer. but this is not the solution

Naz_Firdouse 11-Apr-14 6:28am

any issues with that?

Keerthi Kumar(Andar) 11-Apr-14 7:09am

ya... that is not the answer which i want.

Keerthi Kumar(Andar) 11-Apr-14 7:10am

and also explanation is not sufficient

Naz_Firdouse 11-Apr-14 7:13am

provide the code you have tried so that we can help you

Keerthi Kumar(Andar) 15-Apr-14 0:53am

Sir ...the datatable dt contains the columns exactly as i mensioned above

Naz_Firdouse 11-Apr-14 7:13am

without looking at the code, its difficult to explain

Keerthi Kumar(Andar) 15-Apr-14 0:52am

//PieChart.DataSource = dt;
//PieChart.Series["Series1"].ChartType = SeriesChartType.Pie;
//PieChart.Series["Series1"].LegendText = "#VALX";
//PieChart.Series["Series1"].Label = "#VALY" + "%";
//PieChart.Series["Series1"].ToolTip = "#VALX #VALY{e}" + "%";

//PieChart.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//PieChart.Legends[0].Enabled = true;
//PieChart.DataBind();
//PieChart.Titles.Add("Popular Services for the month :" + DateTime.Now.ToString("MMMM") + " " + DateTime.Now.ToString("yyyy"));

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)

Naz_Firdouse · Accepted Answer · 2014-04-14T21:03:00

This works fine for me
In aspx; I have the following code

ASP.NET

<chart:chart id="Chart1" runat="server" xmlns:chart="#unknown">
           <series>
               <chart:series name="Series1"></chart:series>
           </series>
           <chartareas>
               <chart:chartarea name="ChartArea1"></chart:chartarea>
           </chartareas>
       </chart:chart>

C#

DataTable dt = new DataTable();

 dt.Columns.Add(new DataColumn("Value1"));
 dt.Columns.Add(new DataColumn("Value2"));
 dt.Columns.Add(new DataColumn("Value3"));
 for (int i = 1; i <= 5; i++)
 {
     dt.Rows.Add("Hi" + i, 12*i, "Tooltip"+i);
 }

 Chart1.Series[0].XValueMember = "Value1";
 Chart1.Series[0].YValueMembers = "Value2";
 Chart1.Series[0].YValuesPerPoint = 5;
 Chart1.Series[0].ChartType = SeriesChartType.Pie;
 //Chart1.Series[0].ToolTip = "#VALY";
 Chart1.DataSource = dt;
 Chart1.DataBind();

 for(int cnt=0; cnt<chart1.series[0].points.count;cnt++>            {
     Chart1.Series[0].Points[cnt].ToolTip = dt.Rows[cnt]["Value3"].ToString();
 }