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

First off, I do not have access to designer, so I'm attempting this through my SharePoint site's on-page edit tools. I realize that this may not be possible, but I'll ask the question anyway. :)

I have an asp.net page that hits a SQL backend for data on servers in our environment. Is there a way to embed that asp.net in a web part?

Can you recommend a better way to query this SQL backend and display those results in SharePoint?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

You have two questions here:

1) You can display the page via a Page Viewer Web Part. It renders as an <iframe> tag.

See Page Viewer Web Part

2) You might want to look into External Content Types and Business Connectivity Services, but this will require custom code. So if that isn't an option for you, you're probably best off sticking with option 1.

share|improve this answer
    
I like the idea of the Page Viewer Web Part. –  AspiringTFSGuru May 2 '13 at 19:46
    
Simple, yet effective. And it's OOTB. –  RJ Cuthbertson May 2 '13 at 20:30
add comment

You also might be able to expose your custom page as a simple web service that returns JSON or Xml data and then use the Content Editor Web Part to add javascript to your SharePoint page that calls your service and renders the results in the page itself.

jQuery makes this process pretty simple.

share|improve this answer
add comment

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.