Display Result set after a long running process in a grid panel

[d3graph]

Hello all

I am using grid panel to show result of fetching the data from stored procedure.
its along running procedure it takes 1.5 min in SSMS. although result set is consists
of around less then 100 rows of 5 columns. its a balance sheet of min one year.

users are agree to wait 2 min but how to implement it to wait for 2 mins
on client side it always shows communication failure after 30 secs.

please guide me how to overcome this problem

[nasim]

I have had the same problem for a couple of times in my application. I think the best thing to do is optimizing your store procedure.