| In this article you will be able to use
| |
| | Connection dialog to ensure that you set
|
| the new features of dreamweaver 8 to
| |
| | up your connection correctly. If an error
|
| connect to a SQL database and return the
| |
| | occurs, check your
|
| results to a datagrid.
| |
| | Connection string settings.
|
| We will show you how to create
| |
| | Next, click OK to accept the connection
|
| full-featured, customized DataGrids using
| |
| | settings. You will now see the Northwind
|
| Macromedia Dreamweaver 8 on the ASP.NET
| |
| | connection appear in the Databases tab of
|
| application server platform.
| |
| | the Applicationpanel group.
|
| You will set up your Dreamweaver MX site,
| |
| | Look at web.config in your site's root
|
| connect to the database, create the
| |
| | directory. Notice that Dreamweaver has
|
| DataSet for the DataGrid, and create a
| |
| | added several new lines under the
|
| default DataGrid. In thefollowing three
| |
| | element:element:
|
| articles, you will build on what you
| |
| | Data Source=NameOfYourDatabaseServer;
|
| learn in this article and learn how to
| |
| | Initial Catalog=Northwind;User
|
| customize the DataGrid appearance, make
| |
| | ID=sa;Password=;" />
|
| the
| |
| | You will now need to create the DataSet
|
| DataGrid editable, and sort columns in
| |
| | that you will use for the DataGrid data
|
| the DataGrid. By the end of the article,
| |
| | source.
|
| you will be comfortable working with
| |
| | Using the new page you created prior to
|
| DataGrids and will befamiliar with their
| |
| | defining the database connection, save
|
| various features and attributes.
| |
| | the page as employees.aspx
|
| This article uses the DataSet tag to
| |
| | In the Application panel, click the
|
| obtain the data from the sample Northwind
| |
| | Server Behaviors tab.
|
| database included with SQL Server 2000
| |
| | The file DreamweaverCtrls.dll must
|
| and display it in a
| |
| | reside in the /bin directory under the
|
| DataGrid.
| |
| | root of your website. This file is
|
| Firstly you will need to set up your site
| |
| | required by the ASP custom tagsprovided
|
| definition.
| |
| | by Dreamweaver MX. If you haven't already
|
| Select Site > New Site... from the Menu
| |
| | done so, click the deploy link within the
|
| bar to create a new site.
| |
| | Server Behaviors tab. This will copy the
|
| On the Basic tab, enter the following
| |
| | DreamweaverCtrls.dll file into the
|
| information, clicking Next at the bottom
| |
| | appropriate directory.
|
| of each screen:
| |
| | Next, click the plus button and select
|
| Enter a title in the Name field.
| |
| | DataSet.
|
| Yes, I want to use a server technology.
| |
| | The DataSet dialog appears. Name the
|
| Select ASP.NET C# as the server
| |
| | DataSet ds_list.
|
| technology.
| |
| | Select Northwind from the connection
|
| Edit and test locally, storing your files
| |
| | pop-up menu.
|
| at C:Inetpubwwwroot.
| |
| | Select dbo.Employees from the Table
|
| URL to browse to the root of your site
| |
| | pop-up menu.
|
| No, do not copy files when I am done
| |
| | Select the Selected: radio button from
|
| editing.
| |
| | the Columns: radio button group.
|
| Click Done to create an initial cache of
| |
| | The Employees table in the Northwind
|
| your site.
| |
| | database contains 18 columns. For this
|
| Open the the Site Definition dialog box
| |
| | example, select the following 10 columns
|
| by choosing Site > Edit Sites. Select
| |
| | only (hold the Ctrl keywhile you select
|
| your site's name from the list, and click
| |
| | each column):
|
| the Edit button.
| |
| | EmployeeID, LastName, FirstName,
|
| Set up the testing server to use ASP.NET
| |
| | HireDate, Address, City, Region,
|
| C# as the Server Model. Set the Access
| |
| | PostalCode,
|
| and other values as appropriate for your
| |
| | Country, HomePhone
|
| site
| |
| | Since you don't need to filter the query,
|
| Now we need to create a connection to the
| |
| | set Filter to None.
|
| SQL database.
| |
| | Since you want to sort alphabetically
|
| Within Dreamweaver, select File > New...
| |
| | according to last name, so set Sort to
|
| from the Menu bar to create a new file.
| |
| | LastName Ascending.
|
| On the General tab, select Dynamic Page
| |
| | Click OK to create the DataSet.
|
| for the Category and
| |
| | Save your work.
|
| ASP.NET C# for the Dynamic Page type.
| |
| | Now you have created the connection to
|
| Click the Create button to create the new
| |
| | the database and specified the data that
|
| page. This step is required because
| |
| | you need to be returned you will need to
|
| Dreamweaver needs to knowwhat kind of
| |
| | create a datagrid to display the
|
| server technology your pages will use
| |
| | information in a tabular form.
|
| before it can help you in the create a
| |
| | Open the Server Behaviors tab of the
|
| database connection
| |
| | Application panel.
|
| Open the Databases tab of the Application
| |
| | Select the plus button again, and select
|
| panel group.
| |
| | DataGrid.
|
| Click the plus button, and select the SQL
| |
| | Name your DataGrid dg_list.
|
| Server Connection option.when the SQL
| |
| | Select the ds_list DataSet from the popup
|
| Server Connection dialog box appears,
| |
| | list.
|
| type in the information presented below,
| |
| | Show just four Records instead of the
|
| and ensure that it matches your
| |
| | default 10 records.
|
| database's User ID,password, and name.
| |
| | Leave the rest of the attributes at their
|
| Connection Name: Set this to Northwind.
| |
| | default values for now.
|
| Data Source: Set this to the name of your
| |
| | Click OK to create the DataGrid.
|
| database server.
| |
| | Save your work.
|
| Initial Catalog: You will be using the
| |
| | To see your page in action, view the page
|
| Northwind sample database that comes with
| |
| | in Live Data preview (View > Live Data),
|
| Microsoft SQL Server, so set this to
| |
| | or press the F12 key to preview the page
|
| Northwind.
| |
| | in your browser as shown in the
|
| User ID: The default user name for
| |
| | illustration below.
|
| Microsoft SQL Server that is created at
| |
| | The column headers are taken from the
|
| the time of installation is SA, so set
| |
| | names of the database columns.
|
| this to SA.
| |
| | Now that you know how to create DataSets
|
| Password: The default password for the SA
| |
| | and how to create the default display for
|
| account is blank, so leave this blank.
| |
| | the DataGrid using the data in those
|
| Click the Test button in the SQL Server
| |
| | datasets.
|
