JTBarton.com

Skip Navigation Links
Home
Barcode overview
SQL playground
Web Cameras
Personal information
Developer links
About Web Host
Contact Me
Sign In

SQL Playground

The purpose of the following pages are to be able to display:
  • A list of databases, tables and column details
  • Provide the ability to create user defined data that includes images
  • Create a login and role management database

Database list

List MS-SQL Databases

This was just a way of getting the list of available databases, and then to be able to show the tables that belong to each table when a database is selected.  Additionally it goes on to list the fields that belong to each of the tables with some basic details of the columns data types and definition.

Read Article on how to display the databases, tables and column schema's.

Record management

Record Management

Here you are able to create new records as an end user that can be displayed on a page.
Its rather a simplistic example, where a header and details are manually entered, the more interesting part is that you can attach any number of graphics to the record, which are initially displayed as thumbnails and can be expanded to display the full image.  The records including the thumbnails and images are stored in a MS SQL 2000 database.
There is the ability to:
  • Display a list of all records and show the details (including image) of a number of records
  • Add new records
  • Edit records, including adding and removing images
  • Delete a record, with a preview of the record

When an image is added, it automatically creates a thumbnail.

Read Article on how to achieve this image creation and display functionality with coding examples.


User management

Login and Role Management

You have probably heard the boast from Microsoft that ASP.net 2.0 is 70% faster than any previous version of .net to develop code.  If your like me you take statements like that with a pinch of salt.  Well I wanted to implement a way in which to only allow authenticated users to be able to edit the records and images I maintain on this site, so the challenge was set. I must say that all I needed to do was read a few articles, then question, is that it, read them again and then I gave it a go, see my Article for details. 

I further went on to ask myself, how to I manage users and roles from the web site without having to run the aspnet scripts directly against the SQL database , this was also really easy and I may even write about it one day, but you can see the results by looking at User management and Role management.

Read Article on how to create the user and role database in a web hosted environment.

Source Code

If you would like to obtain the source code for any of these examples, please send me an email by clicking on source code above.  All the code for theses pages are written in C# using ASP.net 2.0.