以字符串变量作为缓存依赖，缓存数据-优快云博客

本文介绍了一种使用缓存技术优化数据获取过程的方法，通过实现数据的局部存储和复用，显著提高了数据加载效率。重点展示了如何利用Cache对象进行数据的存储与检索，并在数据变化时更新缓存内容，确保了数据的一致性和性能优化。

protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void TextBoxIntelligent1_Focus(object sender, wzh.myWebControlsLib.TextBoxIntelligent.FocusEventArgs e)
        {
            string arg = e.tbText;
            if (Cache["dep"] == null)
            {
                Cache["dep"] = arg;
            }
            else if ((string)Cache["dep"] != arg)
            {
                Cache["dep"] = arg;
            }

            String[] dependencyKey = new String[1];
            dependencyKey[0] = "dep";
            CacheDependency dependency = new CacheDependency(null, dependencyKey);

            if (Cache["Data"] == null)
            {
                Cache.Insert("Data", getData(arg), dependency);
            }

TextBoxIntelligent1.DataTable = (DataTable)Cache["Data"];

}

        public DataTable getData(string arg)
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["sqlConn"]);
            con.Open();
            SqlDataAdapter ad = new SqlDataAdapter("select [name] from tb_name where [name] like'" + arg + "%'", con);
            DataSet ds = new DataSet();
            ad.Fill(ds, "city");
            DataTable dt = ds.Tables["city"];
            con.Close();
            ad.Dispose();
            return dt;
        }