This is a migrated thread and some comments may be shown as answers.

how to refresh a huge grid if only few data have been changed

2 Answers 90 Views

Grid

This is a migrated thread and some comments may be shown as answers.

2 Answers, 1 is accepted

answered on 18 Nov 2012, 08:42 PM

I'm assuming you're already using paging on your results? You might try caching the results then refreshing only those rows that don't have cached results. In the MVC Example, they do this inside their repository for the orders, but if it needed to be a more granular cache I think you would be able to simply modify the example as needed. I use HttpContext.Session for items that could be different per user and .Cache for application-wide items that can be stored on the server. Hope this helps!

SessionClientOrderRepository.cs:

public static IEnumerable<ClientOrderViewModel> All()

{

IEnumerable<ClientOrderViewModel> result = HttpContext.Current.Session["orders"] as IEnumerable<ClientOrderViewModel>;

if (result == null)

{

HttpContext.Current.Session["orders"] = result = new NorthwindDataContext().Orders

.Select(o => new ClientOrderViewModel

{

OrderID = o.OrderID,

OrderDate = o.OrderDate ?? DateTime.Now,

ShipAddress = o.ShipAddress,

ShipCountry = o.ShipCountry,

ShipName = o.ShipName,

ContactName = o.Customer.CompanyName,

EmployeeID = o.EmployeeID ?? 0,

Employee = new ClientEmployeeViewModel {

EmployeeName = o.Employee.FirstName + " " + o.Employee.LastName,

EmployeeID = o.EmployeeID ?? 0

}

}).ToList();

}

return result;

}