Module description

The Manage Database Records module provides a "out of the box" web interface to easily add/edit/delete records into any table from a backend database.

Launch Module

The UI is divided in three sections, which can easily be resized by drag and drop. In the top section, there is a toolbar which allows you to navigate through the pages. The left hand section contains a master/detail grid displaying the data from two related tables (Customers/Orders and Suppliers/Products). In the right hand section there is a Super Form which can be used to add/edit/delete records. Upon selecting a record in one of the grids, the form will be populated with all the data for the selected record.

All the operations are performed using asynchronous postbacks to the server (AJAX requests) to improve the usability and the performance of the page (no full page postbacks are performed).

Technologies

This module uses the obout Grid, Super Form, Splitter, Easy Menu, Calendar and Interface controls, along with ASP.NET AJAX. The backend database server being used is MS SQL Server.

Integration

Integrating this module into your existing website/web application is very easy. Just copy the ManageData.aspx and ManageData.aspx.cs files to your project and then modify the ManageData.aspx.cs file to use your database instead of the sample Northwind database provided in the sample application.