Generated Web Forms And Code
Simply put, AspxFormsGen 4.5 generates a web site and SQL code. The web site is really just a container for the created objects so you can right away see how things work. As soon as code is generated, you can see the web forms perform CRUD (create, retrieve, update, delete) operations in action when you run the web site. The generated code can put be in 4 main categories:
  1. Different Types of Web Forms
  2. Middle-Tier and Data-Tier Objects
  3. SQL Code. Stored Procedures or Dynamic SQL
  4. And Miscellaneous Files that makes up the rest of the web site
Click here to see a snapshot of the generated web site.


Generated Web Forms
Listed below are the main ASP.NET Web Forms generated by AspxFormsGen 4.5 for each of the Database Table/View* you select for generation. Also listed are the respective features for each of the Web Form. Each web form has the UI (.aspx) page and the Code Behind (.aspx.cs or .aspx.vb) class file.

Click here to see a snapshot of the generated web forms.

Web Form Features
GridView with Add, Edit Redirect, & Delete
  • Can be used in the administration part of your website
  • Contains a GridView Server Control that has CRUD (Create, Retrieve, Update, Delete) funtionality.
  • Adding a new record redirects to another page
  • Updating and existing record redirects to another page
  • Delete funtionality uses a JQuery UI Pop-up for delete confirmation
  • A link to a read-only Web Form is also provided for all Foreign Key columns (for details on the foreign key)
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • One ASP.NET 4.5 Web Form is generated per table
GridView with Add, Edit, & Delete (Functionality on the Same Page)
  • Can be used in the administration part of your website
  • Contains a GridView Server Control that has CRUD (Create, Retrieve, Update, Delete) funtionality.
  • Add a new record on the same page with JQuery animation
  • Update an existing record on the same page with JQuery animation
  • Delete funtionality uses a JQuery UI Pop-up for delete confirmation
  • A JQuery Tooltip pop-up link is provided for all Foreign Key columns (for details on the foreign key)
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • One ASP.NET 4.5 Web Form is generated per table
GridView, Read-Only
  • Can be used in the public facing part of your website
  • Contains a GridView Server Control. No CRUD funtionality (read-only).
  • A JQuery Tooltip pop-up link is provided for all Foreign Key columns (for details on the foreign key)
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • One ASP.NET 4.5 Web Form is generated per table
GridView, More Information
  • Can be used in the public facing part of your website
  • Contains a GridView Server Control. No CRUD funtionality (read-only).
  • Each row can be viewed for more information on click of the respective button (animated)
  • GridView uses a Sort Direction Image in the header
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • GridView uses Numeric Paging in the footer
  • A JQuery Tooltip pop-up link is provided for all Foreign Key columns (for details on the foreign key)
  • One ASP.NET 4.5 Web Form is generated per table
GridView Filtered By a Drop Down List
  • Can be used to show Filterable data
  • Contains a GridView Server Control. No CRUD funtionality (read-only).
  • Contains a DropDownList Control that filters the GridView's data on index change
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • A JQuery Tooltip pop-up link is provided for all Foreign Key columns (for details on the foreign key)
  • One ASP.NET 4.5 Web Form is generated for each foreign key in each table
GridView with Totals
  • Can be used to show Totals (Money and Number of Records)
  • Contains a GridView Server Control. No CRUD funtionality (read-only).
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • Shows total number of records
  • Shows totals on the footer for money fields
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • A JQuery Tooltip pop-up link is provided for all Foreign Key columns (for details on the foreign key)
  • One ASP.NET 4.5 Web Form is generated for tables that have money data fields
GridView within an Accordion (Grouping)
  • Can be used to show Grouped data with count
  • Contains a JQuery UI Accordion control with GridView within. No CRUD funtionality (read-only).
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • Shows grouping by the respective group
  • Shows count per respective group
  • E.g. Orders by Shipper, Territories by Region
  • One ASP.NET 4.5 Web Form is generated for each table referencing the current table
GridView with Add, Edit Redirect, Delete (Inline) New!
  • Can be used in the administration part of your website
  • Contains a GridView Server Control that has CRUD (Create, Retrieve, Update, Delete) funtionality.
  • Add a new record on the same page inline the header of the GridView
  • Update an existing record inline on the same page
  • Uses server validation
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • Delete funtionality uses a JQuery UI Pop-up for delete confirmation
  • A link to a read-only Web Form is also provided for all Foreign Key columns (for details on the foreign key)
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • One ASP.NET 4.5 Web Form is generated per table
GridView with Search New!
  • Can be used in the administration part of your website
  • Contains a GridView Server Control that has CRUD (Create, Retrieve, Update, Delete) funtionality.
  • Contains search functionality in the header, per column*
  • Adding a new record redirects to another page
  • Updating and existing record redirects to another page
  • Uses model binding to retrieve data
  • GridView retrieves data on demand using Skip/Take logic
  • Delete funtionality uses a JQuery UI Pop-up for delete confirmation
  • A link to a read-only Web Form is also provided for all Foreign Key columns (for details on the foreign key)
  • GridView uses a Sort Direction Image in the header
  • GridView uses Numeric Paging in the footer
  • One ASP.NET 4.5 Web Form is generated per table
Add New & Edit Record
  • Use to Add a New Record or Edit an Existing Record
  • Contains JQuery Validation or ASP.Net Validation
  • Contains JQuery UI Date Controls for date fields
  • Contains bound DropDownList Web Control for foreign fields
  • You can get here from the "GridView with Add, Edit Redirect, & Delete" Web Form when clicking the Add New Record link or the Edit button
  • One ASP.NET 4.5 Web Form is generated per table
Record Details (Read-Only)
  • Use to show Read-Only detail of a record
  • Shows details of a record (Read-Only)
  • You can get here from the "GridView with Add, Edit Redirect, & Delete" Web Form when clicking the foreign key links
  • One ASP.NET 4.5 Web Form is generated per table
Unbound Web Form
  • Use to add your own code in the Code File (Code Behind)
  • Web Forms that are not bound to the database
  • Contains JQuery Validation or ASP.Net Validation
  • Contains JQuery UI Date Controls for date fields
  • Contains unbound DropDownList Web Control for foreign fields
  • One ASP.NET 4.5 Web Form is generated per table



Generated Business Objects and Data Objects Code
The Business Object or Middle-Tier is the 2nd tier code called by the Web Forms (1st tier). The Data Objects or Data Tier is the 3rd tier code called by the middle tier. These are class files (.cs or .vb) generated for each of the Database Table or View.

Click here to see a snapshot of the generated Middle and Data Tier code.

Code Features
Business Object Class
  • Note: The only code you call from your application
  • Used as the gateway middle layer object the client calls
  • Most CRUD calls can be made in one (1) line of code
  • Inherits from the respective BusinessObjectBase class
  • You can add additional code here (it will not be overwritten by the generator)
  • One Class is generated per table
  • Located in the \BusinessObject\ folder
Business Object Base Class
  • Used as the base class to the Business Object class
  • Do not add or edit code here
  • Contains table fields as properties
  • Encapsulates calls to the data layer
  • One Class is generated per table
  • Located in the \BusinessObjectBase\ folder
Business Object Collection Class
  • Used as the Collection of the Business Object Class
  • Do not add or edit code here
  • One Class is generated per table
  • Located in the \BusinessObjectCollection\ folder
Data Layer Class
  • Used as the gateway data layer object the middle tier objects call
  • Inherits from the respective DataLayerBase class
  • You can add additional code here (it will not be overwritten by the generator)
  • One Class is generated per table
  • Located in the \DataLayer\ folder
Data Layer Base Class
  • Used as the base class to the Data Layer class
  • Do not add or edit code here
  • Encapsulates calls to Stored Procedures or Dynamic SQL
  • One Class is generated per table
  • Located in the \DataLayerBase\ folder



Generated Stored Procedures/Dynamic SQL
Generated Business Objects and Data Tier code. These are class files (.cs or .vb) generated for each of the Database Table or View.

Click here to see a snapshot of the Stored Procedures.

Stored Procedure Features
Select All Selects all records for a specific table.
Select By Primary Key Selects a record by primary key(s).
Insert Inserts or creates a new record
Update Updates or edits a record by primary key(s)
Delete Deletes a record by primary key(s)
Select DropDownList Data Selects two fields from the specific table. Selects the primary key and another field. Data retrieved can be used in DropDownList or other List controls that require 2 fields.
Select All Filtered-By Selects all records based on a Foreign Key parameter.
Get Record Count Gets the total record count by table.
Get Record Count by Foreign Key Gets the record count by the related foreign key.
Get Record Count by Dynamically Passed Parameters Gets the record count based on search paramenters. Used in search queries.
Select All Where Dynamic Selects records based on the search parameters. Used in search queries.
Select, Skip, Take Selects top number of records starting from a parameter's index value. Data is also sorted based on a sort expression parameter.
Select, Skip, Take by Foreign Key Selects top number of records by a Foreign Key, starting from a parameter's index value. Data is also sorted based on a sort expression parameter.
Select Totals Selects an aggregate of fields with totals. Decimal fields are Summed up and returned as aggregates.


Miscellaneous Files
Files Features
Code Example Class
  • Generated solely to show how to use the Generated Code
  • Example code can be copied and pasted directly to your client code (ASP.Net web forms, Win Forms, Web Services, etc.)
  • You can delete the whole directory if you don't need it
  • One Class is generated per table
  • Located in the \Example\ folder
Skin File
  • Used as the primary theme for the generated web site.
  • Located in the App_Themes folder.
Images
  • Various images used by the generated website
JQuery UI Themes
  • Various themes used by JQuery UI controls
  • Located in the Styles/themes folder
Scripts Folder
  • JQuery UI, JavaScript, JQuery, and ASP.NET JavaScript libraries used for client-side operations.
  • Located in the Scripts folder
CSS Styles (Folder)
  • Various styles used by the website, JQuery UI, JQuery tooltip, etc.
List of Generated Web Forms
  • List of all (main) generated ASP.NET 4.5 Web Forms.
  • You can go to the generated web forms from here.
  • A link for each of the generated web forms is listed here.*
  • A good page to "Set as Start page".
List of Generated Code
  • List of all generated Middle-Tier, Data-Tier, and Stored Procedures or Dynamic SQL.
Master Page(s)
  • 1 Blank master page used by the generated web forms (Site.master)
  • 1 Blank master page can be used for your mobile web site (Site.mobile.master).
  • You can add your web site design here.
  • You can add your web site design here.
Web.Config file
  • Web.config file used by the website.
* Please see notes.