Server side processing not working with C#.NET and large datasets

DiabloRito

Hello,

I have a working datatable on my website until I added 200.000 rows to my sql table.
The data is not showing at all. I tried to open the ajax response in my browser but it gives me an xml error.
I looked in the forum and learned about server-side processing.
I added that option and i got an ajax error saying that i should visit datatables website for more information about the error

I removed my 200.000 rows and everything is working again.

is there something specific for the C# .NET in order to get server side processing working ?

Regards.

DiabloRito

I tried to use server side processing with few data using a where condition but it s not working.
At least i could visualize my returned ajax data in the browser and i saw
{"draw":null,"data":[{"DT_RowId":"row_1363014",.....my data

I think for server side processing to get working the draw option should not be null ?
how can i fix that ?

allan

I think for server side processing to get working the draw option should not be null ?

Correct. It should be an integer number. It should basically be the draw parameter that DataTables sends to the server (parsed as an integer for security) and then passed back. The manual has more details.

Allan