0

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?

2 Answers 2

1

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.

2
  • I like the idea of the Page Viewer Web Part.
    – Steve L.
    Commented May 2, 2013 at 19:46
  • Simple, yet effective. And it's OOTB. Commented May 2, 2013 at 20:30
0

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.

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.