Tuesday, April 19, 2005

Consuming stored procedures with the DataView WebPart and SharePoint

A Data View Web Part displays a tabular representation of a filtered subset of a table on a Web Part Page. You can create data views from a large variety of data sources including databases, XML files, SharePoint lists, and so on.... These Data View Web Parts can be easily added to your Windows SharePoint Sites with FrontPage 2003.

However when you add a connection to a database, you will see that you can only consume tables and views from SQL Server - there is however a setting in WSS which you can alter to allow your webpart to use stored procedures.First enable custom query support for Windows SharePoint Services:
  • Browse to the Windows SharePoint Services Central Administration page.

  • Under Component Configuration click on Configure data retrieval service settings.

  • Check the Enable Data Retrieval Services checkbox.

  • Check the Enable update query support checkbox.

  • Click OK.

  • For more info check out the following articles:
  • Using frontpage 2003 to design customised sites

  • Using frontpage 2003 to build XML data driven sites
  • 1 comment:

    Anonymous said...

    I'm going to add this blog item to the Non-MS Articles section of the WSS FAQ, but will you let me use the last few lines in a FAQ item as well, please ?

    Mike Walsh