Solved

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

Posted on 2014-03-07
6
964 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 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