How to save time at each 2 second in SQl server 2000 using C#??

Basically I am conducting a quiz and i want that at each 2 second the time of the quiz should be save in the database????


What is the best method for it can any one suggest me???

How to save time at each 2 second in SQl server 2000 using C#??
Well I am assuming you have an input page asking questions and waiting for them to type answers. So you must have a loop of code. In that loop, check the system time repeatedly


marktime = now()


while (waiting for input)


if now() - marktime %26gt; 2 seconds


savefunction


marktime = now





etc.





now 2 seconds is not very long when waiting for user response so you will get lots of duplicate saves.