Stonecold Software

Creators of mp3-anywhere and TrueAchievements...

Site menu:

Latest news:

06 Mar 07
Second Hand Vinyl Revamp

Read more »

Stonesbase Control and Function Library

After being dissatisfied with the controls shipped with .net, and also wanting to increase the speed of development while reducing the likelihood of bugs, I have produced a control and function library called Stonesbase.

As the classes form a single interface to any data source, it does not matter when writing the page whether the data is stored in SQLServer, Oracle, Access or even an XML file - as the base classes handle all the data fetching and updates our page code remains the same

To demonstrate how easy the classes are to use, let's show you some code that uses the classes to add, edit and remove data from an Office table in our database.

First of all, we need to create the table class that defines the fields in the table, and any validation we want to do on each field.

The Office table class
This is the table class for the Office table.

I also written a little tool that automatically creates this table class by pointing it at the SQL table to save even more time!