Click here to Skip to main content
12,953,014 members (47,913 online)
Rate this:
Please Sign up or sign in to vote.
Hello all,

My goal is to display my database table values ( I have two columns as Total and Used) on a pie chart. I used the WPFToolkit for the chart control and created a pie chart structure.

but I am stuck with binding the chart to the datasource.

Any one can pls suggest me a solution. Thanks !

This is what i have tried :

public List<ram> getRamData()
          List<ram> list = new List<ram>();
          string query = "select top 1 Used,Total from UsageRam";
          cmd = new SqlCommand(query, con);
          dr = cmd.ExecuteReader();
          while (dr.Read())
              var reading = new ram
                  Used = Convert.ToInt32(dr[0]),
                  Total = dr[1].ToString()
Posted 9-Jan-13 1:12am
Updated 9-Jan-13 2:52am
Sanjay Debnath 9-Jan-13 7:28am
may be this can help
BuBa1947 9-Jan-13 7:37am
Thank you sanjay, I have refereed these links already. But in both links, they have binded the Itemsource from list , not from a database. my question is , how to bind Pie Chart datacontext to a DataBase
Sandeep Mewara 9-Jan-13 8:26am
Just get the data from database as List.. whats the problem?
BuBa1947 9-Jan-13 8:52am
@Sandeep Mewara: Kindly check my code above. is that the right way ?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Hello, please take a look over here, it could solve your problem, perhaps :[^]

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,429
CHill60 3,490
Maciej Los 3,103
Jochen Arndt 1,975
ppolymorphe 1,920

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100