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
Solved

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

Posted on 2014-03-07
6
967 Views
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" 
                       DataSourceID="srcWBUsage_ByDate">
                <series>
                    <asp:Series Name="Series1" ChartType="Pie" Legend="Legend1" XValueMember="name" YValueMembers="percent"></asp:Series>  
                </series>
                <chartareas>
                    <asp:ChartArea Name="ChartArea1">
                        <Area3DStyle
                            rotation="10"
                            Perspective="10"
                            Enable3D="true"
                            Inclination="15"
                            IsRightAngleAxes="false"
                            WallWidth="0"
                            IsClustered="false" />
                        <AxisY IsLogarithmic="true" />
                    </asp:ChartArea>
                </chartareas>
                       <Legends>
                           <asp:Legend Name="Legend1">
                           </asp:Legend>
                       </Legends>
                       <Titles>
                           <asp:Title Name="Title1" Text="Chart Date: X">
                           </asp:Title>
                       </Titles>
            </asp:Chart>  

Open in new window


Thanks,
0
Comment
Question by:ErinTheCoderGirl
  • 3
  • 2
6 Comments
 

Author Comment

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

Expert Comment

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

Expert Comment

by:CodeCruiser
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
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

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

Author Comment

by:ErinTheCoderGirl
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?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39940190
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 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