universaldba

DEMO http://www.24hourphotographer.com/admin/Index.aspx

This project describes an ASP.NET web module which can be added /customized in any SQL driven web application as a database administration module. When I first started with an admin section for a web application, I thought why not try to make something more general, a plug-n-play admin section which can be used for any SQL driven dynamic web application, and here is the result of the effort.

The target was:

Create a self sufficient admin section which can be put into any SQL driven web application by changing the connection string for SQL Server in the web.config file. User needs to login before doing CRUD (Create/Read/Update/Delete) operations (Not required for the AdminLite version). There should be individual pages one for each operation (CRUD) which will take the tablename as the parameter. A dataAccess class which wraps all the data access methods and returns the values or records as required. CRUD operations for tables (you can create/read/update/delete tables). Filter records using custom SQL queries. Execute custom SQL statements on the database. Support for paging/sorting. Includes SQL injection workaround for the login page using regular expressions - latest update. Support for multiple images (binary data in SQL tables).

For more information http://csharptricks.com/Articles/UniversalDBAArticle.aspx