ASP.NET Coder - SPEEREC, LTD.

ASP.NET | ASP.NET Coder | ASP.NET Coder Example | Site Development

ASP.NET Coder

ASP.NET Database Form Coder - Main Table / Directory / Security

• Step 1:
• First we choose the base table we would like to build code for.
• Then we choose the directory we would like to code written to in the administration area. We have to option to build it in the administration root directory, it's own directory by table name, or a custom directory we enter in the system. Some built code is for adminsitration, other smaller modules are grouped together in a standard directory, while other modules belong in a larger collection of built code.
• Last of all the security is chosen for the built code. We have the option of using any pre-built security code or applying no security which allows any site administrator to have access to the new code.

ASP.NET Database Form Coder - Fields / Search / Required / Sorting

• Step 2:
• The first column allows us to choose the fields in the database table we want to be included in the new code.
• The second column is a listing of all the fields in the table we chose in the previous step.
• The table Key or ID is identified by the table structure and is used throughout the coding process to manage which record is being worked on at any given time.
• They type of field is automatically defaulted for a number of different field stuctures read directly from the table structure. We have the option to change any field to work as another type of field. The field types the coder handles are:
  1. Text Field
  2. Rich Text Box (Free Text Box)
  3. Memo Field
  4. Numeric
  5. Other Table ID
  6. Radio Button (manual)
  7. Radio Button (table)
  8. Checkbox (manual)
  9. Checkbox (table)
  10. DropDown (manual)
  11. DropDown (table)
  12. Hidden Field
  13. Date/Time Field
  14. Date/Time Stamp
  15. File Upload
• The Other Table ID field allows easy integration of sub-table data into the new code expanding the power of this code builder. The Radio Button, Checkbox, and DropDown fields can handle manually entered data at the time of coding or be attached to seperate tables in the database as well. There is a standard Date/Time Field as well as an automated Date/Time Stamp that can optionally be updated each time the record is updated. The File Upload field creates and manages files given unique file names in the directory of our choice.
• The new code can have a search function automatically built into the page. We just choose the fields we would like to be able to search on and this is function is automatically generated in the new code.
• If there are fields that are required or it's manditory that there be something entered in the field, we check each of those fields at this point. We can use Required Field and Range validators.
• The last column allows us to choose how the data is retrieved from the database and sorted in our listing. We can choose the order of the columns and if we want the field sorted ascending or descending.

ASP.NET Database Form Coder - Display / Disable / Format / Errors

• Step 3:
• The first column gives us all the fields used to generate the new code.
• The Display field allows us to choose the fields we want to view in the data listing. The code will automatically build in paging for large datasets, but we need to decide which fields we want to see in the listings.
• We can Disable any field of our choice. This allows us to let users view data from the database without having access to make any updates to the data.
• The Type column tells us how the field will be rendered in the code. This information was choosen in a previous step.
• The Information column allows us to collect additional data for how each field will be coded. This information includes:
  1. The width and maximum length of text fields
  2. The width and maximum length of numeric fields
  3. The database table to associate with for Other Table ID's
  4. The number of options for manual Radio Buttons, Checkboxes and DropDowns
  5. The database table to associate with for Radio Buttons, Checkboxes and DropDowns
  6. The value of hidden fields to be passed to the database
  7. The width and maxlength of Date fields
  8. The option of updating a Date/Time Stamp field on record updates
  9. The directory location to manage file uploads
• The final column allows us to enter in custom Error Statements for any field that was checked Required on the previous screen. We use the standard '*' for most required fields, but also have the ability to enter in specific messages by field.

ASP.NET Database Form Coder - Values / Uploads / Dates / Sub-Tables

• Step 4:
• The final page collects any additional information needed to complete the code build.
• The table ID's and description fields are collected for Other Table ID fields.
• The table ID's and description fields are collected for the Radio Buttons, Checkboxes and DropDowns that are associated with another database table.
• The values and descriptions are collected for the manual Radio Buttons, Checkboxes and DropDowns.