locked
Design Strategy question RRS feed

  • Question

  • User922725412 posted

    I am curious how experienced ASP programmers would handle this little routine.  I am going to create schedule records for recurring appointments.  I will have a screen that captures the start date, end date and interval (weekly, monthly, etc) and a lot of other info.  When the entry is complete (onSubmit), I will look at this info and generate multiple schedule records.  So if start is 1/1/10 and end is 12/31/10 and interval is montlhly, I will create 12 records in the table.

    Is working with bound controls and a linq datasource practical in this case, or would you just collect the info into text boxes and handle the db manipulations manually? 

    Saturday, December 19, 2009 3:51 PM

Answers

  • User1692533347 posted

    Recurring some time become very complex, i had handled it once 2 years back, i would recommend you to use manual operation, in this case you would have much control on operations in your hand.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 21, 2009 1:19 AM
  • User78336405 posted

    Hi,

    I have some suggestions:

    1. Design your SQL database

    2. Writing the sql procedure and sql trigger to the db manipulations

    3. You could display that with Gridview or Repeater

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 21, 2009 1:28 AM

All replies

  • User1692533347 posted

    Recurring some time become very complex, i had handled it once 2 years back, i would recommend you to use manual operation, in this case you would have much control on operations in your hand.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 21, 2009 1:19 AM
  • User78336405 posted

    Hi,

    I have some suggestions:

    1. Design your SQL database

    2. Writing the sql procedure and sql trigger to the db manipulations

    3. You could display that with Gridview or Repeater

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 21, 2009 1:28 AM