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.
06 May 2007 20:50
06 May 2007 20:38
05 May 2007 20:48
This question gets asked very often in the forums and newsgroups, and is very easy once you know how.
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.
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?
01 May 2007 22:54
27 April 2007 21:49
Need some bit or all of the URL for any reason?
13 April 2007 22:17
A selection of code samples for executing queries against MS Access using parameters.
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.
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.
08 April 2007 21:11
Cheat sheet detailing formatting options for dates and times in C#.
08 April 2007 20:22
A cheat sheet for people who want to format dates using VBScript
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.
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.