监视SQL DB上的表的数据(通过SQL Connection保持在线) [英] Monitoring Data of a table on a SQL DB (Staying Online With SQL Connection )

问题描述

嗨 我需要在Web应用程序中添加一个功能，该功能可以对表进行在线监视(例如Prodocts)

在我的上一个项目中，我调用Coresponding存储过程，并在使用后关闭连接.但这不是实时的，即使我通过计时器或类似方法调用SP.
乍一看，我需要一种经常调用SP的方法而又不会失去速度
希望伙计们发送他们的想法

Hi i need to put a feature to my Web Application Which Provide On line Monitoring to a Table(For example Prodocts)

in my last Projects i call the Coresponding Store Procedure and the Close the connection after using. but that isn''t Real Time Even if i call the SP by a timer or something like that.
at glance i need a way to call SP Frequently with out losing the speed
hope Guys send their idea

推荐答案

哇，这是一本必读的书！就在当场:
Silverlight应用程序有关数据库状态更改的通知 [

Wow this one is a must read for you! Right on the spot:
Notification of Silverlight Applications about Database State Changes[^]

Best Regards,

Manfred

似乎你没有我的目的... :(
我的意思是我需要与数据库保持实时同步
换句话说就是在页面上实时显示记录数".
希望清楚...:-O

it seem you don''t got my purpose... :(
i mean that i need to stay real time with DataBase
in other word showing Record count on the page in real time.
hope it clear... :-O

这篇关于监视SQL DB上的表的数据(通过SQL Connection保持在线)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！