The new. NET Server model in Dreamweaver MX lets for you leverage the '. NET Framework in a visual environment. Anyone it familiar with Ultradev ' Recordset server behavior'll feel very comfortable to. Net ' s DataSet. Even if you are have never worked with Dreamweaver, this tutorial would show your easy it is.
We need to create a connection to the database. This is doing in the
tab in the
Panel. You can choose between two different types of connections
- OLE DB Connection
- SQL Server Connection
ODBC, although somewhat supported in the. Net framework as a separate download, is left for this release. This is probably a good thing because almost every major database has OLE DB drivers on the Windows platform. ODBC is not as fast as OLE DB, which is probably why Microsoft chose to "barely" support it as a separate download. If you are are using SQL Server as your database, then the SQL Server connection is the only way to go as it offers Performanc E advantages.
We are creating a SQL Server Connection in this tutorial because the is what I am working with. The OLE DB connection is isn't much different other than the fact so you can bring up the Microsoft Data Link dialog.
- Click the +Icon in the Databases panel
- Choose SQL Server Connection
- Fill out the information for your database in the provided template
Once you are do, you'll have a tree view of the your database that lets your explore tables, views, and stored procedures.
The next step was to Apply the DataSet server behavior.
- Click the + icon in the Server behaviors panel
- Choose Dataset
- Name your DataSet
- Choose your connection
- Choose the table and fields you want to retrieve
This is the exact same interface as the ASP server model so as I mentioned before and transitioning to. Net Development would Be easy if you are come from an ASP background.
After your have created the Dataset, you'll find this contents of the Datset are displayed in the
Panel. You can drag each field for the page you are are working in, and where it wherever it needs to go in your. Once you have laid we your design, you can apply the repeat region server behavior.
- Highlight the items you just placed on the page.
Make sure your take into consideration page breaks, whether that is as <br/> At the end, <p></p> around The selection, or within <tr></tr> tags.
- Click the + icon in the Server Behaviors tab.
- Choose Repeat Region
Behind the scenes, Dreamweaver actually places the contents of your selection <asp:repeater> tags.
It ' s as simple as that, once your do this a couple the times, it becomes second nature, so you can focus on building your AP Plications, instead of remembering esoteric object P