canceling statement due to user request

Question

I have asp.net application. on button click i brought the data from database though Store procedure. the query is liitle compler but execution time is nearly 2 minut. but when i run through application it not hold connection  and give this error

Bhushan Shimpi · Answer

I got the soluation. actually we use the NpgsqlDataAdapter and which is disconnected oriented. we remove it. and use the DataReader and its Execute reader method. Data reader is read the row by row data from database and still hold the connection. and use client side buffer. which reduce the Network overhead and improve the application performance. and also give the command time out.