How to show a status of each block Stored Procedure Execution Status?

See more:

ASP.NET

Dear All,

I had been asked a question in interview. The question is,

A stored procedure contains 3 blocks of execution. First block contains insert statement to few lack records and second block contains update statement to update few thousand records and third statement contains delete statement to delete few thousand records. <b>How to show the status of each block execution status in ASP.NET application</b>.

I have answered, we could use status bar control to show the status. But seems it's not correct. Is there any other way to show the status of each block?

Thank you,

Regards,
P.Mohan Giri