SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010)
>
Building an interactive application webpage
Building an interactive application webpage
I am working for a customer that currently has a Sharepoint Server with both a publishing site and team room site. They want to create pages in either that will replicate what they have been doing in Access 2003. These pages would need to access the MS SQL Server 2005 DB in the backend and must look like a website, not an InfoPath Document. Is this possible, and if so, what is the basic structure and or components?
Answers
- My guess what you'll want is to create custom application pages. These are pages that are stored in the 12\template\layouts folder on a SharePoint Web Front End. The advantage to these is that they are really web pages that share a common master page that SharePoint uses (application.master). The basic content of them is just a standard .aspx ASP.NET page, so you can use ADO.NET and other controls to integrate with your back end SQL database.
There are a lot of articles that explain how to create application pages, so I'll let you search for these. You can also look at many of the out of box ones that SharePoint uses that are stored in this same layouts folder.
Hope this helps.
Randy - http://sharepointhawaii.com/randywilliams- Marked As Answer byLambert QinMSFT, ModeratorTuesday, November 24, 2009 9:58 AM
All Replies
- My guess what you'll want is to create custom application pages. These are pages that are stored in the 12\template\layouts folder on a SharePoint Web Front End. The advantage to these is that they are really web pages that share a common master page that SharePoint uses (application.master). The basic content of them is just a standard .aspx ASP.NET page, so you can use ADO.NET and other controls to integrate with your back end SQL database.
There are a lot of articles that explain how to create application pages, so I'll let you search for these. You can also look at many of the out of box ones that SharePoint uses that are stored in this same layouts folder.
Hope this helps.
Randy - http://sharepointhawaii.com/randywilliams- Marked As Answer byLambert QinMSFT, ModeratorTuesday, November 24, 2009 9:58 AM
