Updating a table while searching through it RRS feed

  • Question

  • Hello!

    My question is about a C# program accessing a SQL Express 2008 Server.

    My C# program has a search function, and I'm trying to put it into another thread so the user can continue working while the search is reading data the database. That has worked fine, except for my problem with the SQL connections.

    When leaving a page, the program will update the database. If its trying to do that while the search is still reading data from the server, the request will time out.

    The two requests are using different connections, and I tried pausing the search function reading data with a semaphore. Nothing worked so far.

    What am I doing wrong? Is this possible at all? Thank you for your help.

    • Moved by Bob Beauchemin Tuesday, November 4, 2014 1:43 AM Moved to the forum for client-side SqlClient questions
    Monday, November 3, 2014 7:35 PM


All replies