Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Getting Started: Visual Studio and SharePoint 2010 > Create Custom Chart with data from SharePoint List

Posted on 2013-05-10
11
Medium Priority
?
184 Views
Last Modified: 2015-01-29
Hi,

Would appreciate it very much your help to point me to the resource sites ( with sample code, if possible )  to get started on the following:

Using Visual Studio 2012 to create web part / solution that can be deployed in SharePoint 2010,  to create custom chart with SharePoint List(s).

Would specifically like to cover the following items:
1. Visual C#
2. References  to include System.Web.UI.DataVisualization.Charting, System.Data,  .DataSource, .DataBind


Thank you.
0
Comment
Question by:Russellbrown
  • 5
  • 4
11 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 39156995
Hi,
one very good video about VS2012 and SP2010 as starter:
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/OSP231/player

HTH
Rainer
0
 

Author Comment

by:Russellbrown
ID: 39158011
Thank you for the link and it is very informative.

Would you have a sample code or point me to a site with such a code,  for building  a web part to generate a chart with the following conditions:

1) datasource: a SharePoint List,
2) Visual C#
3) utilising Visual Web Part,
4) sandboxed solution,

Environment: Visual Studio 2012, SharePoint 2012

Thank you.
0
 

Author Comment

by:Russellbrown
ID: 39161263
Hi,

I managed to sample a code and able to obtain an array of the x and y values for the chart i.e.  SPListItemCollection itemColl = list.GetItems(query);
How do I debug ( similar to debug.print in VBA  immediate window e.g. ?sales(1)  * ) by printing out an element of the array to either Output / Immediate window in Visual Studio 2012 using C#?

The series in the list are:
Product:        P1   P2   P3 .....
Sales:            50  100  150

the 1st element of the array will be P1, 50.

--------------------------------------------------------------
*The VBA code is something along this line:
Option Explicit
Option Base 1 ' start indexing array elements at 1
Dim sales() As String
Dim item As Variant

and the array is ( 50, 100, 150 )
.....Each item In sales ..........
?sales(1) = 50
?sales(2) = 100


Thank you.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39402145
Hi,
you will have to attach to the W3P process of your SharePoint web app and use
System.Diagnostics.Debug.Write or
System.Diagnostics.Debug.WriteLine
to print to the immediate window.

HTH
Rainer
0
 

Author Comment

by:Russellbrown
ID: 39413550
Hi,

Thank you for the reply. Will work on it. I have paused for a while but will be getting back into this assignment. Will revert in a week's time with the result.

Regards,
Russ
0
 
LVL 19

Expert Comment

by:Amandeep Singh Bhullar
ID: 40576787
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40576788
I do not agree with the Deletion.
The original request has been for a resource to start development. This request has been fulfilled as the creator made it to develop the solution.
Then he asked the question for debugging - which is an extension of the original one.
Therefore imho the first answer can be seen as successful.
KR
Rainer
0
 

Author Comment

by:Russellbrown
ID: 40576837
Agree with Rainer. It has been a while and  was looking on another aspect of a project and missed closing this case. Will be happy to take the first answer as good. Regards.
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 40576854
@Russellbrown: thank you very much - I really appreciate your support!
0
 

Author Closing Comment

by:Russellbrown
ID: 40576993
The pointer has helped to get me started looking further into the issue.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

971 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