Dreamweaver MX 2004 Do ASP program (3) Display database data

Source: Internet
Author: User
Tags insert connect query first row dreamweaver
dreamweaver| Program | data | database | display

1, open Dreamweaver MX 2004, in the site to create a new asp page (index.asp), select the New project "ASP Javascript." Open the Application panel and select the Database tab in the Applications panel. As soon as we set up the site in front, we chose the document type (that is, the ASP JavaScript we chose) and tested the server (http://localhost/myweb/). Now click on the "+" number and select "Custom connection string".

2, in the bounce out of the "Custom connection string" dialog box,"Connection name" casually write one. The "connection string" should be filled out properly. Driver={microsoft Access Driver (*.mdb)};d Bq=e:\myweb\database\webjxcom.mdb. This is common in hand-written ASP connection database code (related articles see http://www.webjx.com/htmldata/2005-03-24/1111596140.html)

Click on "Test"to show success.

If the connection is unsuccessful, you can open the Dreamweaver help to view the relevant instructions.

3, successfully connected to the database, in the DW is actually automatically generated a connection file. The location in the auto-generated Connections folder, the name you just made in the "Custom connection string" is simply knocking on the named ASP file . You can also notice that the various fields within the MDB file are visible within the DW Database tab.

4, connect the database file is there, but below our specific individual page how and database connection? Select the Bindings tab and add the recordset (query ). Just to see the literal meaning is to come to the SQL query statement.

5, in the pop-up "Recordset" window,"name" casually write a bar, also can not write, the default. But " connection" is going to select the connection object you defined from the Drop-down list, andthe "table" continues to drop the selection (note: This is related to several tables when designing the database).

6, other casual look, in fact, the most important thing is automatically generated SQL statements , click "Advanced ...", you can see the following figure


7, click OK , you will find that the recordset has been bound, all the fields in the database appear.

Notice the Insert button below, and you can select a field, or press the button or drag it to the Index.asp page. The ASP page displays the contents of the database. But only the first row, to show all .... Next

8,"Insert" menu-->> "Application Object"-->> "Dynamic Data"-->> "Dynamic Table". The following figure:

9, pop-up dynamic table to select the set of records that have been set, showing a few records to understand that is the generation of paging program: Data records more, more content, on several pages to display, a few pages. Records are automatically generated by using a table, and then set the properties of the table.

When you click OK , the effect is as follows:

10, then we can press F12 to view the effect, of course, if you are familiar with the HTML code and CSS, then you can format the table to make it look more beautiful! The final effect is as follows:

So far you've learned how to connect the database, how to display the records in the library table. Waiting for you is the following how to insert new records, how to modify records, delete records, and so on. Please continue to follow the following tutorials!



Related Article

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: info-contact@alibabacloud.com 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.