0
I am using Datatables.net with server-side via Webform and Ado.net.
I need to paginate the data (sort, filter, etc), I see 2 possibilities:
- via stored procedure
ou
- via DataView
The problem is that when using Datatables.net it sends me 62 fields through Querystring in which I will have to deal with and assemble the possible pages, I believe that via Storedprocedure it will be a monster to do this.
Usually the amount of records vary between 400 to 3 thousand.
NOTE: It is not very feasible to put the Entity Framework only to solve this problem.
What do you recommend? I am able to start developing in Dataview with Rowfilter, Sort, etc.
NOTE²: Today Datatables calls a Generic Handler in which I make queries in the database and return the result via JSON
It is feasible to put the Entity Framework. It is only the way of doing that requires some care. You can put some code in your question?
– Leonel Sanches da Silva
The doubt I think is more theoretical, I do not see which code to put, I thought to do via Dataview and can make the filter via Linq or direct in Dataview.
– Dorathoto
Well, opinionated speaking, I would say you’d better get out of Webforms, then the way would be by using Datatables + Ajax, but this will take some work.
– Leonel Sanches da Silva
is that my system needs to be 'updated' but he is giant in webform, from a despair to think about migrating it...rs makes freela Gypsy?
– Dorathoto
Do. Get in here and talk to us.
– Leonel Sanches da Silva