4 sheets tagged with "database":

This spreadsheet queries a database from Python user code, using .NET System.Data.Odbc.

It queries a database and the result is put into an array - the array is unpacked to display the result in the grid. Using the unpack array feature loads the data into a specific set of cells.

The user code that reads from the database is very simple, making it easy to adapt for different types of queries.

See the documentation page (the More Information link) for the kind of database this spreadsheet expects to work with.

The workbook is a simple sheet that allows a user to enter the parameters of a share trade. They can then click on a button, and the details are written to a database.

The code is structured in three layers: a general database access layer, a "business" layer that knows how to translate from concepts that make sense in the application domain (such as stock symbols and prices) into database commands, and then a UI layer that interfaces between the spreadsheet and the business layer.

The database access layer is a simple bit of generic IronPython in the pre-constants user code. It uses the .NET API to execute a non-query SQL statement against a database, the latter being specified by an ODBC connection string.

See the documentation page (the More Information link) for the kind of database this spreadsheet expects to work with.

This sample shows a simple way to load data from Amazon SimpleDB into Resolver One.

Amazon SimpleDB is a web service provided by Amazon which lets you store data on their servers in an unstructured database.

The sample uses Amazon's C# library, which you will need to download separately from Amazon's site.

Full details are on the linked page.

CRUD is a vague term referring to applications that can create, read, update and delete records in some way. In particular, they can do more than just query.

This spreadsheets uses .NET classes and SQL commands to perform all these commands on a single table. An additional spreadsheet is included for use with the webserver.

These examples use an included access database. You must extract this zip file before this will work.

There is no validation or protection against SQL injection in these examples.