Creating and displaying a DataSet in Dreamweaver M

Source: Internet
Author: User
Tags odbc ole dreamweaver
The new. NET Server model in Dreamweaver MX lets for you leverage the '. NET Framework in a visual environment. Anyone it familiar with Ultradev ' Recordset server behavior'll feel very comfortable to.  Net ' s DataSet. Even if you are have never worked with Dreamweaver, this tutorial would show your easy it is.
We need to create a connection to the database. This is doing in the Databasestab in the FilesPanel. You can choose between two different types of connections
    • OLE DB Connection
    • SQL Server Connection

ODBC, although somewhat supported in the. Net framework as a separate download, is left for this release.  This is probably a good thing because almost every major database has OLE DB drivers on the Windows platform.  ODBC is not as fast as OLE DB, which is probably why Microsoft chose to "barely" support it as a separate download. If you are are using SQL Server as your database, then the SQL Server connection is the only way to go as it offers Performanc E advantages.
We are creating a SQL Server Connection in this tutorial because the is what I am working with. The OLE DB connection is isn't much different other than the fact so you can bring up the Microsoft Data Link dialog.
    1. Click the +Icon in the Databases panel
    2. Choose SQL Server Connection
    3. Fill out the information for your database in the provided template

Once you are do, you'll have a tree view of the your database that lets your explore tables, views, and stored procedures.
The next step was to Apply the DataSet server behavior.
    1. Click the + icon in the Server behaviors panel
    2. Choose Dataset
    3. Name your DataSet
    4. Choose your connection
    5. Choose the table and fields you want to retrieve

This is the exact same interface as the ASP server model so as I mentioned before and transitioning to. Net Development would Be easy if you are come from an ASP background.
After your have created the Dataset, you'll find this contents of the Datset are displayed in the BindingsPanel.  You can drag each field for the page you are are working in, and where it wherever it needs to go in your. Once you have laid we your design, you can apply the repeat region server behavior.
    1. Highlight the items you just placed on the page.
      Make sure your take into consideration page breaks, whether that is as <br/> At the end, <p></p> around The selection, or within <tr></tr> tags.
    2. Click the + icon in the Server Behaviors tab.
    3. Choose Repeat Region

Behind the scenes, Dreamweaver actually places the contents of your selection <asp:repeater> tags.
It ' s as simple as that, once your do this a couple the times, it becomes second nature, so you can focus on building your AP Plications, instead of remembering esoteric object P

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.