Discussion on ASP.NET JQuery Datatables Server Side Integration


webyacusa supports this item


13 comments found.

do you have vb.net coding?

The VB.net version will be released on April 13th 2015. Thanks.

Thank you! I will wait for it.

Does this work with Microsoft edge and also is this a full server component what about entity framework and filtering support ?.

Yes, this works with MS Edge. Yes, the code shows how to use filtering and it does uses EF.


can you provide code with web forms rather than MVC for asp.net C#.

Regards, Vivek

I am confused… the code is 100% web forms, there is no MVC at all.

Hi, I have gone through the code, but just quick question, can you give me LoadCustomer.ashx without entity framework, as i m not using entityframework

Sorry, but this was specifically tailored to work with EF, to avoid having to write custom SQL server instructions and/or stored procedures. Any further customization would need to be discussed as an outside custom development. Thanks.

HI, I downloaded the latest version and I found that new four buttons are added. When I clicked PDF button in IE am getting the below error but working fine in chrome.

Unhandled exception at line 37, column 9921 in https://cdn.datatables.net/u/bs/jszip-2.5.0,pdfmake-0.1.18,dt-1.10.12,b-1.2.0,b-html5-1.2.0,b-print-1.2.0/datatables.min.js

0×800a01b6 – JavaScript runtime error: Object doesn’t support property or method ‘defineGetter

How to fix this? Thanks

What version of IE are you getting this error?

IE 10


I want to use your product’s with SQL server. When i change CustomerModel.admx and update the model from SQL, many errors occur.

How can i use with SQL, or do you have with sql version?

i’m waiting your answer?

Thank you.

Umit S.

Hello There,

I have bought your source code few days ago and it is works perfect. Only I miss the entries number selection options. I tried to set manually how many records displayed in a page at GetCustomer.ashx.cs and set “short lengthIntValue = 20; //By default we want to take 10 elements” but it same only display 10 records in a page. There is any option to display a Show ….... entries selection box?

Kind Regards Istvan

Yes, there is, you want to make sure to add the following to the page, where the definition for the datatable is:

“pageLength”: 10

Hope this helps,

Hi Dear For exporting(pdf,excel,print) data when paging is applied currently it is exporting only one page not all pages, Kindly let me know how to export all the pages.

Sorry, that’s not currently possible, perhaps in the next version it will. I’ll keep you posted,

Awesome work. GLWS


I like your product. I was able to hook to my local SQL Server 2014 using Visual Studio 2015.

The Update & Delete work, but I am getting an error when I try to Add a record.

The error message is: Unknown server issue.Exception generated: An error occurred while updating the entries. See the inner exception for details.

The Output panel displays: Exception thrown: ‘System.Data.Entity.Infrastructure.DbUpdateException’ in EntityFramework.dll.

Any help would be appreciated.



My first comment was on the C# version of the product.

I just tried the VB version using Visual Studio 2015 and SQL Server 2014 and I updated the .edms record so it looks at the database.

If this case, the Add function does not add a record, but updates the first row of data in the database.

I can see the jQuery code is identical in both C# and VB, but functions differently in each version of the product.

I look forward to your insights.



I think the problem seems that the table does not have the primary key setup correctly. Could it be possible to you to get the exact message from the inner exception if you enter in your Visual Studio in debug mode?


Osman38 Purchased

f48f06c8-6d53-4ecd-a55e-1f65e30295a0 //Code

Hi I got the “Datables.net JQuery Plugin on ASP.NET” program that you did. But there is no database connection. An error occurred. The program is not working. I want your support in this regard. Thank you.

Hi, can you give me more details? What error did you got?

Hi does this work with ASP MVC 5 (not web forms) MVC Views/razor


Currently is webforms only, but I will release an MVC version in March. Thank you for asking.

hi, just following up, if you have any plan for this. Also, will it have options for AJAx with—approve/reject buttons in a column, Add New Row, Edit row/save row, delete row.

I need support for checkbox/radio boxes and dropdownlists (Cascading droop down list, for e.g. select Contry->State->cty)

Sorry, the new version will be delayed, I’ve been out of commission for a few weeks, will back to work as soon as possible. Thank you for your support!


I am interestred on your product, “ASP.NET JQuery Datatables Server Side Integration” and have few questions about it.

- How the data is pulling from database? - Does it work with sql procedure? - What are you using to display data on tabular?

Thank you

To your questions:

1.- It uses Entity Framework to access a SQL Server 2.- Yes, you can create stored procedures if you want to, that is possible using Entity Framework 3. I am using Datatables: https://datatables.net/

Hope this helps,