100分求助一个SQLServer2005的查询通知的问题!!!

[xiaosonl]

Global.asax:
void Application_Start(object sender, EventArgs e)
{
// 在应用程序启动时运行的代码
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
System.Data.SqlClient.SqlDependency.Start(connString);
}

----------------------------------------------------------
public class Data
{
public Data()
{
//
// TODO: 在此处添加构造函数逻辑
//
}

public List<string> GetData()
{
List<string> data = HttpRuntime.Cache["Data"] as List<string>;
if (data == null)
{
data = new List<string>();
LoadAndCache(data);
}

return data;
}

public void ReLoadData(string key, object item, CacheItemRemovedReason reason)
{
List<string> data = new List<string>();
LoadAndCache(data);
}

private void LoadAndCache(List<string> data)
{
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string sql = "SELECT UserUid, [Name], UserID, [Password] FROM dbo.[User]";
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql, conn);

conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dr.Read())
{
data.Add(dr.GetString(2));
}
}

//注册查询通知,方案一
SqlCacheDependency dep = new SqlCacheDependency(cmd);
HttpRuntime.Cache.Insert("Data", data, dep, Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, CacheItemPriority.NotRemovable,
new CacheItemRemovedCallback(ReLoadData));

//方案二
//SqlDependency dep2 = new SqlDependency(cmd);
//HttpRuntime.Cache.Insert("Data", data);
//dep2.OnChange += new OnChangeEventHandler(dep2_OnChange);

conn.Close();
data = HttpRuntime.Cache["Data"] as List<string>;
}

void dep2_OnChange(object sender, SqlNotificationEventArgs e)
{
List<string> data = new List<string>();
LoadAndCache(data);
}
}

源码如上,VS2005SP1+VS2005,只有当VS的Development停止的时候,才会引发ReLoadData方法,而User表的数据变化却并不会引发ReLoadData方法!

[xiaosonl]

自已顶一下,实在很急这个问题

[sendling]

我顶,呵呵,不会没有办法

[shrekye]

帮忙顶

[xiaosonl]

多谢帮顶!

[hydra_cc]

hai 不会 帮d

[xiaosonl]

跪求高手!!!

[xiaosonl]

送分啊,没人要吗

[Ijingjing]

那是必须的User表变了 当然不会引起查询 你应该换个方法 货思路

[qq22345111]

xiaosonl



等　级：
结帖率：33.33%