How to Update an ASPX Page Code

Use your scripts to update the ASPX Page Code.

ASPX (Active Server Pages Extended) is a programming language developed by Microsoft and used when creating web-based applications. ASPX works with the Internet Information Services program. This program is a web server built into all Windows-based computers. ASPX is used with Microsoft SQL Server and Microsoft Access, the two biggest server-based Microsoft programs. You can use these programs to create page codes. When you want to update the page codes, you need use the ASPX language.

Instructions

1. Click the "Start" button, then click the "All Programs" icon. Click on "NotePad" from the menu.

2. Enter the ASPX script you want to open in your connection with this script:

   Dim Connection

   Set Connection=Server.CreateObject("ADODB.Connection")

   Dim ConnectionString

   ConnectionString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _

   "Data Source= /database/database1.mdb"

   Replace "database1" with the name of your database.

3. Type the script to open a new record set. Using this script in an example, we will change the name of an author.

   Update Books set author 'Bret Easton Ellis' where title = 'Less Than Zero'

4. Save the ASPX file in Notepad.

5. Upload the new file onto your website.

References

• Web Cheat Sheet: How to Connect to Database Using A Connection String
• Star Developer: Updating Records in the Database with ASP