My favorites | Sign in
Project Home Downloads Wiki Issues Source
Project Information
Members
Links
  • External links
  • Demo

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

Powered by Google Project Hosting