Dynamic AJAX based data table.

[SPanicker]

How can I design an efficient AJAX based dynamic table using .NET ? Do I necessarily need to use JQuery / Prototype libraries or plug-ins to achieve this?

I am referring to similar implementation : www.coupontom.com

I believe this is not possible using the existing AJAX control toolkit.

[Frinavale]

You don't have to use JQuery if you don't want to. I haven't used it yet...

You could create a Web Service that returns the results based on what's being typed. You could use Ajax to consume the Web Service and display it as Table :)

For this, I only know how to do it using Ajax.NET (the Microsoft Ajax .NET Library). Check out this article: Extreme ASP.NET: Client-Side Web Service Calls with AJAX Extensions.

Or you could try using JQuery to do it...I'm sure there's a way but I've never done it before.

-Frinny

[SPanicker]

Thanks for the update Frinny.

Yes using a web service call I might be able to do that but again am not sure of various other factors like,

1. Being able to sort the result set - either this should be a server side call for every click so then what about efficiency ?

2. Also I have fields of length 100 char and about 10000 records. Performing a SQL query for each and every alphabet typed might hamper the efficiency on the server side. moreover passing these results over SOAP XML format may lead bandwidth issues.

How about performing a single query on page load for all 10000 or so records cache them on client side and make use of javascript or jquery lib to sort etc.? Also the number of webservice calls and DB queries and request response time can be cut short. Again I am not sure of the load the server might exp. for fetching and returning 10000 or so records as web service response.

[Frinavale]

I don't see any reason why you can't cache in both the server and the client...

I think that sorting, if using web services, would probably be best done client side.

-Frinny