Friday, May 14, 2010
Cursor in ASP.Net
I wrote a page that continually monitors a SQL file to ensure that all files get processed and sent out, based on a status code. So that if a file didn't connect with the mail server the first time it would get a code 2 and repeatedly try to send it until it was successfully sent. Similarly, if a pdf wasn't processed (code 0) it would go back and create it. I learned that I had to set the connection string cursor to adOpenStatic to allow the dataset to go backwards to clean up prior transactions that hadn't been sent.