Back to Top
The nuts and bolts for
Creative web development

DMXzone Database Updater ASP

“Define and connect your database update actions”

Perform Database Updating actions on any well-known database without any SQL and ASP knowledge! The DMXzone Database Updater ASP Dreamweaver extension gives you the power to manage the data in your databases in a whole new way through Ajax technology! You are submitting, saving and reloading your data without any page refresh! Perfect for building dynamic web sites and single page apps. Fully integrated visual tools and server code generation are available at your disposal!
The DMXzone Database Updater includes an amazing Database Updater Action Builder that will allow you to build fully visual an advanced insert, update and delete queries to your database source without any SQL knowledge! It even supports advanced filtering and for multiple update and delete actions!  With the powerful Database Updater Action Executor you can define where Database Action should get its data from when executed. You quickly pick any data from the available HTML5 Data Bindings, like form fields but also any other data! Finally with the build-in Control DMXzone Database Action Executor behavior you can trigger the update action anywhere on your page you want, like on a link click, form submit or even automatic on page load!

The extension uses the connection wizard from DMXzone Database Connector ASP to define, select and use your database connections, so a full cross platform databases support is guaranteed!

DMXzone Database Updater ASP requires DMXzone Database Connector ASP and Classic ASP. It allows you to connect to any database with ASP ADO without any programming or ASP/ADO knowledge. You need a Windows web server with ASP support to use it.

Features

Database Updater Action Builder

The Database Updater Action Builder lets you visually define any database update action. A database action defines a single global action for your site that executes a record insert, update or delete. You can have as many database actions as you wish and you can reuse them on multiple pages. Each database action just defines the database table it is operating on, which columns receive values and if any filters are applied for record selection. Database actions are executed by the so called Database Action Executors fully thought AJAX , so that you can execute them without any page refresh!

  • Insert record - Use the insert type of action to insert new records into a database table.


  • Update record - Use the update type of action to update existing records in a database table. You can also update multiple records.


  • Delete record - Use the delete type of action to delete rows in a database table. You can also delete multiple records.


  • Manage connections - The Database Updater Action Builder allows you to create and manage connections to servers with the DMXzone Database Connection wizard dialog.


  • Easy table and column pickup - You can quickly add your table to be listed in the columns pickup view. From there you can choose the columns to be populate with data and filters to be used.


  • Add, duplicate and remove database actions - In the action wizard you can add as many actions as you want, delete or duplicate them.


  • Add and remove database table - From the table manager you may add or remove a database table to pickup columns from.


  • Column values - Select the columns of your table that should be updated with new values. You can use the following sources:

    • POST variable - Fields data submitted from your page with Database Action Executor or regular post request
    • Entered value - Entered value defines a static value.
    • URL parameter - Parameter passed in the page query string
    • Cookie - Stores retrieved cookie values.
    • Session variable - You can use session variables to store and display information maintained for the duration of a user’s visit (or session). The server creates a different session object for each user and maintains it for a set period of time or until the object is explicitly terminated.
    • Application variable - In ASP you can use application variables to store and display information that is maintained for the lifetime of the application and persists from user to user. After you define the application variable, you can use its value in a page.


  • Records filtering conditions - The filters list contains conditions that are applied to database action when executed. There are basic conditions like =, <, > as well as advanced, such as contains, begins with, ends with and between. This way you can limit the database action to specific records. You can use the same value sources as with column values.

  • Required fields - You can check mark any column or filter that is required to have a value.

Database Updater Action Executor

Database Action Executors let you run a database action with specific data assigned. So if you have defined to use a database action to update your database table columns, now with the Database Action Executor you can assign the values for those columns. That is why you define a database action globally to your site, so it can be reused, but define a specific executor on your current page where your data is in for example some form with fields.

  • Assign the data for the Database Action - Quickly choose an already defined Database Action or create a new one and then just assign the data source for its columns and/or filters.


  • Easy data bindings pickup - Just select data source field from the available data bindings, displayed in the data bindings tree left and assign it to the corresponding database column field or filter, on the right, that is defined for the selected Database Action.


  • Add, duplicate and remove database executors - In the executor wizard you can add as many executors as you want, delete or duplicate them.


  • Quickly assign Database Action filter values  - If you have defined to use a database action to update or delete records from your database based on a filter, you can now assign values for this filter.


  • Full support for HTML5 Data Bindings Formatter - If you have the HTML5 Data Bindings Formatter extension installed you can get the power of the 47 supplied formatting filters, directly in your Database Updater Action Executor wizard dialog.



  • Execute asynchronous - You can enable the asynchronous execute of the Database Action so that the user browser is not blocked while the action executes! This gives you the best user experience.


  • Display alert errors - An alert message has been displayed when the action is not executed properly. 


  • Database Updater behaviors -  If you want to execute follow up action and/or behaviors depending on the result of you database action you can use our Behavior Connector to bind to the right events.


The following events are available:
  • Before the action is executed - This event is fired before the action is executed. For example, you can show here a preloader or a message that the action is being executed now. Also, you can use this event for extra validation.

  • When the action is finished - The event is fired when the action is done, successfully or with an error. This is the place to hide your preloaders as the call for data is finished. After this you can even execute others depending if data was successfully received or an error has occurred.

  • When the action is successfully executed - This event is fired when the action is successfully executed. You can show a success message here that the action was executed successfully. Also you can set to refresh your data to see the changes, without refreshing the page.

  • When an error has occurred - This event is fired when an error has occurred during the data fetch. You can show an error message here that the action has failed.

Control Database Action Executor Behavior

After defining your Database Update Action and assigning data to it with the Database Action Executor, you are now ready to run it! This is where the Control Database Action Executor behavior comes in place. Just like any other behavior you can add to a specific event like click on a button or link to trigger the executor to runs its database action! You can even add the behavior through the Behavior Connector so the action executes for example as a follow action on a different database action or event from other DMXzone extensions.

  • Control DMXzone Database Action Executor - Once your database actions are defined with assigned data to them, you need the control database action executor behavior in order to run them.


  • Choose one of the available events - You can add to a specific event like click on a button or link to trigger the executor.


  • Run your Database Action through the DMXzone Behavior Connector - You can use the DMXzone Behavior Connector to run your database action as a follow up action.


  • Control DMXzone Database Action Executor Actions- The available actions in the Control DMXzone Database Action Executor are run and abort that you can choose from. 


  • Run the DMXzone Database Action Executor - Once you select the run action it triggers the selected Database Action Executor.


  • Abort the DMXzone Database Action Executor - You can apply the abort action for certain executor for example in case a validation fails.
  • Data override - It allows you to override the existing data setting such as value for insert, and value and filters for update/delete. 


Once you click the data override, the Database Updater Action executor window opens where you can change what you want to override.
 

Showcases


  • Share Your Location Showcase

    For this showcase we created a page that displays locations on the map. In order to do that we used HTML5 Geo Location which stores your current location when you hit the 'share location' button. ...

  • Task Management App Showcase

    In this task management app demo page you can create tasks, see what you need to do, track your progress and see what you've already done. The page has been created using DMXzone Boostrap and ...

  • Travel Blog Showcase

    For this showcase we used HTML5 Data Bindings in order to connect to our database where the cities will be stored. From the available form, you can choose a city with the help of Ajax Autocomplete to ...

  • Cooking Blog Showcase

    For this showcase we used HTML5 Data bindings and DMXzone Database Connector to connect to our database where the comments are stored, using the DMXzone Database Updater. To write a comment you can ...

  • Tasks Management System

    For this interactive task management system we used a few DMXzone extensions in order to allow you to add tasks, assign them to different users, set priority levels and due dates. You can edit any of ...

  • Swiss Web Factory User Showcase

    For the amazing website, André Bender, CEO and founder of Swiss Web Factory used Dynamic Database Connectivity Collection PHP, which features our most advanced extensions that allow you to ...

  • Smart Temperature App Showcase

    For this smart temperature web app we have the temperature value stored in a database, which can be changed by dragging the slider. Also the background color changes according to the temperature ...

  • User Management Dashboard

    For this interactive management dashboard we used a few DMXzone extensions in order to make it sortable by name, location, role and status from the top arrow buttons. Below the table you can see the ...

  • Event Manager App Showcase

    For this showcase we build a dynamic event manager application with the HTML5 Data Bindings, where you can edit the date and time of an event with a click of a button. In order to do that we used ...

  • Car Care Services Showcase

    For this showcase we designed online schedule where you can add the date of the entry and due date with DMXzone Calendar 2, also choose between the different car models and available services and ...

  • Mobile Devices Reviews Blog

    For this reviews blog page we used HTML5 Data Bindings and DMXzone Database Connector PHP/ASP in order to retrieve the images and text from our database. Also you can post a comment using the ...

  • Content Management Showcase

    For this site content manager we used the HTML5 Data Bindings and DMXzone Database Connector in order to retrieve the services images and information from our database. Each service is editable on ...

  • Car Manager Dashboard Showcase

    For this car manager dashboard we used the HTML5 Data Bindings and DMXzone Database Connector in order to retrieve all images and information from our database. Each car specification is editable ...

  • Halloween Admin Store Showcase

    For this store admin page we used the HTML5 Data Bindings and DMXzone Database Connector in order to retrieve all images and text from our database. Each product detail is editable with the help of ...

  • Shopping List Assistant

    For this showcase we used dependable dynamic dropdown list for our category and products. Once you choose a category, a second dropdown list appears with the available products and another one for ...

Videos


Requirements

Type: Behavior
License: External link
Product: Dreamweaver CS5/CS5.5 and CS6, Dreamweaver CC
Database: Access, SQL Server, MySQL
Platform: Win XP/2000/2003/2008/7, Mac OS X, Mac OS X 10.4+
Used Technologies: jQuery, Ajax
Tags: database, updater, ASP, SQL, jQuery, Ajax


This Extension Requires:


HTML5 Data Bindings

Connect to your data

So you want to build dynamic web apps and interactive pages? Empower solutions like single page apps and Ajax driven websites? This is all possible with the new HTML5 Data Bindings Dreamweaver extension. The extension is powered by a stunning jQuery based template engine that helps you populate your data super-fast on the page. Your data is represented fully visual in a tree so you can bind it directly on your page in Dreamweaver design mode. Also, you can add smart repeat regions, detail ...

Read More


DMXzone Database Connector ASP

Connect to your database

Access any well known database without any SQL and ASP knowledge in Dreamweaver! This is what the DMXzone Database Connector is all about! Fully integrated visual tools and server code generation are available at your disposal! The extension features a built-in connection wizard where you can define and manage your connections to all well known databases. Choose from ready to go connections for MySQL Microsoft SQL Server, MS Access and many others!The DMXzone Database Connector includes ...

Read More

History

Version 1.2.1

  • Improved for Dreamweaver CC 2014
  • Improved for DMXzone Extension Manager

Version 1.2.0

Update instructions:
Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Updater / Manage Database Actions ... and then click on "Reapply All"

Version 1.1.1

Version 1.1.0

  • Added full support for the new DMXzone Security Provider PHP/ASP for secure database update actions.
  • Greatly improved the storage and caching of database structure info. It is all store now in the connection file so refreshing when database structure changes is really easy.
  • Improved the schema refreshing on Database Updater Action Builder dialog.
  • Added "Reapply all" buttons to Database Updater Action Builder.
  • New Behavior Connector Events for integration with DMXzone Security Provider PHP/ASP to allows you to react when the users is not logged in or does not have enough permissions.
  • New states in the Data Bindings tree per Database Actions also for user permissions.
  • Primary keys in database columns view - You can see now directly which database columns are used as primary keys on the different icon in front.

Update instructions:
Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Updater / Manage Database Actions ... and then click on "Reapply All"


George Petrov

George PetrovGeorge Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. His expertise in countless languages and technologies gives inspiration and teach valuable lessons on his website – DMXzone.com which is most popular for its over high-quality Dreamweaver extensions and templates.

See All Postings From George Petrov >>

Share this Article