Check out the DateTime.DayOfWeek property.
vb Code:
  1. Select Case DateTime.Today.DayOfWeek
  2.     Case DayOfWeek.Monday
  3.     Case DayOfWeek.Tuesday
  4.     Case DayOfWeek.Wednesday
  5.     Case DayOfWeek.Thursday
  6.     Case DayOfWeek.Friday
  7. End Select
How do you have the times stored in the DB?