In this use case scenario, you have data in a SQL database table or view that you want to display in the Calendar Plus Web Part in your SharePoint sites. This article will walk you through the process of configuring the Calendar Plus Web Part to connect and display the data.
Note: This article shows the functionalities of Calendar Plus version 2.0 and above.
In this example, we will be using the Northwind sample database available with the SQL 2000 server. We want to display the Order table in the Calendar Web Part. The order table can be used directly, or as in this example, we will be using the Orders Qry view to retrieve the data:
The data returned from the query is shown in the figure below. In this example, we will use the OrderDate and the ShippedDate columns as our calendar dates, and the ShipCountry as the color code column. Note that in the sample database, we changed the years from the default values of 1996/1997 to 2007/2008.
Install the Bamboo Calendar Plus Web Part according to instructions in the Application Notes. Once the Web Part is installed, select Modify Shared Web Part from the menu accessed at the upper right corner of the Web Part. This menu is only accessible by users with authority to modify the page.
Select the display options for the Calendar Web Part. These options allows you to select how the calendar will be presented to your end users.
Select the SQL database as your data source:
Select the SQL Server Table or View option.
Enter the name of the SQL server in the Server text box.
Enter the SQL Access Account (not the Windows login account) that has the right to access the database. Note that you can use the current login account to access the database if the database resides on the same server as your SharePoint server farm.
Select the database name, Northwind in this example.
Select a database table or view, Orders in this example.
Select a column to display on the Calendar, ShipCountry in this example.
Select the information from the database columns that you want to display when the users mouse over an item. In this example, we will show the ShipName, ShipCountry and ShipVia columns.
Select color code. In this example, we want to display a different color based on the ShipCountry. Click the AutoSelect button to have the system automatically set the initial color codes, then you can change each individual setting if needed.
Important: When you connect the Calendar Plus to a backend database, the system will read the first 100 records to determine the different choices available for color coding.
Select the Calendar date. In this example, we will use the OrderDate and ShippedDate to display each item in the calendar.
Select any additional settings (i.e, holiday, Gantt view) if needed. When you are done with the selection, press Apply and OK to close the Web Part's setting page.
- End -