I would like capture the timeout error and present a user friendly message to ask him/her to narrow their search.
I do not want to extend the connection time. The strangest part of this issue is that it doesn't timeout when I hit back and click the search button again.
This is the error that I receive:
Microsoft OLE DB Provider for SQL Server (0x80040E31)
thank you for your help