Dreamweavermx Ultradev Exploration (3-1)

Dreamweaver Dreamweaver MX Ultradev Exploration (3) Adding records to the database

OK, then, the previous chapter on the dynamic display of database content, I believe we are now the mood is very excited, ah ... Do you think that you should be able to add data manually on your Web page? Of course, DW MX is ready for us all. In general, to add records to a database through an ASP page, you need to provide an interface for user input data, which can be achieved by creating a form and page. Using the Insert record (insert recordset) server behavior of Dreamweaver MX, you can add records to the database.

Less nonsense, a new page, as shown (3-1)



3-1 it should be everyone.

<1> Click After you will find that the page appears and the previous DW or UD is very large, as shown in figure (3-2). DW MX is handy for creating different dynamic Web pages, and you can choose the type you want without having to select the save type as before. Here we choose to create a dynamic page, select VBScript as the scripting language for the page. OK, Save as insert.asp.



3-2
<2> we use Access to create a new database, save the name "User table" as shown in figure (3-3). Specifies the ID as the primary key, and sets its data type AutoNumber.



3-3

People notice no, here I put the field type in Chinese, if the previous in the UD era, is definitely not the Chinese, but to the DW MX era, we can finally use, moved ing ... As described in chapter II, create a System DSN and build a database connection in DW MX, as shown in figure (3-4).



3-4

<3> Good, the preparation work is finally finished here. As mentioned earlier, to add a record to a database through an ASP page, you need to provide an interface for user input data, that is, to create a form on the page and provide an area for user input so that we can save the user's submitted data into the database. Design the following interface, as shown in figure (3-5).



3-5

Notice the red number on the top? Don't worry, there is one more thing to note here, as shown in figure (3-6). To specify the names of these text boxes, the first username I specify the text box that follows it as "username." The other two similarities, respectively designated as "password", "Mailbox", just pay attention to the type of password this item (type) to be specified as password, so that users enter the password when they see just a string of * the number. Note: Previously naming text boxes in UD cannot be in Chinese, but it is now available in DW MX.



3-6