[Solved] Grid with Sorting/Filtering/Paging functionality

[Ankur Nigam]

Hello,

I am considering use "ASP.Net MVC Grid" in my project.

I have following requirement and would really like if anyone can send me sample for it with all the below listed functionality.

1. If no information is populated in Grid then render a message like "Choose a table from dropdown."
2. Sorting should be enabled.
3. Moving Columns (changing the order of columns by drag-drop using mouse) - if it is possible (no Custom implementation for the same.)
4. Filtering should be enabled.
5. Paging should be enabled. - With minimum load on SQL Server. For instance, if I have 10,000 records in databaes(for a given filtering condition) and paging is set to display 10 records per page, then SQL should return only required 10 records only; instead of returning all 10,000 records and then retrieving only required 10 records(which is internally done using LINQ via Grid automatically.)
6. AJAX Support. All paging/sorting/filtering should use AJAX.
7. Data can only be retrieved from code (and not by calling any webservice from JS/jQuery upon sorting/filtering operation.)
8. If there are multiple images being used/generated by your control, I would like it to be converted to CSS Sprite.
9. Customize the look and feel of the control by modifying its CSS. Also, are there different theme available for me to use?

Thanks.

[william]

No one is going to supply you with all this code. You must show that you have made some effort in trying to write your code. When we can see that you have made some attempt and have genuine code issues, then you will probably get some help. We are not here to do your homework for you.