This web application is completely generated by RapTier. The application allows you to navigate through the database, add, delete and update data. Use it as-is or modify the code according to your needs.

RapTier is a template-based ASP.NET, C#, VB.NET and SQL code generator that creates robust database driven applications for a wide range of databases. It is an easy-to-use tool that significantly reduces development and testing time as well as improves the quality and performance of your code.

Information about the C# Smart Editor Templates

The template used for this UI was written by JeffLit. It is designed to work best with Microsoft SQL Server databases. This template implements the following differences from the default RapTier template:

• New SQL Server stored procedures that perform pagination on the database server, thus preventing entire tables from being sent over the network to the web server.
• New SQL Server stored procedures that perform ad-hoc queries so that database users don't need select, update or delete permissions to tables.
• Elimination of 'SELECT *' from all stored procedures in favor of explicitly listing all columns (makes it easier to alias columns, remove a column, add a joined column, etc.)
• Consistent use of SQL Server stored procedures (no dynamic SQL).
• Defaults to use of the SQLClient class library for optimum efficiency with SQL Server.
• A new Save method on the gateway class collections that will do an update or insert, depending upon if a row with the primary key(s) already exists or not.
• Supports specification of the connection string via a web.config AppSetting called SQLConnectionString. If not present then uses hardcoded connection from RapTier IDE.

• Collapsible data filtering UI to limit the number of rows shown in datagrids and make large datasets manageable
• Both ascending and descending column sorting in datagrids
• Support for bulk (HotMail like) delete of multiple records in datagrids
• Custom pagination with only a single page of results ever bound to a datagrid (i.e. VirtualPageCount)
• Custom 'Page [1] 2 [3] [4]' style formatting of the pagination footer in datagrids
• Consistent use of cascading stylesheet classes for easier look-and-feel changes
• A new optional 'monochrome' stylesheet
• Separate Editor Pages instead of in-line grid editing. Editor pages support the following enhanced features:
• Dropdown lists of valid values from parent table for foreign key columns
• Checkboxes for boolean fields
• Data validation for the following types of fields:
• Required fields (not null)
• U.S. phone numbers (fields with 'phone' in the column name)
• U.S. zip codes (fields with 'zip' in the column name)
• U.S. Social Security Numbers (fields with 'ssn' in the column name)
• E-mail addresses (fields with 'email' or 'e-mail' in the column name)
• Uniform resource identifiers (URLs) (fields with 'url' or 'href' in the column name)
• SOAP Web Service interfaces to all tables and views

Note that the seprate editor pages require that tables have a single primary key column or they are disabled.

• Overview
• Knowledge Base
• Documentation
• FAQ
• Forum