SaveToDB Online Examples

The SaveToDB Suite setup package includes Excel workbooks of the examples for Microsoft SQL Server.
The example databases are deployed in Windows Azure SQL Database.
So you may test the examples using Microsoft Excel with the installed SaveToDB add-in only.

The SaveToDB SDK package contains the same examples with source codes for on-premises deployment.
The example Microsoft Excel workbooks have connections to a local Microsoft SQL Server Express database.

The examples for Microsoft SQL Server show a complete set of SaveToDB features used for Excel application development.

Azure Catalog

This is the most complete example. The example shows the following features:

Azure Calendar

This example application shows how to use SQL Server stored procedures as Excel event handlers for handling the following events:

Also the example shows how to customize Microsoft Excel context menu and SaveToDB Actions menu,

Azure Monthly Cash Flow

This example is a simple application of payment register.

The application contains a one database table and several stored procedures.

But take a look at this example as it shows how easily to get the real multi-user work in Microsoft Excel.

The example shows core SaveToDB features available from-the-box, without any coding:

Azure Budget

This is an example application for budgeting that extends the Azure Monthly Cash Flow application. It adds a powerful feature:

The example shows how to use complex input forms to update normalized database tables.

* The feature requires the SaveToDB Enterprise edition or the trial version.

Azure Stocks

This is an example application for stock analysts.

The example shows advanced SaveToDB features:

You may easily add these features to your existing Excel applications.

Azure Tasks

This is an example application for working with tasks.

The example shows advanced SaveToDB features:

This is a useful example for learning native Microsoft Excel formulas, conditional formatting, and working with table features.

Database Management

This is an example application for managing user and role permissions on Microsoft SQL Server and Windows Azure SQL Database.

You may use this application in your real work. This is a more comfortable way to control and change the rights than the use of SQL Server Management Studio.

The example shows how to use stored procedures as Excel event handlers to easily modify database data including database permissions.

Extended Properties Editor

This example shows how to view and edit database object extended properties using Microsoft Excel.

This example is simple but it can be useful for developer teams.

The example shows how to use stored procedures as Excel change event handlers.

This example is not work in Windows Azure SQL Database as the extended properties are not supported.