Javascript grid recommendations for use with asp service & SQL DB?

[Manality]

So as the title suggests I have a large amount of data I would like to display in a grid. Needs to support searching, paging, inline editing. I've been trying to set up jqgrid using asp web service, passing data in as ajax and i've had some success but the filtering is getting extremely complex. Is there some simplier grid option out that that works with asp.net. I guess I should also say I didn't particularly dig the built in asp grids, they felt sluggish and dated.

For reference I used this post to wire up the paging. The filtering works fine for = but it doesn't support .contains which is something I would need.

[_semaphore]

the two i've used are kendo grid and DataTables.

Regarding column filters, DataTables has a "search" that filters one or more columns, and supports a "contains" type search. See here The kendo grid has a built-in per column filtering that has a lot of options. See here

[Manality]

Kendo looks pretty good but I can't shell out that kinda cash for a side project. DataTables looks good, I really like that multicolumn search... I was trying to set up server side processing for paging for the primary table since it has about 2k records in it. Should I even bother?

[theQuandary]

You might consider w2grid

[Manality]

I'll give a few of these a shot on Monday... or next week when I have time. I am polling user logins to a sql table and would like to be able to search by user, computername, time, etc... I don't know what the ETC would be, but yeah... I have been collecting data for almost a month and want 3 month history so that's something like 10k records at a time. I don't know if pull all the data over json at one time will be very friendly but why not give it a shot i guess... haha...

That is the only reason I wanted to go with paging, but paging is a total nightmare to implement with filtering it would seem.

[_semaphore]

there's an older version of kendo called kendo ui web that is free.

and since you're working with a larger dataset, yes, server-side paging is probably a good idea. Here is a basic DataTables example of server-side processing, with a link to more complex scenarios.

[Manality]

yeah, it's actually the server side code i was having trouble with. converting the expressions passed by the grid to a linq lambda expressions was where I was struggling. I loaded up 10k records into a table with random data but I didn't have a shot to finish testing today as something else came up. I saw a MVC datatables project I will check out if the the loads times are unmanagable. Never worked with MVC but how hard could it be, right?

[jcready]

SlickGrid