Click here to Skip to main content
15,035,283 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have huge amount of data into tables and get extract result from it takes near about 60 Min,

So Till that time my application get stop or we can say in wait.

So,My question is i need to call store procedure from c# code and i no need output from it.

Please describe me how to run that procedure in backend without stop application in wait for user.

What I have tried:

I handle backend procedure with table and auto mail if record insert into temp table.

I tried BCP utility but and triggers but it also takes time.
Posted
Comments
Maciej Los 18-Jun-21 2:23am
   
Run code which will display the form with message "Wait..." and call SP in separate thread. So, when the SP ends, the thread will end too.
That's all.
Member 14743179 21-Jun-21 4:20am
   
in detail
Member 14743179 18-Jun-21 8:46am
   
please describe in brief....
Member 14743179 21-Jun-21 1:02am
   
Can you please describe in brief,its need for me'

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900