|
AspxFormsGen 3.5
Generate an ASP.NET 3.5 Web Site in One Click!*
AspxFormsGen 3.5 is a tool that automatically generates (ASP.Net 3.5 Generator) ASP.Net 3.5 Standard
WebForms (.aspx) in C# 3.5 or VB 9.0 and their accompanying CodeFile (.aspx.cs or .aspx.vb). It generates WebForms with
CRUD (Create, Retrieve, Update, Delete) functionalities using the latest
Linq-to-SQL and LinqDataSource, based on the tables in your MS SQL 2000/2005 Database, all in One Click.
AspxFormsGen 3.5 is not a component, it simply generates ASP.Net 3.5 WebForms, using
unbound and/or bound standard ASP.Net web server controls and the new integration of the ASP.Net AJAX Control Toolkit extender controls.
AspxFormsGen 3.5 is made for ASP.Net programmers, it generates ASP.Net 3.5 WebForms using the latest ASP.Net 3.5 technologies such as:
Linq-to-SQL coding, LinqDataSource and ListView web server controls. It also integrates AJAX Control Toolkit extenders such as: FilteredTextBox,
ValidatorCallOut, CalendarExtender, ModalPopUpExtender, AnimationExtender and more. Needless to say, all generated WebForms are intended for use with Microsoft Visual Studio 2008.
What's New?
| Made specifically for the Visual Studio 2008 IDE using the latest 3.5 .Net Framework. |
|
Integration of the ASP.Net AJAX Control Kit Extenders for flicker-free client-side experience. |
|
CRUD (create, retrieve, update, delete) operations using the new LINQ-to-SQL and LinqDataSource. |
[ back to top ]
Generated WebForms Features/Uses
Listed below are features and uses of the the ASP.Net 3.5 WebForms that are generated by AspxFormsGen 3.5. All generated WebForms
have a separated code behind file (.aspx.cs or .aspx.vb).
| Generated ASP.Net 3.5 WebForms |
Features |
#1 Admin WebForms w/ GridView
(tablename + "Grid.aspx") |
- Can be used in the administration part of your website.
- Contains a GridView Server Control that has CRUD (Create, Retrieve, Update, Delete) funtionality.
- GridView uses a Sort Direction Image in the header.
- GridView uses Numeric Paging in the footer.
- Delete funtionality uses a ModalPopUp Extender for delete confirmation.
- Delete funtionality also uses an Animation Extender when deleting GridView row.
- Links to Add a new record and to Edit records are provided.
- A link to a read-only WebForm is also provided for all Foreign Key columns.
- One WebForm is generated per table.
|
#2 Read-Only WebForms w/ GridView
(tablename + "GridRead.aspx") |
- Can be used in the public facing part of your website.
- Contains a Read-Only GridView Server Control. No CRUD functionality.
- GridView uses a Sort Direction Image in the header.
- GridView uses Numeric Paging in the footer.
- Link to a read-only Webform is provided for more information in all rows (#7).
- A link to a read-only WebForm is also provided for all Foreign Key columns (#7).
- One WebForm is generated per table.
|
#3 WebForms w/ ListView & GridView
(tablename + "ListByGroupName.aspx") |
- Can be used to show Grouping of Data, e.g. "Product List by Category".
- Contains a GridView Server Control nested inside a ListView Server Control.
- Uses Accordion Extender-Style panels to show or hide group of data.
-
Generated per foreign key in a table, e.g. If you have a table named "Products", and this table
have 2 foreign keys, CategoryID and SupplierID, then 2 WebForms will be generated. One called:
"ProductListByCategory.aspx" and "ProductListBySupplier.aspx".
|
#4 WebForms w/ ListView & GridView
(tablename + "ListByGroupName2.aspx") |
- Can be used to show Grouping of Data, e.g. "Product List by Category".
- Contains a GridView Server Control nested inside a ListView Server Control.
- Uses Toggle Visibility-Style panels to show or hide group of data.
-
Generated per foreign key in a table, e.g. If you have a table named "Products", and this table
have 2 foreign keys, CategoryID and SupplierID, then 2 WebForms will be generated. One called:
"ProductListByCategory2.aspx" and "ProductListBySupplier2.aspx".
- Should be used instead of the accordion-style listview when the groups have items larger than 20.
|
#5 WebForms to Add New Records
(tablename + "Add.aspx") |
- Use to Add A New Record/Item. You can get here from the Admin WebForm GridView (#1)
- A place holder for the Add/Edit Web User Control.
- Note. The add functionality is in the Add/Edit Web User Control (#7)
- Uses AjaxControlToolkit control extenders.
- Contains TextBox, DropDownList, CheckBox Server Controls to hold data.
- Uses Required Field & Compare Validators, FilteredTextBoxExtender, ValidatorCalloutExtender for validation.
- Uses the CalendarExtender to fill out Date columns.
- Uses LinqDataSource control to automatically retrieve DropDownList items.
- Uses LINQ-to-SQL to submit changes to the database.
- One WebForm is generated per table.
|
#6 WebForms to Edit/Update a Record
(tablename + "Edit.aspx") |
- Use to Edit/Update a Record/Item. You can get here from the Admin WebForm GridView (#1)
- A place holder for the Add/Edit Web User Control.
- Note. The edit/update functionality is in the Add/Edit Web User Control (#7)
- Uses AjaxControlToolkit control extenders.
- Contains TextBox, DropDownList, CheckBox Server Controls to hold data.
- Uses Required Field & Compare Validators, FilteredTextBoxExtender, ValidatorCalloutExtender for validation.
- Uses the CalendarExtender to fill out Date columns.
- Uses LinqDataSource control to automatically retrieve DropDownList items.
- Uses LINQ-to-SQL to submit changes to the database.
- Uses LINQ-to-SQL to retrieve record/item to be edited/updated from the database.
- One WebForm is generated per table.
|
#7 Web User Control
(tablename + "AddEditControl.ascx") |
- Used to centralize all add and edit/update functionalities.
- One Web User Control is generated per table.
|
#8 Read-Only WebForms w/ FormView
(tablename + "View.aspx") |
- Used as a Read-Only representation of one record/item.
- You can get here from the Read-Only WebForm GridView (#2)
- Uses a FormView Server Control to retrieve record/item being viewed from the database.
- Uses Label Server Controls to hold data.
- One WebForm is generated per table.
|
#9 Unbound WebForms
(tablename + "Form.aspx") |
- Unbound WebForm.
- Contains Unbound TextBox, DropDownList, CheckBox Server Controls.
- Uses Required Field Validator for validation.
- One WebForm is generated per table.
|
| #10 Functions.cs/Functions.vb |
- Contains static/shared methods for use as utility by other web pages.
- Single file is generated.
|
| #11 SkinFile.skin |
- Contains skin styles for the GridView, TextBox, DropDownlist, and Labels.
- Single file is generated.
|
| #12 StyleSheet.css |
- Contains the styles for all generated webforms.
- Single file is generated.
|
| #13 GridViewScript.js |
- Contains JavaScript functions used by the GridViews.
- Single file is generated.
|
| #14 SlidingCollapse.js |
- Contains JavaScript functions used by the Accordion-Style ListView.
- Single file is generated.
|
| #15 MasterPage.master |
- Contains a blank master page. The design for the whole website can be done from here.
- Single file is generated.
|
| #16 web.config |
- A regular web.config file. Contains the connection string to the LINQ to SQL class file.
- Single file is generated.
|
| #17 LINQ-to-SQL class files |
- Generated .dbml file based on the tables of your MS SQL database.
- Single file is generated.
|
| #16 Partial DataContext class |
- A partial class file for the datacontext for the LINQ-to-SQL class.
- Adds a reference to the web.config's connection string to the database.
- Single file is generated.
|
| #18 ToggleVisibility.js |
- Contains JavaScript functions used by the Toggle Visibility-style ListView.
- Single file is generated.
|
[ back to top ]
Frequently Asked Questions
- Is AspxFormsGen 3.5 free?
The AspxFormsGen 3.5 Express edition is free. All the other editions are for sale.
- Do I need to register AspxFormsGen 3.5?
No. You don't need to register AspxFormsGen 3.5.
- What's the catch with the AspxFormsGen 3.5 Express Edition?
No catch at all. You can download it for free. You can give copies to your friends. You don't have to register. There's no trial date end (because it's not a trial). There's no pop-ups reminding you to buy the Professional Edition. No Activation required. Absolutely no catch.
- Is AspxFormsGen 3.5 a component?
No, AspxFormsGen 3.5 is not a component. It is a tool/application (.exe) that generates standard ASP.Net 3.5 webforms (.aspx pages) based on your MS SQL 2000/2005 database or an attached SQL Express.
- What do I need to generate webforms using AspxFormsGen 3.5?
You need an MS SQL 2000 or 2005 database or an attached SQL Express, the .net framework 3.5 installed in your pc and Visual Studio 2008 also installed in your pc.
- Why do I need Visual Studio 2008 installed in my pc to use AspxFormsGen 3.5?
AspxFormsGen 3.5 uses a tool that comes with Visual Studio 2008 called "sqlmetal" to generate the .dbml file (Linq-to-SQL class file).
- Why do I need the .net framework 3.5 installed in my pc?
By default, the .net 3.5 is intalled when you install Visual Studio 2008. Since AspxFormsGen requires Visual Studio 2008, the .net framework 3.5 is also required. Also, the generated ASP.Net 3.5 webforms uses the .net framework 3.5 features such as Linq-to-SQL class files and coding, ListView server controls and more.
- Do I need to learn any language, or tool to start using the generated webforms?
AspxFormsGen 3.5 is super easy to use. As a matter of fact, there's just One main interface, and One main button to click. If you know your
MS SQL Server name, Database name, the Username and Password to your MS SQL Server, the Namespace you want for your generated WebForms, then you're set,
just click the "Submit" button, it's that simple.
Click here
to see a snapshot of the Main interface of AspxFormsGen 3.5.
AspxFormsGen 3.5 was created for ASP.Net programmers, therefore you need to know ASP.Net. There's also the understanding that you already know MS SQL 2000 or 2005, since you need a database for AspxFormsGen 3.5 to look at to be able to generate the webforms. Some of the generated webforms also contains AJAX Control Toolkit Extenders such as the ValidatorCallout, ModalPopup, etc, you may need to familiarize yourself with this toolkit. ASP.Net 3.5 is a very new technology and as such, you may need to familiarize yourself with some of the technologies that came with it, some of which are contained in the generated webforms. Some of the technologies or controls used in the generated webforms are: LinqDataSource, Linq-to-SQL class and coding, ListView, and more. Although these are new technology, you can use the generated webforms to study how these technology and server controls work. You also need to know either C# or VB.Net. Generally, all the technologies listed above are ASP.Net 3.5 specific technologies.
- What kinds of webforms are generated by AspxFormsGen 3.5?
There are several webforms that are generated by AspxFormsGen 3.5. To see the description of each, please click here.
- Will the generated webforms work with ASP.Net 2.0 website?
Approximately 90% of the generated webforms will only work with a ASP.Net 3.5 website or project because most of the generated webforms are using ASP.Net 3.5 specific technologies such as the LinqDataSource control, Linq-to-SQL (.dbml) class files as well as code, and more. However, the generated unbound webforms, themes (stylsheet and skin file), javascript files, will work just fine with ASP.Net 2.0.
- Does AspxFormsGen 3.5 generate CRUD (create, retrieve, update, delete) stored procedures?
No. AspxFormsGen 3.5 uses the native Linq-to-SQL class file to do CRUD operations in the database.
- Can AspxFormsGen 3.5 generate webforms using an Oracle database?
No. AspxFormsGen 3.5 only supports MS SQL 2000 or 2005.
- Can AspxFormsGen 3.5 generate webforms using SQL Express?
Yes. You need to attach your SQL Express database to an MS SQL 2000 or 2005 database to do this.
- I can't find the AJAX Control Kit Extenders in my Visual Studio 2008 toolbox, why?
You need to install/add the AJAX Control Toolkit in your Visual Studio 2008 toolbox. AJAX Control Toolkit is a component.
- Does AspxFormsGen 3.5 overwrite my existing generated webforms?
Yes if the generated webforms path is the same as your current project's path/directory. Make sure to use a path/directory other than your project path/directory, then just copy the webforms you need into your project/website. E.g. if your website path is: C:\Inetpub\wwwroot\YourWebsitePath, then choose a different path for your generated webforms, e.g. use C:\GeneratedAspx instead.
- Why do I get an "Access Denied" error when I try to generate webforms using AspxFormsGen 3.5?
This means that you don't have access to the path/directory where you are trying to put the generated webforms. Make sure to choose a path/directory that you have write access to.
- Why can't AspxFormsGen 3.5 access my MS SQL 2000/2005 database?
You need admin rights on this MS SQL 2000/2005 database. If you already have admin rights to the database, then make sure that your username and password are correct. A blank password will not work.
- I bought the previous version of AspxFormsGen, is there a discount if I buy AspxFormsGen 3.5?
We want to make our customers happy, please email us at support@junnark.com and we'll send you a special link to a discounted price.
- Is my purchase of AspxFormsGen 3.5 refundable?
No. Please download AspxFormsGen 3.5 Express, this is our free product.
- I have the previous version of AspxFormsGen installed in my pc, can I install AspxFormsGen 3.5 alongside the previous version?
Yes. AspxFormsGen 3.5 was built from the ground up because of the new technologies that came with Asp.Net 3.5.
- Can I pick just the tables which I want the webforms to be generated for?
No. Our motto says it all, "One Click". AspxFormsGen 3.5 was created to make ASP.Net programmers to be more efficient, with this in mind, we don't want you to spend too much time trying to figure out how to use AspxFormsGen 3.5, we want you to be able to just use what you already know, e.g. database name database username, database password, namespace that you want for the generated webforms to use, the path/directory where you want the generated webforms saved, and the style of the generated grid, do one click and you have generated webforms. You will also notice that there's one main interface used by AspxFormsGen 3.5.
- Is there a tutorial for AspxFormsGen 3.5?
Yes, please click the following links. Professional Edition, Express Edition.
- What language will the generated webforms be?
AspxFormsGen 3.5 generates ASP.Net UI files (.aspx) with your choice of either C# 3.5 or Visual Basic 9.0 code behind files.
- What is the GridView Style drop down list on the AspxFormsGen 3.5 interface?
The GridView Style is a collection of styles for the generated webforms that has GridView Server Control.
- Do you have samples of the generated styles?
Yes. Please click here.
- What's the difference between AspxFormsGen 2.0 and AspxFormsGen 3.5?
Please click here for a side by side comparison of these products.
[ back to top ]
Product Comparison
Listed below are the comparative features of AspxFormsGen's Express, Standard, and Professional editions. Click the links
provided below for sample snapshots of the respective features.
| |
AspxFormsGen 3.5
Professional Edition |
AspxFormsGen 3.5
Standard Edition |
AspxFormsGen 3.5
Express Edition |
| |
 |
 |
 |
| Technology Features |
| Made for ASP.Net 3.5 using C# 3.5 or Visual Basic 9.0 |
 |
|
|
| Generated WebForms are compatible with Visual Studio 2008 |
|
|
|
| Linq-to-SQL database access |
|
|
|
| AJAX Control Toolkit Extender integration |
|
|
|
| WebForms bound to MS SQL 2005, 2000, or SQL Express |
|
|
|
| ASP.Net 3.5 new controls: LinqDataSource, (ListView for Professional Edition only |
|
|
|
| Generated ASP.Net Webforms/Objects |
| List of Created WebForms (Default.htm) |
|
|
|
| Unbound Views |
|
|
|
| Admin WebForms w/ GridView |
|
|
|
| Read-Only WebForms w/ GridView |
|
|
|
| WebForms w/ Grouped Data (ListView w/ nested GridView) Accordion-style |
|
|
|
| WebForms w/ Grouped Data (ListView w/ nested GridView) Toggle Visibility-style |
|
|
|
| Add a New Record WebForms |
|
|
|
| Update a Record WebForms |
|
|
|
|
User Control used by the Add and Update WebForms
C# /
VB
|
|
|
|
| Read-Only WebForms |
|
|
|
| Generated ASP.Net Miscellaneous Files |
| Functions.cs/Functions.vb |
|
|
|
| SkinFile.skins |
|
|
|
| StyleSheet.css |
|
|
|
| GridViewScript.js |
|
|
|
| SlidingColapse.js |
|
|
|
| ToggleVisibility.js |
|
|
|
| Blank MasterPage.master |
|
|
|
| web.config |
|
|
|
| .dbml LINQ-to-SQL class file |
|
|
|
| WebForm with GridView Features |
| Admin GridView Functionality Snapshot |
|
|
|
| Add New Record Link |
|
|
|
| Update Record Link |
|
|
|
| Delete Record |
|
|
|
| Sort Image Direction |
|
|
|
| Sorting |
|
|
|
| Paging |
|
|
|
| More Information Link for Foreign Keys |
|
|
|
| On Hover Row Background Color change |
|
|
|
| Delete Confirmation |
|
|
|
| Delete Animation |
|
|
|
| Delete Constraint Alert |
|
|
|
| Update Progress |
|
|
|
| LinqDataSource Control |
|
|
|
| WebForm with Add/Update Features |
| Validator CallOut Extender |
|
|
|
| Calendar Extender |
|
|
|
| Databound Foreign Key DropDownList |
|
|
|
|
Linq-to-SQL Update and Insert
C# /
VB
|
|
|
|
| Standard ASP.Net Server Controls: TextBox, DropDownList, CheckBox, FileUpload, Button |
|
|
|
| Filtered TextBox Extender |
|
|
|
| Required Field Validator |
|
|
|
| Pricing |
AspxFormsGen 3.5
Professional Edition |
AspxFormsGen 3.5
Standard Edition |
AspxFormsGen 3.5
Express Edition |
|
 |
 |
FREE |
1 (One) Developer License, no royalty for all generated objects. |
|
|
|
Note: You will be redirected to PayPal when you click the "Buy" buttons above,
tax will be automatically added to the purchase price.
Also, For Corporate License, please send us an email with the subject aspxformsgen corporate license.
|
[ back to top ]
Requirements:
- .Net Framework 4.0
- MS SQL Server 2008, 2005, 2000, or an attached SQL Express.
- Visual Studio 2008, or 2010
- Windows 7, Vista, or XP
[ back to top ]
Recommendations:
-
Username/password used in AspxFormsGen must have admin or enough priviledges in
the database that you're going to work on.
- Use a local MS SQL Server if possible.
- Use No spaces when creating Table names or Field names in your database.
- Use Alphanumeric characters only when creating Table names or Field names in your database.
-
Use upper case letters for Table names and Field names if you have any plans of
using Oracle in the future.
- Create explicit relationships for your tables using Diagrams.
[ back to top ]
Limitations
-
Does not support retrieval of Large Value Data Type Columns (binary data
types). A default textbox is created for these data types.
-
Does not support new data types in MS SQL 2008. A default textbox is created for these data types.
- Does not create webforms for database tables that has no explicit primary key definition.
- Generates a very simple Themes, skin file, and style sheet for the generated webform's
presentation purposes only. Additional objects can be added to these files as you need them in your application.
-
The error "The primary key column of type 'TinyInt' cannot be generated by the server" is a LINQ-to-SQL issue. Therefore if
you're using a TinyInt identity data type in your database, you will encounter this error.
-
Special data types such as the "sysname" is not supported by LINQ-to-SQL. We also recommend not use system data types.
-
XML data types cannot be submitted when adding or editing, or any data that have script characters such as "<" the less than
sign. Any submittion is caught by IIS, and an error is thrown. Our generated WebForms does not override this functionality
for security reasons. You can however turn this functionality off in your WebForm.
- Sorting an XML data type field is not supported.
- User-Defined data types are not supported, although for most parts this will work with the generated WebForms.
[ back to top ]
Notes:
-
* Approximately 7 seconds for the professional edition, and 3 seconds for the
express edition. The professional edition generates approximately 10 times the
number of Webforms than the express edition.
-
** Relationships between related/associated tables must be explicitly
established in the information schema of your database. Selected values for the DataValueField and
DataTextField are the primary key column and the next non-primary key column in the foreign table, respectively.
-
*** AspxFormsGen 3.5 Express Edition is free. AspxFormsGen Standard and Professional
Editions are for sale. Please see the AspxFormsGen product matrix.
[ back to top ]
|
|
