manually updating database table values are not reflecting in webpage - aspnet mvc

Question

i noticed some wierd problem i.e i have built a web page on which information comes from database table named "school", when i change some data in that table manually from mssql the web page data is still same as previous, its not gettin' changed, i dn't know how it is possible.

this is my action controller


    public ActionResult SchoolDetails(string id,_ASI_School schoolDetails)
    {
            schoolDetails = SchoolRepository.GetSchoolById(id);
            return View(schoolDetails);
     }

This is my view


    =Html.Encode(Model.SchoolName)
    = Html.Encode(Model.SchoolAddress) 
    = Html.Encode(Model.SchoolEmail)

code for GetSchoolById()..


   private static ASIDataContext db = new ASIDataContext();
   public static _ASI_School GetSchoolById(string schoolId)
   {
            return db._ASI_Schools.SingleOrDefault(x => x.SchoolId == schoolId);
   }

Did you refresh the web page in your web browser after changing the database? — Adrian Grigore
– Adrian Grigore, Commented May 15, 2010 at 10:21
@Mattias Jakobsson, i cleared all cache of browser, even i tried to open in various browser, but same issue. — FosterZ
– FosterZ, Commented May 15, 2010 at 11:31
It does not seem to be a complicated scenario, so debugging it should not be too difficult for you. If you still require help, you might want to post some source code (view, controller, underlying layers) — Adrian Grigore
– Adrian Grigore, Commented May 15, 2010 at 11:38

Chris Woolum · Accepted Answer · 2011-06-03 05:50:45Z

1

try putting this above your SchoolDetails ActionResult

[OutputCache( Duration=0)]

MVC does some really nice server side caching as well that clearing the cache on the browser does not fix.

answered Jun 3, 2011 at 5:50

Chris Woolum

2,92921 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

manually updating database table values are not reflecting in webpage - aspnet mvc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related