One, the database is built in SQL Server 2000
1. The database is founded in SQL Server 2000
(the business management that 1) opens SQL Server 2000 implement, right key is clicked on database option, click build a database.
(2) is Sjk in name of database of the setting in building database property.
2. The user is founded in SQL Server 2000
(the business management that 1) opens SQL Server 2000 implement open security folder.
(2) clicks right key to open on entry option build entry property, setting user name is Zl, identity test and verify chooses test and verify of SQL Server identity, input a password next, database of acquiesce of user of the setting in the acquiescent setting below is the database) that the first pace builds Sjk(.
(3) chooses " server part " option gets stuck, the server part pitch on that among them place needs, if can be chosen completely to go to the lavatory.
(4) chooses " the server is visited " option gets stuck, choose the database that the user can visit, want to click the pane before place should visit a database only, the system can make pair of check marks inside pane. Choose the limits of authority that when the user is visitting this database, has in the database part below next, the proposal chooses all attributive on.
2, the join of database and ODBC
Measure of join:
(1) is opened " Control Panel " medium " ODBC " choose " systematic DNS " face plate.
(2) is clicked add pushbutton, choose " SQL Server " click " finish " .
(the name of 3) configuration DNS and server, name and specification are OK oneself are defined (had better not contain digital) , the server name of the SQL Server2000 in the computer that server name must be data place (the name) that is the computer commonly, click next " affirmatory " .
(4) chooses " the SQL Server test and verify that use user inputs entry ID and password " , be in " user name " and " password " the user name that in the first pace is being inputted in text casing, builds in SQL Server and password. Click affirmatory till interface of occurrence test data.
(5) is clicked " test data source " occurrence test interface, click " affirmatory " .
3, make through ODBC Dreamweaver and SQL Server are linked together
1. Build a name to be Syf site
establishs measure:
(1) opens face plate of the site in Dreamweaver MX to click editor site.
(2) is clicked " NEW " build a site.
(3) chooses " this locality information " option, the name that installs a site and file deposit method.
(4) chooses " the test serves " the method of ASP of option setting explanation (with PWS the way that perhaps sets in IIS agrees) .
(5) is clicked finish certainly found the job.
The join of 2.ODBC and Dreamweaver
Measure of join:
(1) is in Dreamweaver " Application " the choice in face plate " Database " option, click above " + " date, the 2nd in menu is being pulled below the choice (DNS) .
(2) installs a database the name in Dreamweaver, "Connection Name " it is to be used at the setting to use what name to represent this join in Dreamweaver, it is OK that the number should be not contained only in the name. "Data Source Name " the name when the choice establishs link with ODBC in the database in the 2nd pace, user name and password are the user name that builds in SQL Server and password, click next " OK " OK.
arrives till here we had been linked together database and Dreamweaver. The case that student information shows through be in the webpage below will explain how to apply.
4, build a webpage
1. The webpage of an Asp is built in Dreamweave, a standard of 2 4 list is established in the webpage, the first behavior expresses a head, input respectively " full name " , " sexual distinction " , " the age " , " seat " .
2. the database medium watch introduces Dreamweaver.
Option of the Bindings in the Application face plate of Dreamweaver of choice gets stuck (perhaps press F10) , click " + " date, choose the first " Recordset(Query) " option. OK is clicked after the choice is good.
3. If set correct meeting,appear corresponding interface.
4. Before clicking record volume " + " , will show each field that you choose the watch in the database.
5. Each field that expresses in the database that appears on one pace, the 2nd of the correspondence in pulling form with the mouse, namely " full name " the field procrastinates " full name " below watch head.
introduces the data in the database in the webpage now, but show is a record in the watch only now, if want to show many record, can first the 2nd of pitch on form, option of the Server Behaviors in clicking Application face plate next gets stuck, click " + " , choose " Repeat Region " option, show a record entirely according to needing to be able to be installed, or one page shows record a number.
We can see in " Repeat Region " in option, OK still easily the insertion of the record that finish, delete and update, here was not being narrated one by one, the reader that have fun at can be studied further.
Posts
No comments:
Post a Comment