The following is my connectionstring:

server=(local);database=JnJ3;uid=sa;pwd=sa

May I know how can I avoid timeout expired because I keep on receiving error message when deal with huge amount of data.
The timeout period elapsed prior to completion of the operation or the server is not responding.