calendar_today 06 May 2007 23:29
calendar_today 06 May 2007 22:34
The following code will enumerate the tables and their properties, together with the queries in an Access database. Saved SELECT queries are referenced using the Views collection, and INSERT, UPDATE and DELETE queries are referenced from the Procedures collection.
calendar_today 06 May 2007 20:50
calendar_today 06 May 2007 20:38
calendar_today 05 May 2007 20:48
This question gets asked very often in the forums and newsgroups, and is very easy once you know how.
calendar_today 05 May 2007 20:45
If you have centered web pages, there can be times where the depth of content doesn't reach the bottom of the window browser, so no scroll bar appears. Navigating between long and short pages can give the appearance of the centered content "jumping" from side to side.
calendar_today 05 May 2007 20:44
If you are creating a new ASP.NET application, but have a huge collection of existing content in html files, one option is to move all the content into a database and generate pages dynamically. However, migration to a database can be a time-consuming task depending on the volume of content. So wouldn't it be easier to somehow import the relevant parts of the existing html pages into your aspx page?
calendar_today 01 May 2007 22:54
calendar_today 27 April 2007 21:49
Need some bit or all of the URL for any reason?
calendar_today 13 April 2007 22:17
A selection of code samples for executing queries against MS Access using parameters.
calendar_today 09 April 2007 21:44
Long articles are better broken into bite-sized chunks over several pages. With static HTML, this is easily achieved by dividing the article into logical separations and creating separate .htm files for each. Here's how to do it using C# for an article that gets posted to a database.
calendar_today 09 April 2007 12:42
Regular Expressions provide a much more powerful and efficient way of manipulating strings of text than the use of a variety of standard string functions. They have a reputation of being cryptic and difficult to learn, but are actually quite easy to learn and use.
calendar_today 08 April 2007 21:11
Cheat sheet detailing formatting options for dates and times in C#.
calendar_today 08 April 2007 20:22
A cheat sheet for people who want to format dates using VBScript
calendar_today 07 April 2007 10:01
Having spent some time familiarising oneself with the objects available in Classic ASP, it can be tricky sometimes to find the .NET framework equivalent. Here's a guide.
calendar_today 06 April 2007 19:55
Many newcomers to web development cannot get their head around why the carriage returns they made in their data on input from a textarea, or from a text file, Excel spreadsheet etc. do not appear when the web page renders.
calendar_today 05 April 2007 22:37
Using the XmlTextWrite to output an XML file that serves as an RSS feed.
calendar_today 04 April 2007 21:45
Quite often, you want to display an item from a database that may or may not have an associated image. Examples might include a news story, product details, car for sale etc. But you want to avoid the dreaded "redex" if a picture isn't present.
calendar_today 03 April 2007 21:33
In Classic ASP, the typical model for managing site-wide functions is to create one or more server-side includes containing libraries of code. The OOP nature of ASP.NET offers a much more elegant solution.
calendar_today 03 April 2007 20:52
Having inserted a record, you want to retrieve the newly created record's ID number, then iterate over a collection of items, such as a CheckBoxList to insert additional information relating to the record.