Leon's Weblog

April 13, 2013

Template Design of an ASP.NET Search/Edit page

Filed under: Software Dev — Leon @ 2:41 pm

Forms 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…)

April 9, 2013

Storing parking restriction information in a SQL Server

Filed under: Software Dev — Leon @ 11:32 am

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…)