Ultradev Example Tutorial: 3.3 Applying Database to Create Dynamic Web Pages

Author：Eve Cole Update Time：2009-05-30 18:34:50

Chapter 3: Applying Database to Create Dynamic Web Pages

Section 3: Display database records

It's finally time to show the power of Dreamweaver Ultradev. First, let's take a look at how to use Ultradev to realize the data display function. It's very simple, just follow me.

After we created the data set last time, the following display appeared in the Data Bindings panel:

Then we create a table with 2 rows * 6 columns. The number of columns is determined by the number of fields in the data table. As for why there are two rows, you will understand after reading. After filling in the necessary information, the page will look like this:

The next work is very simple. Select the field name that appears in the Data Bindings panel, drag and drop it into the table we just created. The effect is as shown in the figure, which means that we want to display the database in the corresponding cell. The value of a field. But this is not enough. One step is needed to display all the records in the database.

Select the row we just dragged and dropped the field into, the effect is as shown in the figure:

Switch the panel to Server Behaviors, and our protagonist is about to appear. We need to apply some actions to these data to make them obey our words and display them as we want. Select Repeat Region:

The next dialog box asks you how many records to display on one page. When there are thousands of records in your database, it is impossible for us to display them all, which will slow down the loading speed of the web page. Generally, the data is displayed in the form of paging, and the Repeat Region behavior is used. . Here we choose to display 3 records per page.

After clicking OK, as shown in the figure:

Let's switch to the browser window and view the program we just generated. Oh, don't forget to save this page as the default document name you set in the Internet Information Services Manager, here is default.asp. Enter http://localhost in the address bar of the browser window and you will see the following effect. Haha, aren't you very excited? The data in the database is displayed before our eyes. You also find that it is not difficult to create a Web application. Well, I was happy for a while, and I seem to have found something wrong, right? By the way, only 3 records are displayed here, and we just entered 5 records manually in our database. What about the others? Okay, let's go ahead and refine our program.

Select the menu Insert -> Live Objects -> Recordset Navigation Bar to add a page turning function to our record display:

This dialog box asks you whether the page turning link should be represented by text or image. For simplicity, we use Text:

After OK, you will find that Ultradev has generated a table for us, with 4 columns in it, namely First, Previous, Next, and Last, which are our common first page, previous page, next page, and last page. Expression method, you can change it to Chinese.

After switching to the browser window, we found something different. There are two more connections, Next and Last, wow! Our records can now be displayed in pages. Even for experts, paging display is a troublesome thing, but for Ultradev, it is a matter of hands.

Click the Next connection to display the records on the second page. At the same time, the connections between Previous and First also appear automatically. Because we only have 5 records in total. If 3 records are displayed on each page, there will be no third page, so there will be no connection between Next and Last. Haha, don’t you think Ultradev is quite smart?

Okay, after seeing this, friends should already know how to display records in the database, and also learn how to display them in pages. The next step is to learn how to add records to the database. Please listen to the next chapter for the breakdown.