O'Reilly logo

Special Edition Using Microsoft® SharePoint Portal Server by Robert Ferguson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Employee Locator Web Part (Version 1)

The first Web Part is called the Employee Locator Web Part; it browses through a list of employees in the SharePoint dashboard.

Employee information might be stored in Oracle, SQL Server, or other relational databases. For the purpose of this Web Part, we will assume that it is stored in SQL Server 2000, but it really does not matter which backend database is used. The code will mainly stay the same.

Creating Employees Table

To simplify the process, I have used the employees table from a sample SQL Server database that is shipped with SQL 7 and SQL 2000 (the Northwind database), and added a field to the table for an email address. Figure 15.6 shows the data structure of the Employees table used for this example. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required