This post is directed towards .Net developers interested in setting up a server-side processed DataTable. I’m assuming that if you’re reading this post, you’re already familiar with DataTables, a very powerful jQuery plugin that allows a developer to create responsive, full-featured data grids with pagination, filtering, etc.
The problem with most implementations of DataTables written by .NET developers is that they’re typically written using some sort of repeater. In Web Forms, you can use an ASP.Net Repeater. In MVC with Razor, you can use a @foreach loop to display multiple rows.
These implementations work best with limited data sets. Larger sets of data leads to slow-loading pages, and consequently, end-user dissatisfaction. If this is the problem that you’ve run into, read on for a solution.