Technical Articles
ASP
ASP Documentation
A short article on where developers can find documentation on ASP.More...
Update Recordset using a MultiSelect Listbox
A common scenario that developers may encounter is to associate many database records with a record from another table. The example that I'll use is to associate a number of facilities with a particular property. On a webpage, the user can insert a property into the database. The page will also have a multiselect listbox for the user to associate many facilities with that property. The facilities are then stored as a comma delimited string in the Properties table.More...
How to create a Virtual Directory in IIS
I always have a local copy of websites that I work on. Some people like to put the folders inside of the inetpub/wwwroot folder. But, I tend to put my website into a folder c:\websites and then create virtual directories.More...
The infamous 80004005 errors
Every developer will have come across the infamous 80004005 errors at some point in their career. The fundamental cause of the error is due to permissions in one way or another. Novice developers can be confused by some of the messages, so I will attempt to explain them in this article.More...
Troubleshooting the HTTP 500 Error
The first thing that novice web developers have trouble with is decyphering error messages. The first one they will come across in Internet Explorer is: "HTTP 500 The page cannot be displayed".More...
Using the DISTINCT modifier in SQL
For the novice SQL programmer, the DISTINCT modifier component of a SELECT statement can cause confusion.More...
Insert into Multiple Tables using ASP
Dreamweaver MX doesn't handle anything related to 'multiples' very well. For example, if one wants to insert data into multiple table using one form, then it can't be done with the in-built Insert behaviour.More...
Build an ASP Poll
Polls on websites are quite popular. A typical poll is shown on the side bar of a web page. Browsers will see a description of the poll and have several to choose from. After submitting a choice, the poll results will be shown. I will show you how to create such a poll. More...
Batch update records in ASP
Batch updating in ASP can be quite tricky. Normally, it would be easier to provide a master-detail page so that each record could be updated individually. But sometimes it can be more intuitive to offer users a grid so that multiple records can be updated at the same time. More...
Who's Online demo for Classic ASP
The are many tutorials on the Internet that will show how many active users are on a website. But, it can be a bit trickier to extend this to give a list of the active users. In the example I going to show you, I will store the users in an XML file. This method may not be perfect, but may suit the needs of many.More...
Manage infrequently changing data
When creating a web application, it's very common to use pieces of data that don't change very often. Examples might be an Administrator's email address or the maximum size of files to be uploaded.More...
Configure local machine to use CDOSYS
CDOSYS is a library that is built in to Windows 2000 and Windows XP. It is used to send emails from Classic ASP and ASP.NET pages.More...
Manage database table on a Single page
With Classic ASP, a typical project will contain quite a few tables that consist of 2 fields. For example, Countries, Regions or Categories. The Countries table will consist of the fields CountryID and Country. I found it convenient to build a generic page to manage the data in one of these tables.More...
Concatenating strings and variables in Classic ASP
Beginners in ASP, or any scripting language for that matter, have trouble understanding the concept of literal strings and variables. And how to concatenate (join together) them.More...
ASP.NET
Embed text in Image using ASP.NET
Sometimes, it is nice to have a text caption embedded into an image, rather than display the caption in HTML. Fortunately, this is fairly straightforward in ASP.NET.More...
Create an SMTP email client for ASP.NET
ASP.NET has an in-built class for sending emails in the System.Web.Mail namespace. This is merely a wrapper for CDOSYS. Developers may wish to use an alternative SMTP mailserver. In this article, I'll show how to create a fully functional SMTP email client for ASP.NET in just 70 lines of C#.More...
Asp:Panel v Asp:PlaceHolder
I always get the feeling that there is not much difference between the asp:panel and asp:placeholder server controls in ASP.NET. The Panel control is useful for grouping together other controls or HTML segments. The control can be thought of as the server side equivalent of the
Ensuring XHTML compliancy in ASP.NET
Out of the box, ASP.NET generated HTML doesn't validate too well against XHTML 1.0.More...
Configuring ASP.NET Forums
I recently downloaded ASP.NET Forms from the ASP.NET website. I wanted to create a support forum for my range of products and thought that ASP.NET forums would be ideal. For the most part, this went quite well. But I did have a few problems and I thought I would outline them in this article.More...
Master Page Templates in ASP.NET (Part 2)
In this article, I be looking at extending the functionality of the template to have the ability to change the title for each page, dynamically show/hide regions of the template on different pages and dynamically load User Controls into placeholders on different pages.
More...
Master Page Templates in ASP.NET (Part 1)
In Classic ASP, developers will use include files to give each page a consistant look and feel. When the include file(s) are changed, those changes are also reflected on the parent pages. This makes a website quite maintainable. Although, the main drawback of this methodology is that the basic page structure has to be duplicated on each page. If this structure changes, then it has to be manually done on each page.More...
Paging with Repeater control in ASP.NET
Repeater and DataList controls offer a quick and flexible means of displaying data on a ASPX page. But they offer no paging functionality built in. The DataGrid control has in-built paging but it's structure is more rigid. There are several articles on various ASP.NET Resource Sites that offer solutions, but I'm going to show you how to use the PagedDataSource class.More...
ASP.NET server control to sort data
I have created a Server Control in ASP.NET so that developers can easily sort the data in a table.More...
Debug ASP.NET pages using Tracing
Shows how to debug ASP.NET pages by using Tracing.More...
Survey Tool for ASP.NET
I have developed a Survey Tool application for ASP.NET. It is intended to be a demonstration only. Please contact me for licencing issues or costs involved in integrating the tool into your site.More...
Create a tree from Database table in ASP.NET
One can create Trees in ASP.NET by using Microsoft Internet Explorer Webcontrols.More...
Search for Stored Procedures in source code
During the development process of an ASP.NET web application, the number of stored procedures used can grow alarmingly. More often than not, I forget to document which stored procedures are being used and which are redundant. So, I decided to build a little utility that searched through my source code to find all instances of stored procedures being used.More...
XML
Consuming Amazon Web Services in ASP and ASP.NET
Developers can now integrate Amazon content into their websites. This is done by consuming Amazon Web Services using XML-based protocols.More...
Charon RSS Newsfeed
I have created an RSS newsfeed for my website. Using my newsfeed, other developers can show a list of my recent articles on their websites. More...
Macromedia DesDev XML Feed
Shows how to create a web page that consumes the Macromedia DesDev XML Feed.More...
XML Login
A drawback of the standard ASP login form is that one has to submit the form in order to process the users information by checking it against records stored in a database. It would be quite handy if the user was alerted immediately after clicking the login button.More...
Dreamweaver MX
Using Dreamweaver MX with Visual Studio.NET
Some developers are a little unsure as to which tools to use to build ASP.NET websites. A common practise is to use Dreamweaver MX to build the page layout, and then open the pages in VisualStudio.NET to do the coding.More...
Using the Google API in Dreamweaver MX
Developers can now use the Google API Web Service to build search functionality into their sites. One can query the Google database and return a result set to ones own site. It will appear seamless to the end-user. Specifically, I will show you how to create a DLL in Dreamweaver MX and create an ASP.NET page to consume the Web Service.More...
Create a Master Detail Page in Dreamweaver MX
A Master-Detail page set is a very popular was of displaying information on dynamic web pages. On the master page, the contents of the database table are listed. Then, by clicking on links, the details of a particular record can be viewed on another page.More...
Sort a Datagrid in Dreamweaver MX
I have got a demo on how to sort a table by clicking on a column heading in Classic ASP. It's just as easy to do something similar in ASP using a Datagrid in Dreamweaver MX.More...
Using a Connection object in Dreamweaver MX
Some servers may have a limit on the number of connections to the database that can be opened. This can be overcome by opening just one connection and then re-using that connection for all recordsets. More...
Dreamweaver MX and Cursors
When we create a new recordset, Ultradev uses default values for the CursorType, CursorLocation and LockType properties of the recordset. We would assume that the defaults would work for every occasion. This is not the case.More...
Configuring Dreamweaver MX to recognise ASCX files
Some people may have problems with Dreamweaver MX not properly recognising ASPX and ASCX files when using the ASP.NET Server Model. By default, MX is fairly rigid in the way that it recognises C# or VB.NET pages.More...
Handcoding database inserts using Dreamweaver MX
The Insert/Update/Delete server behaviours that are built in to Dreamweaver MX can sometimes be a little inflexible or confusing. Occasionally, I prefer to handcode inserts/updates using the Recordset.Update method. It's really easy to use and the code is quite readable.More...
SQL Server
Create an Access Project to manage an SQL Server database
Many ASP developers are used to building databases with Microsoft Access. But, when it comes to managing an online SQL Server 2000 database, some developers can be unused to the Enterprise Manager. The Enterprise Manager is built into SQL Server and is used for accomplishing management tasks on the remote database. However, some may find an Access Project more friendly in managing the SQL database.More...
