1

Here is the setup. I have a SQL Server database that i need to query. I want to display the information in a Telerik/Devexpress chart control on either an application or site page.
Here is what i was thinking about doing and then those who know better can correct me :)

Create a library dll that has a service with methods that (using the entity framework) return a variety of IEnumerable types. Use an application page with the chart control. In the code behind use the service and bind the data to the chart control.

Any help/ideas on how i should actually do this in Sharepoint Foundation 2010 is very much appreciated.

2 Answers 2

3

I would simply create a SharePoint Web Part or SharePoint Application Page that would use the Telerik control just like any other .NET application would. In the code behind of the page, query your SQL database to provide the data to the control.

There are many resources on how to create web parts and application pages. Here is a collection of great videos on web parts: http://msdn.microsoft.com/en-us/sharepoint/ee513148

1
  • 1
    In addition to what John has already recommended.. I suggest you store configurations such as database connection sting somewhere manageable in SharePoint (rather than in a web.config) such as in a SPPersistedObject (msdn.microsoft.com/en-us/library/…).. This will make your app more flexible and configurable across different environments..
    – Zeb
    Commented May 2, 2012 at 20:36
3

You may want to consider the BCS feature for database access within your SharePoint setup. Here are a few links that may be helpful -

UPDATE: Learning videos from the SharePoint Developer Center - Accessing External Data with Business Connectivity Services in SharePoint 2010

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.