Add Information – Learn how to add information to a database using ASP.NET.
Introduction: In this tutorial, I will explain how to add information to a database. Using Dreamweaver, this is very simple once you have the database setup. If you are having problems, feel free to e-mail us or post a message on the forum.
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.
- Dreamweaver 8, this is what I used in the tutorial. I am not sure if you can do this on the previous versions.
- Windows XP Professional
- (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 previous tutorial, you can read up on this below. Most of these tutorials also includes video examples.
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, let us 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. I will use this to show the information I will be adding to the database. Open Dreamweaver click File> New…and click on Dynamic Page> ASP.NET VB and click Create. Hit Ctrl+S and save your site as add.aspx. Click, Insert > Application Objects > insert Record> Record insertion form wizard. with that, you should see the window below.
Fill in the table according to the information shown above. Change the ID “Display as” toHidden Field and click ok. In the Application, Server Behaviors window double click on Insert Record as shown below.
When you do that the window below will come up.
Change the ID value to None, and click ok. With that you should have the form shown below.
You can change the names on the Left-hand side to correspond to your text box. Now hit F+12 to preview it, insert some information into the table, and hit inset. It should take you to the default.aspx page, scroll down and you will see your information. For the image to work, it has to be inside your image folder.