Back to Top
The nuts and bolts for
Creative web development

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 also an amazing Database Source Query Builder that will allow you to build fully visual an advanced query on your database source without any SQL knowledge! It even supports advanced filtering and joins options and lets you directly view and test your database! 

With its great integration in HTML5 Data Bindings you can visualize your database structure fully visual in Dreamweaver with the HTML5 Data Bindings floating panel, from which you can easily populate it on your pages or create repeat regions from it.

The built-in Pagination uses native paging techniques specific for each database so you don't need to do any SQL magic by yourself. It also has dynamic Ajax alike paging, dynamic page navigation links and show/hide regions, which allow you to make a special conditional region of any data repeating element.

The extension requires 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 Connections

  • Built-in connection wizard - The built-in connection wizard allows you to connect to your database easily and get your data the Ajax way. It comes with full support for wide range of well-known databases and uses specific adapters for each type database so that it can use the native power of the database without bothering you with weird SQL syntax!


  • Support for standard PHP and ASP server types database - The extension comes in PHP and ASP versions. If you have both installed in your HTML5 Data Bindings you can choose between PHP and ASP server technology otherwise the field will only display the installed one. 


  • Select from various database types - The extension supports standard ASP and PHP databases.

    • PHP database types - MySQL, PostrgeSQL, SQLite, SQL Server and SQL Server Native.


    • ASP database types - Access, Access ODBC, MySQL ODBC, ODBC File DSN, ODBC System DSN, SQL Server, SQL Server Express.


  • Custom connection strings - In order to connect to your database you can always enter your custom connection string, which follows the syntax for PDO, if you're using PHP, or ADO if you're using ASP.


  • Database type properties - Depending on the chosen database, the connection wizard pops up different options to build your connection string automatically so you don't have to worry about weird connection string syntax.


  • Test your database connection - Once the connection to your database is established, a confirmation window pops up. If it's not connected properly an error message appears on the popup window.


  • Add, delete and duplicate the current database connection - In the connection wizard you can add as many connections as you want and delete each one of them with a single click. Also you can duplicate connections in order to save time when applying small changes.


  • Connection wide options - You can set the maximum allowed returned records from this connection as well as to enable the debugging info option that will bring you additional information in the browser and help you in your development process. 


Database Source Query Builder

  • Full database schema reading support – The Database Connector connects to your database and reads its full schema like tables, columns and data types so that everything is available as pickup options in Dreamweaver for its visual Query Builder tool!

  • Fully automatic SQL generator – When using the Database Connector, you never need to bother any more with writing SQL queries! Actually you don’t need to write any SQL as everything is fully generated for you! As the extension ‘ knows’ the different SQL dialects for each database it uses the power features of this specific database, automatically!

  • Automatic data types conversion – The extension automatically knows your database column types and does the right conversions of your data types.

  • Full Data Type Validation and Enforcement - when various data types are being used as input, for example as filter parameters, those are first validated against their type. This makes your pages extra secure against various SQL injections attacks

  • Easy tables and column pickup - you can quickly add tables to be listed in the columns pickup view. From there you can populate your selects, filters and sort orders. When adding more then one table, a special Table Joins Manager dialog will appear. Using the Database Source Query Builder is a breeze, just select the connection, addatable to the columnpicker tree, add columns from it to the selects, filters and or sort orders and you are done!


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


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


  • Test connection source - Once the connection to your database is established, a database source testing window pops up. It lets you test your source and view the results in a browser.




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


  • Table column aliases - To improve the readability of your result tables you can assign column aliases.


  • Individual column filtering conditions - The conditions node lists conditions which must be met before the filter can be run. There are basic conditions like =, <, > as well as advanced, such as contains, begins with, ends with and between. Contains and begins/ends with are very powerful string searching operators that incorporate the native database search options.


  • Individual column filtering functionality - The filtering functionality is very useful for quickly search through the information in the table and allows you to filter only a particular column of data. You can specify a filter to each table column.
    • Filter by entered value - Entered value defines a filter with static value.
    • Filter by URL parameter - URL parameters store retrieved information input by users. When you are defining a database source with filters you can choose that filters come from URL parameters. Those filters will be then directly available for usage on the HTML5 Data Source dialog. Also if you have enabled some fields to be " sortable"  those will be available there as well.
    • Filter by form variable - Form parameters store retrieved information that is included in the HTTP request for a web page. If you create a form that uses the POST method, the data submitted by the form is passed to the server.
    • Filter by cookie - This filter stores retrieved cookie values.
    • Filter by 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.
    • Filter by 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.


  • Multiple filters conditions - You can add as many filters you want! On each sequential filter you can choose the logical operator (and/or) to be applied with the previous one.



  • URL parameter filter - Once you added URL filter parameters in the Data Source Query Builder dialog, you can edit the parameter value any time later, directly in the Data Source window.


  • Selected column sort order - Once you made a certain column sortable in the Data Source Query Builder dialog, you can select it for quick edit any time later, directly in the Data Source window.
 

  • Default sort option - In the Database Source Query Builder you can add default sorting order for you database table columns.


Table Joins

  • Table Joins - SQL joins are used to combine rows from two or more tables. The Database Connector features inner, left and right joins where you can add more than one table to the Database Source Query Builder.
 
  • Add, edit and remove tables - You can add as many tables as you want to and also edit them any time by selecting the table from the columns picker tree in the Database Source Query Builder. Any table can be easily removed from the delete button.


  • Inner Join - The inner join is the most common and useful type of query. Most of the time you are interested in the records that match in the two tables and this is what the inner join gives you. An inner join return all rows from multiple tables where the join condition is met.

Example: An inner join of Customers and Orders would return details of all the customers who have placed orders together with the details of the orders that they have placed.

 
The result:
 

 

  • Left join - Returns all rows from the left table, and the matched rows from the right table. The result is NULL in the right side when there is no match.


  • Right join - A right join is the opposite of the left join and it returns all rows from the right table, with the matching rows in the left table. The result is NULL in the left side when there is no match.


  • Join conditions - The conditions node lists conditions which must be met before the tables to be joined.


  • Multiple joins conditions - You can add as many joins you want! On each sequential join you can choose the logical operator (and/or) to be applied with the previous one.


  • Test source - Once the table joins are established, you can press the test source button and a database source testing window will popup. It lets you test your source and view the results in a browser.

Integration with HTML5 Data Bindings

  • Database source as feed - Along with the many supplied standard feeds, you can connect to your database easily and use it as feed.


  • Define your data source - You can define your data source easily and have it handy in a drop down menu for later use.


  • Test your data source - Once the connection to your database is established you can test it an view the database query in the browser.


  • Display your data structure fully visual in Dreamweaver with the HTML5 Data Bindings floating panel - When you choose to add a database source, its data and structure is fetched directly and it is displayed in a nice tree view control within the special HTML5 Data Bindings floating panel available from the Window Menu.  


Pagination Options

  • Powerful built-in pagination – The DMXzone Database Connector has a native pagination built-in! No need to do any weird, database specific SQL magic here, the Database Connector covers your back. It knows all the various SQL Databases and uses a specific paging technique specific to that database.  So you always get the most powerful solution without the need of any SQL programming.


  • Dynamic Ajax alike paging – with the Control HTML5 Data Binding behavior, now you can refresh your database source data by just moving to the next, previous, first or last page. Only the repeat region with the data will be refreshed and not the whole page. Finally, you can deploy some fancy looking dynamic paging techniques!


  • Dynamic page navigation links – With the new HTML5 Data Bindings show/hide bindings attributes, you can decide when to show and hide regions depending on the data being available. This is very useful for paging navigation links so you can hide or show the links only when they are apply.


  • Show and hide regions – The new HTML5 Data Bindings now also allow you to make a special conditional region of any data repeating element.  Just select it and you will see, along with the repeat regions insert, you will have a show and hide Region option. This way you can make a region visible or hidden when its data is available only. Very useful for example to show “No records found”  message when there are no records.

Showcases


  • 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 ...

  • Online Bicycles Catalog Showcase

    For this showcase we used HTML5 Parallax Slider with four static slides in it. Each slide shows a record from four different datasets - dynamic image, name, category and text. In order to connect our ...

  • Responsive Online Store Showcase

    For this showcase we used HTML5 Data Bindings and DMXzone Database Connector to connect to our database in order to retrieve the products and HTML5 Data Bindings SEO for the content to be searchable ...

  • Winter Gear Showcase

    For this demo page we used HTML5 Data Bindings and DMXzone Database Connector PHP/ASP to connect to our database. The available products are within a repeat region and the description is formatted ...

  • The Gym Showcase

    For this showcase we used HTML5 Data Bindings and DMXzone Database Connector to populate our text on the page. We also used the HTML5 Data Bindings Formatter to apply a truncate filter so that our ...

  • 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 ...

  • John's Restaurant Showcase

    For this showcase we used the HTML5 Data Bindings and DMXzone Database Connector in order to create a dynamic website that allows you to follow the restaurant offers for each day by clicking on the ...

  • CMS Administrator Showcase

    For this showcase we have 2 database sources (orders and users) that we secured with the DMXzone Security Provider and require login to be viewed. On page load all you see is a message that you need ...

  • Cupcake Bakery Showcase

    For this showcase we used HTML5 Data Bindings and DMXzone Database Connector PHP/ASP in order to connect to our database. We have placed a repeat and a detail regions containing the products. When ...

  • 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 ...

  • ATV Store Showcase

    For this ATV Store showcase we used HTML5 Data Bindings and DMXzone Database Connector in order to retrieve the products from the database and also DMXzone Slider, which you can drag so that you can ...

  • 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 ...

  • Dynamic Web Store Collection Showcase

    For this photographers' web store we used the Dynamic Web Store Collections for PHP and ASP. The product images, model names and prices are dynamically retrieved from our database. The add to cart ...

  • Fashion Deals Daily Showcase

    For this fully responsive page showcase we used DMXzone Bootstrap for the layout and its Elements add-on for the details and time labels. With the HTML5 Database Connector PHP/ASP and HTML5 Data ...

  • Luxury Charter Yachts Showcase

    For this showcase we used the extensions packed in the Dynamic Database Connectivity Collection PHP/ASP in order to create a page where the images and the description are dynamically retrieved from a ...

  • Bikes Catalog Showcase

    For this showcase we created a catalog, which presents the products image and title from a database (with repeat region) using DMXzone Database Connector PHP/ASP and HTML5 Data Bindings. The read ...

  • Interior Design Studio Showcase

    For this showcase we used detailed regions (HTML5 Data Bindings) in order to display detailed data (DMXzone Database Connector) in a separate view, once an image is clicked. You can control which ...

  • Front End Developer Portfolio Showcase

    For this one page scrollable showcase we used HTML5 Data Bindings and DMXzone Database Connector PHP/ASP in order to populate the content from a dynamic source, including text, images, links and ...

  • Sort Real Estates Showcase

    For this showcase we used the dynamic sorting options in DMXzone Database Connector in order to allow the users to sort the real estates by four different criteria.

  • Dynamic Portfolio Showcase

    For this showcase we used DMXzone Database Connector in order to connect to our database and populate the images dynamically. We added form variable filter so that you can filter the images by ...

  • Classic Model Cars Showcase

    For this showcase used a database as a source in order to show all records on our page. The price, scale and the name are displayed dynamically from our HTML5 Data Bindings. The page contains a form ...

Videos



Dynamic Page Title and Meta Description Values


Validating If a Record Exists in a Database


Showing Random Products with HTML5 Data Bindings Formatter


Filter as You Type with HTML5 Data Bindings


Searching in Multiple Database Columns Using a Single Search Field


Redirecting Visitors to a Login Page


Dynamic Drop Down List with Static First Option


Fetching User Details and Filtering Data Sources by User Identity


Secure Your Database Actions


Secure Your Database Sources


Using Database Security Provider


Multi-step Form with Dependable Dynamic Dropdowns


Creating the Car Manager Dashboard Showcase


Retrieve and Use the Identity ID of an Inserted Record and Run Multiple Database Actions


Using the Require Attribute and Alert Errors Option


Delete Multiple Database Records Using DMXzone Database Updater


Delete Database Records Using DMXzone Database Updater


Update Database Records Using DMXzone Database Updater


Insert Records Into a Database


Rendering HTML Preformatted Content with HTML5 Data Bindings


Creating a Dynamic Select List using HTML5 Data Bindings


Dynamically Populating the Single Page Portfolio Template


Building a Dynamic Responsive Portfolio Page


Dynamic Sorting Options in Database Connector


Paging Options in the DMXzone Database Connector


Joining Database Tables in DMXzone Database Connector


Using Form Variable Filter in DMXzone Database Connector


Using the URL Variable Filter in DMXzone Database Connector


Sorting Options Included in DMXzone Database Connector


Using Database Source with HTML5 Data Bindings


Creating a Basic Filter Using DMXzone Database Connector


Defining a Database Source in DMXzone Database Connector


Setting Up a Database Connection using DMXzone Database Connector

Requirements

Type: Data Source
License: External link
Product: Dreamweaver CS5/CS5.5 and CS6, Dreamweaver CC
Server Model: ASP VBScript, ASP JScript
Database: Access, SQL Server, MySQL
Platform: Win XP/2000/2003/2008/7, Mac OS X, Mac OS X 10.4+
Used Technologies: jQuery, Ajax
Screen Shot: External link
Tags: database, connector, HTML5, Ajax, SQL, jQuery, ASP


History

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 Connector / Manage Database Sources ... and then click on "Reapply All"

Version 1.1.3

  • Full compatibility with HTML5 Data Bindings SEO ASP
  • Database metadata refresh , now also refreshes the views
  • Added version number in the server side source files

Version 1.1.1

  • Improved refreshing of the database structure
  • Fixed database connection generation when custom string is used.

Version 1.1.0

  • Added full support for the new DMXzone Security Provider PHP/ASP for secure database queries
  • Greatly improved 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 schema refreshing on database query builder dialog
  • Added "Reapply all" buttons to Database Connection and Database Sources Builder
  • Full support for Database Views! Now in the Database Source Query Builder, next to database tables you can also see the database views and use them for your queries.
  • Primary keys in database columns view - Now you can see directly which database columns are used as primary keys on the different icon in front.
  • Fully implemented support for IN and NOT IN operators in Filters working with list of values
  • New Login dialog for providing login information within Dreamweaver when testing secured database sources.
  • Latest jQuery 1.10.2 included
Update instructions:
Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Connector / Manage Database Sources ... and then click on "Reapply All"

Version 1.0.2

  • Full compatibility with the new DMXzone Database Updater PHP/ASP extension
  • Improvements on the date type fields handling
  • Build-in file updater on page open in Dreamweaver
  • Fully Handle JSONP requests to allow cross domain data exchange

Version 1.0.1

  • Improved error checking on various databases
  • Improved Database structure querying
  • Various minor improvements

 

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 visited daily by more than 30.000 people and is most popular for its over high-quality Dreamweaver extensions and templates.

See All Postings From George Petrov >>

Share this Article