存储过程的进度条 [英] Progress bar for stored procedure

问题描述

我打电话从asp.net前端的存储过程。它通常做很多表插入。在前端，我想表明两件事：进度条怎么样多少完毕。展示的第二件事是当前数据库中插入。像：目前强行嵌入：tblCustomers

I'm calling a stored procedure from asp.net front-end. It usually do inserts on many tables. On the front-end I would like to show 2 things: Progress bar like how much is completed. The second thing to show is current database insertion. like: CURRENTLY INSERTING: tblCustomers

鸭preciated！

Appreciated!

推荐答案

您可能会需要你的前端将监测进展情况的记录表。这还需要现有的存储过程来更新登录到不同的插入/状态之间的这种表。前端需要一些Ajax查询共记录插入和当前插入，让您的进度条。

You'll likely need a log table that your front-end would monitor the progress on. This would also require the existing stored proc to log an update to this table between different insert/statuses. Your front-end would need some ajax to query a total records to insert and currently inserted to get your progress bar.

这篇关于存储过程的进度条的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！