Whenever I am working on a simple ASP.NET web-page to allow a user to search and edit a specific database table I use the following design template to facilitate implementation. I find that it works for most simple web apps that I need. The sample code files are available for download at the end of the article.

Goals
• ASP.NET page that allows users to search data from a single table and edit the results (insert is not covered for simplicity but can be easily adapted to the design)
• Client and server side data validation

Prerequisites
• .NET Framework 4.0
• Ajax Control Toolkit

(more…)

Recently, I was working on a project that involved storing parking restriction information in a database. Here’s how I did it.

Goal

• Efficiently store parking restriction details (e.g. No Parking Tues & Fri from 9:30-11:00) associated with work locations.
• Ability to search the data by any combination of parking days and times.

(more…)