Part1: What do I need to setup a server on my computer?

For this to work you will need to have the software below installed.

1. Dreamweaver 8, this is what I used in the tutorial. I am not sure if you can do this on the previous versions.

2. Windows XP Professional

3. (IIS) Internet Information Services has to be installed.

Part2: Follow there previous tutorial

For this tutorial to work you will need to set up Dreamweaver and your computer to run ASP.NET pages. I covered how to do this in a previous tutorial, you can read up on this below. Most of these tutorials also includes video examples.

1. Installing IIS for Dreamweaver

2. Working with ASP.NET database

3. Add Information

4. ASP.NET Edit

5. ASP.NET Search Form

Part3: Lets get Started.

At this point I will take it that you have IIS setup and you are able to access a database from Dreamweaver.

Ok, lets get started. Download this database click here and place it into your database folder. The download includes the image, database and default.aspx file. The default.aspx file is already setup to display all the information stored in the database. We will need to edit it a little but its no problem. Open the default.aspx file in Dreamweaver, modify the table and add the two text (Edit | Delete) shown below.

Click File New... and click on Dynamic Page ASP.NET VB and click Create. Hit Ctrl+S and save your site as delete.aspx.  Click on Bindings in the Application window and create the dataset shown below, your dataset name can be different.

with that click ok.

Next Click, Insert Application Objects update Record Record update form wizard. with that you should see the window  below.

Fill in the information according to the image above. referring to the form wizard above, click on ID and remove if from the table using the minus  (-) sign. After that press ok. When you press ok, dreamweaver should have created the form shown below.

Click on the [ASP:CHECKBOX] text on the form, and switch your view to code view. When you do that you should see the code shown below.

<asp:checkbox id="Deleted" runat="server" checked='<%# IIf((ds08.FieldValue("Deleted", Container) = ""), true, false) %>' />

See where it says Container) = "") replace the "" with true. So your new code will look like this:

<asp:checkbox id="Deleted" runat="server" checked='<%# IIf((ds08.FieldValue("Deleted", Container) = true), true, false) %>' />

Save your page.

Click back over to the default.aspx page, double click on Delete.

With Delete Highlighted, click on the yellow folder shown below.

After clicking on the yellow folder it will bring up the select file window, from there click on parameter, with that you will see the window below

In the Name field Type in id, in the value window click on the lightning bolt and select ID as shown below.

After that click ok, two time. You should be at the window below.

Make sure you select the delete.aspx page you previously created and click ok. The delete works by using a filter, since you are not actually deleting the information you are just hiding it from your users. Its recommended not to delete information stored in a database you never know when you may need it back in the future. Click on the default.aspx page, double click on the Dataset name.

With that you should see the window below.

Click on Advanced, in the SQL window place this code.

SELECT *
FROM tbltutdatabase
WHERE Deleted = false

as shown below.

Now Press F+12 to preview the default.aspx page.

Finished:
Well that is it, hope it came out to what you expected. I also created a video tutorial for this example. The file is a 3.63 MB flash file. I have the link up on the video section on the forums. Users have to register to view the file, click here to register and view file.  If you have any question or comment about this tutorial, feel free to post a message on the forum.

This Tutorial was Created By Mark
© 2007 pixeldigest.com. All Rights Reserved.

CSS mouse over Table

In this tutorial I will teach you how to create a CSS mouse over Table effect to change the background color of a table using Dreamweaver.
... Read more