asp.net pie chart  -> dynamic title from db?

Posted on 2014-03-07
Medium Priority
Last Modified: 2014-03-24
Hi  all,

I'm using the below asp.net vb.net pie chart code.  It's all fine except for two things:

1. How do i dynamically assign a field from the sql database to the title of the pie chart?  As you can see I have an X where I'd like a field called 'theDate' to be inserted, how do i do that?

2. the BackImage property is a transparent 1x1px gif...  however, when applied to the pie chart as below i only get a solid white background and not transparent as expected - any ideas why?

            <asp:Chart ID="Chart1" runat="server" Width="676px" Height="410px" 
                       BackImage="../img/spacer_clear.gif" BackImageTransparentColor="White" 
                    <asp:Series Name="Series1" ChartType="Pie" Legend="Legend1" XValueMember="name" YValueMembers="percent"></asp:Series>  
                    <asp:ChartArea Name="ChartArea1">
                            IsClustered="false" />
                        <AxisY IsLogarithmic="true" />
                           <asp:Legend Name="Legend1">
                           <asp:Title Name="Title1" Text="Chart Date: X">

Open in new window

Question by:ErinTheCoderGirl
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Author Comment

ID: 39914324
Any ideas in how I can assign a chart title from the database?
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39914368
which .Net Framework version?
LVL 83

Expert Comment

ID: 39914523
You can write code in code behind to get the field from DB and then use something like

Chart1.Titles(0).Text = Field
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 39915175
Hi, I'm using version 4.

Author Comment

ID: 39915555
Codecruiser - I'm not able to just implement that vague answer, do you have a link to an article I can reference and learn from?
LVL 83

Accepted Solution

CodeCruiser earned 2000 total points
ID: 39940190

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question