Real Time data

奋斗1314

现在我要做一个webbase using asp.net 来呈现real time data which is get from MSSQL. 我想问怎样当那个table的data有改变，webpage will auto refresh instead of use timer to control?

keatkeat87

u mean websocket ?

奋斗1314

keatkeat87 发表于 24-2-2014 09:47 AM
u mean websocket ?

yes... i have find out the websocket can support on this...but i not sure how is going on...do you have any idea? any limitation?

keatkeat87

之前上课的时候有略看过一下说明书，不过没真真开发过 .
帮不上什么忙 。
我读的是asp.net ，需要  iis8 才能支持 , 网上可以找到挺多web socket plugin 的，java node.js 都有。你去看看吧。

yan13

奋斗1314 发表于 24-2-2014 10:51 AM
yes... i have find out the websocket can support on this...but i not sure how is going on...do you ...

google 一下 SignalR吧.
也可以做online chat, 比如customer service.
如果同一時间用戶不多,或只是學校作業,就不理那麼多.不然的話可以讀一下Server Broadcast.

gkheng2003

1) 如果你能 control source data, use broadcast: websocket| SignalR
2) 如果你不能 control source data, maybe can try : trigger|CLR?

奋斗1314

谢谢大家的回复。。。actually this program is need to use in my company. SignalR i have google before, but havent start to understanding in deep. Besides that, what is use broadcast? yup, i can control the source data, currently i use trigger in the table and fetch into another table in another server, so that the web base will directly capture the data in this new server.

yan13

google signalr push database changes
這2個看來是你要的
http://www.asp.net/signalr/overv ... ast-with-signalr-20
http://stackoverflow.com/questio ... e-asp-net-web-forms