A collection of articles and tutorials on web development with ASP.NET by Mike Brind

Latest Entries

Analyse the tables and saved queries in an Access database with ADOX

06 May 2007 22:34

Classic ASP VBScript MS Access

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.

Click to read more about Analyse the tables and saved queries in an Access database with ADOX ...

How to highlight a GridView's row on hover

06 May 2007 20:50

C# ASP.NET 2.0 Javascript

As the user hovers over each row, it becomes highlighted, with the help of a small amount of javascript.

Click to read more about How to highlight a GridView's row on hover ...

How to make an ASP.NET Table row highlight and become clickable

06 May 2007 20:38

C# ASP.NET 2.0 Javascript HTML

For those people who like to output their data to an asp:Table, highlighting the entire row and making it clickable can make it obvious to the user that some action is expected from them. This emulates the behaviour that can be found in some desktop applications. All that's needed for this is a bit of javascript, and the use of AddAttributes() for the table rows.

Click to read more about How to make an ASP.NET Table row highlight and become clickable ...

How to center the content of a web page

05 May 2007 20:48

HTML CSS

This question gets asked very often in the forums and newsgroups, and is very easy once you know how.

Click to read more about How to center the content of a web page ...

How to force a scrollbar for centered web pages

05 May 2007 20:45

HTML CSS

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.

Click to read more about How to force a scrollbar for centered web pages ...

Include contents of an html page in an aspx page

05 May 2007 20:44

ASP.NET 2.0 HTML

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?

Click to read more about Include contents of an html page in an aspx page ...

Javascript 24 hour clock

01 May 2007 22:54

Javascript

A snippet for a javascript clock showing time in 24 hours with seconds

Click to read more about Javascript 24 hour clock ...

Parameter Queries in ASP.NET with MS Access

13 April 2007 22:17

ASP.NET 2.0 MS Access ADO.NET

A selection of code samples for executing queries against MS Access using parameters.

Click to read more about Parameter Queries in ASP.NET with MS Access ...

Paging long articles in ASP.NET using C#

09 April 2007 21:44

C# ASP.NET 2.0

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.

Click to read more about Paging long articles in ASP.NET using C# ...

Regular Expressions and VBScript

09 April 2007 12:42

Classic ASP VBScript

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.

Click to read more about Regular Expressions and VBScript ...

Date Formatting in C#

08 April 2007 21:11

C# ASP.NET 2.0

Cheat sheet detailing formatting options for dates and times in C#.

Click to read more about Date Formatting in C# ...

Date formatting in VBScript

08 April 2007 20:22

Classic ASP VBScript

A cheat sheet for people who want to format dates using VBScript

Click to read more about Date formatting in VBScript ...

Migrating from Classic ASP to ASP.NET - equivalent objects and classes

07 April 2007 10:01

Classic ASP VBScript ASP.NET 2.0

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.

Click to read more about Migrating from Classic ASP to ASP.NET - equivalent objects and classes ...

How to retain carriage returns or line breaks in an ASP.NET web page

06 April 2007 19:55

C# ASP.NET 2.0 HTML

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.

Click to read more about How to retain carriage returns or line breaks in an ASP.NET web page ...