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. ...

Get Special Edition Using Microsoft® SharePoint Portal Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.