update cache object when update sql database

[mrutyunjaya]

if (Cache["MyDataSet"]==null)
        {
 
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mtiladminConnectionString"].ConnectionString);
            SqlDataAdapter mydataadapter = new SqlDataAdapter("select   intproductid,vchproductname,vchproductacctype,vchprodacclogoimg from productmaster  order by  intproductid desc", con);
 
 
 
            mydataadapter.Fill(ds, "Authors");
 
            SqlCacheDependency dependency = new SqlCacheDependency("mtiladmin", "productmaster");
      //System .Web .Caching .CacheDependency   dependency=  new System.Web.Caching.CacheDependency(
      //Server.MapPath("MyDataSet.xml"));
 
            Cache.Insert("mydataset", ds, dependency);
 
//Cache.Insert("MyDataSet", ds, 
//    dependency, 
//    DateTime.Now.AddMinutes(2), TimeSpan.Zero, 
//    CacheItemPriority.High, null);
 
 
 
 
            viewgrid.DataSource = Cache["MyDataSet"] as DataSet ;
        viewgrid.DataBind();
        //Response.Write(" from table");
 
    }
    else if (Cache["MyDataSet"] != null)
{
   // DataView view = new DataView();
 
    DataSet ds1 = new DataSet();
    ds1 =Cache["MyDataSet"] as  DataSet ;
 
 
            //ds =  new DataSet(view);
            viewgrid.DataSource = ds1;
                viewgrid.DataBind();
                //Response.Write("from cache");
 
}

when i update row , cache object are not updating

[mrutyunjaya]

when i update row on first click it is not updataing , it shows previous data, on secon click it is updating


my ciode is

 public void bindgrid()
     {
 
         DataSet myCustomers;
         myCustomers = (DataSet)Cache["MyDataSet"];
 
         if (myCustomers == null)
         {
             SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mtiladminConnectionString"].ConnectionString);
             SqlDataAdapter mydataadapter = new SqlDataAdapter("select   intproductid,vchproductname,vchproductacctype,vchprodacclogoimg from productmaster  order by  intproductid desc", con);
 
             myCustomers = new DataSet();
             mydataadapter.Fill(myCustomers, "Customers");
             SqlCacheDependency dependency = new SqlCacheDependency("mtiladmin", "productmaster");
             Cache.Insert("MyDataSet", myCustomers, dependency);
 
 
         }
 
 
         viewgrid.DataSource = myCustomers;
         viewgrid.DataBind();
 
 
        ////////////////////////////////////
 
    }  }
 
 protected void viewgrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        //Cache["MyDataSet"]="" ;
 
        int ID = Int32.Parse(viewgrid.DataKeys[e.RowIndex].Values[0].ToString());
        TextBox txtpath1 = (TextBox)viewgrid.Rows[e.RowIndex].FindControl("txtprodname");
        TextBox txtpath2 = (TextBox)viewgrid.Rows[e.RowIndex].FindControl("txtproductacctype");
        TextBox txtpath18 = (TextBox)viewgrid.Rows[e.RowIndex].FindControl("txtprodacclogoimg");
        string query = "update productmaster set vchproductName='" + txtpath1.Text + "',vchproductacctype='" + txtpath2.Text + "',vchprodacclogoimg='" + txtpath18.Text + "' where intproductid=" + ID;
        SqlCommand cmd1 = new SqlCommand(query, con);
        cmd1.Connection.Open();
        cmd1.ExecuteNonQuery();
        viewgrid.EditIndex = -1;
 
        bindgrid();
    }

[Frinavale]

When you updated the row, did you update the XML file you are using as a dependency?

Have you seen these articles

• Caching with ASP.NET
• Data Caching

According to the second article, you can have an item evicted from the cache when a file changes....once the item is evicted you can recreate it.

[Frinavale]

In your code for updating:

You are updating the data source and then when you are finished you are binding (different/old) data to the GridView.

When you are binding the data to your GridView you are retrieving the data stored in Cache, not the data that you have just updated.

After updating, the data source will be evicted from Cache the next time someone attempts to access the page because you have changed the source. Since it's evicted, it will appear as Null/Nothing during the next request...when this happens your code is recreating the cached version of your data source.


Therefore, I would recommend not using the bindgrid() method when you are updating the row....you need to deal with the data source instead of the cached version of the data source in this section of your code.