Creating a Data-Driven Web Site (Almost) Automatically

If you could have a database of a few kind and want to create ASP.NET internet pages to permit customers to checklist, upload, edit or delete data from that database, you could have a few alternatives. One method is to design and code the entire pages your self (applying any present routines you will have). That will also be very concerned — now not handiest do you need to create the consumer interface, you even have to determine one of the simplest ways to get right of entry to the database, supply for consumer authentication, internet website safety, reporting, knowledge import and export — an entire checklist of important options. In many instances there is also an more straightforward method — an ASP.NET code generator.

There are more than a few code turbines to be had, starting from easy template sorts to very refined systems like IronSpeed Designer. Some of those turbines be offering handiest minimum assist and a few are superb merchandise, however include a top ticket. I’ve attempted a number of other ones and in any case made up our minds on ASP.NET Maker (www.hkvstore.com). It’s quite priced at $200 and contains unfastened obtain of any minor upgrades for 12 months. It works with Microsoft Access, Microsoft SQL Server, MySQL, Oracle or some other database that helps ODBC or ADO connectivity, and simply by settling on more than a few choices on display screen you’ll be able to generate a complete set of internet pages to checklist, upload, edit, delete, or seek for database data. You too can arrange a consumer registration device, complex safety features, document importing, easy studies and exporting of information to csv, Excel or Word information.

Need some further capability? You can do this too. ASP.NET Maker will provide you with the choice to go into your individual customized code (in both VB.NET or C#) for more than a few pre-defined server occasions (akin to “Page_Loading” or “Row_Deleting”). Your code will also be saved as a part of the.aspx internet web page or you’ll be able to make a choice to make use of a separate “code in the back of” document. You too can input Javascript to take care of client-side processing like customized shape validation. All your customized code is stored as a part of the challenge you are running on and is robotically incorporated each and every time you’re making adjustments to the challenge and re-generate your internet web page(s).

I must point out that ASP.NET Maker makes use of HTML controls, now not asp.web internet controls. If you wish to have to make use of customized code for one thing instead of the server occasions equipped for in ASP.NET Maker, you could have a few choices. There is a transfer within the grasp template document that controls ASP.NET Maker which will also be set so as to add “runat server” to each and every HTML keep an eye on; that can permit you to catch sure data on postback. If you are the use of a code-behind document and are used to running with common asp.web controls, you’ll be able to additionally upload your individual shape observation. Just insert one thing like earlier than the observation generated by means of ASP.NET Maker. Then code your asp.web keep an eye on(s) inside of “form1” and finish with a . Once you have performed that you’ll be able to manipulate your asp.web controls and the ideas from the ones controls within the code-behind web page. The handiest drawback is that you can want to save your pages that experience this type of custom designed code and duplicate them again into your challenge each and every time after you re-generate your internet pages (to over-write the usual pages ASP.NET Maker creates).

The center of ASP.NET Maker is the set of displays the place you input the ideas the device makes use of to create your internet pages:

Data Source Setup:

You use this display screen to go into data akin to your database kind, server identify, port (if now not the default), consumer identification, password, database identify and connection string.

ASP.NET Settings:

This display screen means that you can set the default date layout and whether or not or now not you wish to have to make use of caching. You too can set more than a few choices for document importing, introduction of audit trails, and for shape validation processing.

HTML Settings:

This display screen means that you can input a name to your website online, the nature set, font and textual content measurement you wish to have to make use of as a default, a website brand (if in case you have one), and footer textual content (if any). There also are tabs which let you edit the default theme to your website and the default CSS types (even supposing I’ve all the time used the default settings and so they appear to paintings beautiful smartly for our customers).

Security Settings:

You can input a hard-coded administrator ID and password in this display screen and you’ll be able to additionally arrange non-compulsory User ID and User Level Advanced Security to give protection to your knowledge from unauthorized get right of entry to.

Menu Editor:

The menu editor means that you can alter the default menu that ASP.NET Maker generates to your internet website. You can upload, edit or delete menu pieces, transfer them up or down, disguise sure pieces – even upload menu choices that redirect to non-ASP.NET Maker pages.

Table Setup:

This is probably the most complicated a part of your challenge setup. The higher segment of this web page is a grid appearing the to be had choices for each and every desk to your database. The decrease segment of the web page comprises table-specific choices and grasp/element setup data for whichever desk is these days decided on. You can make a choice which tables you wish to have to generate internet pages for, what caption you wish to have to show for each and every box within the desk, whether or not of now not you wish to have to use a filter out to the data within the desk, how you wish to have the data looked after, and numerous different pieces akin to whether or not you wish to have to allow inline upload, edit and duplicate, whether or not you wish to have to make use of CAPTCHA at the upload web page to stop automatic posting, and whether or not you wish to have to permit updating of a couple of data on the identical time.

Generate Settings:

This is the place you specify the site of your supply information and the vacation spot folder for the generated asp.web information. You too can make a choice to robotically browse your internet pages as soon as they’ve been created since ASP.NET Maker makes use of a duplicate of the freeware Cassini internet server to run asp.web pages.

ASP.NET Maker additionally comes with a quite complete assist document which covers the way to create your challenge step-by-step. In addition, the assist document contains transient tutorials on grasp/element information, document importing, consumer registration, complex safety choices, customized perspectives, and developing easy studies.

I’ve in fact used ASP.NET Maker to generate the vast majority of the code for a human assets bundle and for a time clock device. It may not do the entire give you the results you want, however in case you are searching for a snappy strategy to expand a knowledge pushed internet website with minimum hand coding, ASP.NET Maker is also value having a look into. It has barriers, but it surely does just about what it claims to do and it sort of feels very strong — thank you indubitably to the sizable quantity of people that use it and feature crushed lots of the insects out of it.

I’ve coated the details on this article, however it is mainly only a fast review of the product. If you are getting a bit of extra in-depth take a look at ASP.NET Maker, you’ll be able to obtain a tribulation model at http://www.hkvstore.com.