Solved

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

Posted on 2013-05-10
11
151 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 500 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

832 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