6e8bcce3   
   From: esquel@sommarskog.se   
      
   ptvvee (jobs@thomassharp.com) writes:   
   > I have a C# web application that connects to a SQL Server database.  I   
   > have about 15000 records where there is a resume field for each   
   > record.  I have a SQL SELECT (using LIKE) statement that the C#   
   > creates based on users input to search for a resume that has whatever   
   > keyword(s) the user would like to find.  However, for some reason, the   
   > searches come up blank the majority of the time, even when I am   
   > searching using words that I know are in the database records.  I have   
   > this application and database hosted on a GoDaddy server.   
   >   
   > It seems like the page is waiting for the response from the database,   
   > but if the response isn't back soon enough, the page just goes ahead   
   > and renders (but with no found records).   
   >   
   > Is this something that I can fix by telling the C# page to wait until   
   > a response is received back from the SQL Server database?  Or could   
   > this be a setting in SQL Server I don't have set correctly?  Or   
   > perhaps it is an issue with the host company?   
      
   It's very unclear what your problem is. You say your pages come up "blank".   
   Does this mean that they do not display anything at all? Or do they   
   display like "no records found"? What you get these "blank" pages, how   
   long does it take? Do searches for some keywords come back with data and   
   sometimes come up "blank"?   
      
   How does your SELECT statements look like?   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)