问题描述
所以我有一个更新面板内的列表视图
So I have a List View inside an Update Panel
Update Panel
List View
Email 1
Email 2
Email 3
...
我试图做同样的GMAIL ASP.NET中的收件箱中,只有我与挣扎是如何检测数据库的更改(例如,当发送新信息)和Push该消息到ListView中模拟用户收到新邮件(就像Gmail并)
I'm trying to do an inbox similar to GMAIL in ASP.NET, the only I'm struggling with is how to detect DataBase Changes (ie when a new message is sent) and Push that message into the ListView to simulate that the user has received a new message (just like gmail does)
我如何使用SignalR检测数据库更改以及使用SignalR它们推入列表视图?这可能吗?
How do I use SignalR to detect database changes and push them into the List View using SignalR? Is it possible?
推荐答案
如果您正在使用SQL Server请点击此链接。的
If you are using Sql Server follow this link. http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency
基本上,它使用认购改变SQL Server中。
It basically uses SqlDependency to subscribe changes in Sql Server.
如果您不使用SQL Server,你必须手动完成。而对于视图方面,你可以使用KnockoutJS或anngular轻松名单进行修改。
If you aren't using Sql Server you have to do this manually. And for view side you can use KnockoutJS or anngular for easy list modification.
//Set up dependency
protected void Application_Start()
{
//...
SqlDependency.Start(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
}
protected void Application_End()
{
SqlDependency.Stop(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
}
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
这篇关于Asp.Net信号R - 检测数据库中的变化? Asp.net Web窗体的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!