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
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.
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.
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.
|