将数据从数据集过滤到网格的最佳方法 [英] best method to Filter data from dataset into a grid

问题描述

HI ,,,



我有一个客户详细信息表格，表格中显示超过10k的记录，我有基于预订的过滤选项日期和州或城市或国家。每当我更改选择标准时，它可能是日期或城市或州，网格返回到数据库并取回它，这比正常时间花费太多时间。



任何人都可以找到最佳过滤方式的解决方案。



Tnks

,,

I have a Customer details table with a grid in a form which displays more than 10k records and i have filter options based on the Booking dates and State or Citywise or the country. Whenever i will change the Criteria for selection,it might be dates or city or state , the Grid going back to the database and fetching it back which takes too much of time than the normal.

Can anybody has the solution for the Best way for Filtering.

Tnks

推荐答案

可以找到另外一个带有解释的代码示例这里 [ ^ ]

An alternative example that walks through the code with explanations can be found here[^]

点击这里

做完R& D后我觉得缓存数据是过滤数据的最佳方法，这反过来又提高了网页的性能和速度....



根据研究数据缓存可以保存DataSet对象.. 。



ASP.NET缓存



希望它能正常工作

After doing R&D i felt Caching the data is the best way for filtering the data which in turn increase performance and speed of a web page....

As per the Study Data Cache can hold the DataSet object...

ASP.NET Caching

Hope it will works fine

这篇关于将数据从数据集过滤到网格的最佳方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！