Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

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

share|improve this answer

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

share|improve this answer
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 May 2 '12 at 20:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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