Features
smartDBforms.NET for ASP.NET 2
 
 
Overview Features Benefits Online Demo Free Trial Documentation FAQs
Testimonials
It’s really refreshing to use. Looking at codegen products that are way overkill and generate source code that’s not maintainable - your product rocks.


I have demoed several other products also, and none came close to yours. The simplicity, ease of use and user friendliness were impeccable.
William Joshua
Madison County Schools


Thanks to smartDBforms.NET I am able to save lots of time and make even better websites. I am looking forward to use this tool to help me build websites based on databases.
Anton Beerens
www.blauwwit81.nl


We are really impressed with smartDBforms.NET and there is nothing else on the market as good.
Andy Jones
Make I.T. Simple
www.makeitsimple.info
smartDBforms.NET Features
smartDBforms.NET comes with a lot of useful features, which you will find below. Illustrative screen shots are available as well.

Creating database web forms in Visual Studio Design View without writing a single line of code.
To create a database form in Visual Studio you drop an instance of the SmartDataSource control and an instance of the SmartDBView container. Then you select the 'Create all fields' smart-tag command, reorder the created SmartDBControl instances at your wish and create the operation buttons you need( New, Update, Insert..). This is all you need. The created form will be able to display, insert, update and delete the data specified in the SmartDataSource control.
Flexible paging user interface.
You can have a data pager with just one mouse click. You can further choose between built-in templates or create your own paging user interface.
Easy search UI creation
Easy creation of search user interface. The user interface is created according to the select and filter parameters of the SmartDataSource control.
Seamless integration with Visual Studio
smartDBforms.NET framework relies on standard ASP.NET elements - custom server controls, custom data control, ASCX pages, Web.config configuration section, two-way databinding, smart-tag panels. It does not involve any proprietary tools thus making it very quick and easy to learn.
 
User interface selected dynamically at runtime.
When SmartDBControl is databound it passes the meta data information to the user interface templates collection(template set). The template set determines the most suitable user interface template by inspecting the meta data information.  
Auto template selection is available also at design time if a precompiled template selector is provided.
 
Automatic foreign key columns handling. Supports not only single but also multi-column foreign keys.
When the database field participates in a foreign key reference, the needed information is extracted from the database and provided to the user interface template in an unified manner. The parent table data is displayed in a list with proper description text for each row. If the foreign key is a multi-column foreign key, then the values for all participating fields are extracted and transferred to the insert or update sql command.
 
Automatic error handling
The OperationStatus web server control displays success and error messages when the database operation has completed. It has default user interface which can be easily customized. You can even have more than one message areas positioned anywhere on the page.
A collection of ready-made user interface templates and their mapping to data types.
smartDBforms.NET comes with a ready-made template collection(template set)  that comprises all basic sql data types. The collection uses standard ASP.NET controls. You can modify this template set or create your own. You can also use third-party web controls.
Rapid user interface development.
SmartDBView provides the following smart-tag commands that instantly create the user interface for the selected database source: Create All Fields, Create All Fields In Table, Create Missing Fields, Create All Buttons. Using these commands the developer can create the user interface elements with just one mouse click and then use the HTML Designer to modify the form layout.
Easy template modification from the Visual Studio Design view.
The user interface templates are created and modified in the standard Visual Studio HTML Designer. You drop an instance of the TemplateHolder control and then insert the preferred controls and bind them to the data fields. These templates will be used in all web pages that contain the SmartDBView Web server control.
Automated update, insert and delete of the data.
When working with SmartDBView at design time, using the smart tag commands you can create update,insert and delete buttons. The process of inserting, updating and deleting is fully automated and the only responsibility you have is to drag the button at the proper position. These buttons will trigger the corresponding action. All parameters will be extracted from the user interface and passed to the data source control.
Easily create duplicate of existing rows.
The Clone/Duplicate command button allows the user to create a new database record by using the data form another database record. Allows to create a copy of the currently selected data row. Brings SmartDBView in insert mode. In addition initializes the user interface with data from the currently selected data row.
Two-way data binding.
Supports the standard ASP.NET 2.0 two-way databinding. SmartDBView control is a databinding container and inherits from DataBoundControl. It allows you to define two-way data binding expressions with all contained server controls.
Update, insert and delete statements generated automatically from the select statement.
The SmartDataSource control is similar to the standard SqlDataSource control and has the same functionality of creating the matching insert, update and delete statements once you have defined the select statement.
Automatic data validation.
Each user interface template can have unlimited number of validating controls. At runtime these controls are rendered automatically together with the user interface and are triggered just before the insert or update operations are executed.
Flexible way of defining the mapping between data types and user interface templates.
Once you have defined your own template collection(template set) then you have to define the mapping between each data type and the corresponding user interface template. For example: for fields with data type of String use the "StringTemplate", for fields of type Int16, Int32 and Int64 use the "IntegerTemplate". This is done by overriding a special function, which receives the descriptor of the field as input parameter and returns the identifier of the user interface template to use. You can code this function directly in the template set file or you can put it in another assembly and reference it with its full name. The second way has the advantage that the selection function will be used at design time also, giving one to one correspondence between the user interface at design time and runtime.
Default values for insert mode.
The parameters of the insert sql statement in SmartDataSource may have default values. When displayed in Insert mode SmartDBControl will use these default values and will prefill the user interface with them.
Supports MS SQL server 2000 and newer versions.
Support for other database servers is planned for next major versions
 
Design time smart tags.
All design time operations that can be applied to the controls of the smartDBforms.NET framework are available as smart tag items on the design time surface.
Automatic linking to the referenced .css files.
When defining your own user interface templates you can put all styles in a .css file and reference this file with the SmartCSSLink control. When these templates are used in a SmartDBView container, the referenced css files will be automatically inserted in the header of the web page.
Label and layout templates can be reused by the user interface templates.
Each user interface template needs one additional template for the label and one for the layout. You can define these label and layout templates per user interface template or you can define them once and reference them in all user interface templates.
Localization supported.
You can localize all captions and descriptions by using a global resource file. Just specify the name of the file in Web.config and all captions and descriptions that SmartDBControl displays will be localized according to the web page's UICulture setting. There is a default pattern for the resource Id's. For example for the field "ProductName" in "Products" table the resource Id for the caption will be "Products.ProductName.Caption". You can override the default caption and description resource Ids.
Data caching supported.
The SmartDataSource server control supports caching of the retrieved data in the same way as the standard SqlDataSource control. The data can be cached on the asp.net server thus avoiding redundant round trips to the sql server.
Ad hoc customization.
There is possibility to make quick changes to the appearance and behavior of the user interface templates. You can use the AdHocProperties, the CustomEvent and CustomCommand events to define a way for interaction between the user interface templates and the developer of the database form.
Copyright 2006-2013 Adillis Terms Of Use Feedback Contact Us